一种基于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>