应用XML技术实现报表打印方案的设计与实现

笔者为了能够快速实现简单的报表打印，设计了下面的方案。编写一个通用打印页面，要打印报表将参数写入一个XML文档，调用页面XMLReport.aspx?report=报表名，即可完成报表的制作

3.1 创建自定义的XML报表文件

XML主要用来描述打印报表的名称，数据来源，格式，分页打印等信息，具体标签可自己定义，下面是笔者针对会员管理系统报表打印所制定的XML文档：

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>

         <Sql>Select Count(MemberID) As [Member Count], ''''$''''+convert(varchar(12),Sum(FeesPaid)) As [Fees Total] From Members;</Sql>

         <PageSize></PageSize>

 &

[1] [2] [3] [4]  下一页