VC、IE、ASP環境下打印、預覽的完美解決方案
2024-05-04 11:06:31
供稿:網友
一種基于xml的報表開發工具,它支持從設計報表,調用api打印、預覽,能支持分布式報表、方便報表的存儲、轉發。在報表中能嵌入vbscript,能方便地訪問vb,vc的變量,能訪問com組件、ado等遵循activex標準的控件。
包括報表可視化開發界面、報表語法解釋器,基于com的組件。是分布式報表的完美解決方案
語法如下:
<?xml version="1.0" encoding="gb2312" ?>
<!doctype report system "print_report.dtd" >
<report name='報表'>
<report_script>
dim rs,con,sql,lsh
dim temp
set con =createobject("adodb.connection") '創建ado組件
con.connectionstring = "dbq=d:/uml_project/report/demo/asp/report.mdb;driver={microsoft access driver (*.mdb)};"
con.open
set rs =createobject("adodb.recordset")
sql="select * from cj,student where cj.id=student.id "
rs.open sql,con,1,3
</report_script>
<report_head height='20'>
<text name='vfptext' font_name='宋體' font_size='14' font_weight='700' font_italic='0' font_underline='0' top='10' left='78' width='26' height='5' >
成績明細表
</text>
</report_head>
<page_head height='10'> <!--報表頭-->
<text name='vfptext' font_name='宋體' font_size='9' font_weight='100' font_italic='0' font_underline='0' top='2' left='162' width='6' height='3' >
合計
</text>
</page_head>
<page_body height='10'>
<text name='vfptext' font_name='宋體' font_size='9' font_weight='100' font_italic='0' font_underline='0' top='2' left='15' width='25' height='4' >
<report_script>
report.write cstr(rs("xm"))
</report_script>
</text>
</page_body>
</report>