Design and implementation of the report printing solution using XML technology
In order to quickly implement simple report printing, I designed the following solution. Compile a general print page. To print the report, write the parameters to an XML document and call XMLReport. aspx? Report = report name to complete report creation
3.1 create a custom XML report file
XML is mainly used to describe the name, data source, format, paging printing, and other information of the printed report. Specific labels can be defined by myself. The following is an XML document developed by the author for printing reports of the member management system:
MemberList. xml
<? Xml version = "1.0" encoding = "UTF-8"?>
<XmlReport>
<Page>
<Title> Member Information </Title>
<ApplyXSLT> </ApplyXSLT>
</Page>
<Report>
<Title> Member List </Title>
<TableName> MemberList </TableName>
<SQLdataConnection> Data Source = localhost; User ID = sa; password =; Initial Catalog = XMLReport; </SQLdataConnection>
<OleDbConnection> </OleDbConnection>
<SQL> Select MemberID, prefix + '. '+ firstname + ''+ surname AS [Member Name], CityOrTown, State, PostCode,' $ '+ convert (varchar (12), FeesPaid) As Fees From Members; </SQL>
<PageSize> 10 </PageSize>
</Report>
<Report>
<Title> Member Summary </Title>
<TableName> MemberSummary </TableName>
<SQLdataConnection> Data Source = localhost; User ID = sa; password =; Initial Catalog = XMLReport; </SQLdataConnection>
<OleDbConnection> </OleDbConnection>
