An XML-based report development tool that allows you to design reports and call APIs to print and preview reports. It supports distributed reports and facilitates report storage and forwarding. You can embed VBScript in a report to easily access the variables of VB and VC, and Access ActiveX-compliant controls such as COM components and ADO.
Including the visual report development interface, report syntax interpreter, and COM-based components. Perfect solution for Distributed reports
Syntax:
<? Xml version = "1.0" encoding = "GB2312"?>
<! DOCTYPE report SYSTEM "print_report.dtd">
<Report name = 'report'>
<Report_script>
Dim rs, con, SQL, lsh
Dim temp
Set con = CreateObject ("ADODB. Connection") 'create An ADO component
Con. ConnectionString = "DBQ = D: uml_projecteportdemoaspeport.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 = '000000' font_italic = '0' font_underline = '0' top = '10' left =' 78 'width = '26' height = '5'>
Score list
</Text>
</Report_head>
<Page_head height = '10'> <! -- Report header -->
<Text name = 'vfptext' font_name = ' 'font_size = '9' font_weight = '000000' font_italic = '0' font_underline = '0' top = '2' left =' 162 'width = '6' height = '3'>
Total
</Text>