為了能快速實現簡單的報表列印,這裡設計了一套通用方案:編寫一個通用列印頁面,將要列印的報表參數寫入一個 XML 文件,呼叫頁面 XMLReport.ASPX?report=報表名,即可完成報表的製作。
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>
</Report>
</XMLReport>
標籤說明:
讀者還可以自訂更精確的標籤來控制報表。
在 Page_Load 時讀取要列印的報表名:
xmlFile = Request.QueryString["report"].ToString() + ".XML";
接著透過 DataSet 讀取 XML,並依據其中的報表定義動態綁定資料:
private void BindReports()
{
DataSet dsXML = new DataSet();
try
{
dsXml.ReadXml(Server.MapPath("Reports\\" + XMLFile));
DataTable dtPage = dsXML.Tables["Page"];
DataTable dtReport = dsXML.Tables["Report"];
labelPageTitle.Text = dtPage.Rows[0]["Title"].ToString();
for (int i = 0; i < dtReport.Rows.Count; i++)
{
GetLabel(i).Text = dtReport.Rows[i]["Title"].ToString();
if (dtReport.Rows[i]["SQLdataConnection"].ToString() != String.Empty
|| dtReport.Rows[i]["Sql"].ToString() != String.Empty
|| dtReport.Rows[i]["OleDbConnection"].ToString() != String.Empty)
{
DataGrid dg = GetDataGrid(i);
if (dtReport.Rows[i]["PageSize"].ToString() != String.Empty)
{
// 分頁列印
dg.AllowPaging = true;
dg.PagerStyle.Mode = PagerMode.NumericPages;
dg.PagerStyle.PageButtonCount = 10;
dg.PageSize = Convert.ToInt32(dtReport.Rows[i]["PageSize"].ToString());
}
DataSet ds = new DataSet();
// 從 Report.XML 讀取資料來源資訊
if (dtReport.Rows[i]["SQLdataConnection"].ToString() != String.Empty)
{
// 資料提供者為 SQL Server
SqlConnection Conn = new SqlConnection(dtReport.Rows[i]["SQLdataConnection"].ToString());
SqlDataAdapter myDataAdapt = new SqlDataAdapter(dtReport.Rows[i]["Sql"].ToString(), Conn);
myDataAdapt.Fill(ds, dtReport.Rows[i]["TableName"].ToString());
}
else if (dtReport.Rows[i]["OleDbConnection"].ToString() != String.Empty)
{
// 資料提供者為 OLE DB
OleDbConnection Conn = new OleDbConnection(dtReport.Rows[i]["OleDbConnection"].ToString());
OleDbDataAdapter myDataAdapt = new OleDbDataAdapter(dtReport.Rows[i]["Sql"].ToString(), Conn);
myDataAdapt.Fill(ds, dtReport.Rows[i]["TableName"].ToString());
}
// 用通用頁面顯示報表
dg.DataSource = ds;
dg.DataBind();
}
}
}
catch
{
labelPageTitle.Text = "The requested report could not be found";
}
}
需要在 XML 文件的 ApplyXSLT 標籤內加入對應的 XSLT 檔名,並製作相應的樣式表放在專案的 xslt 資料夾下即可。以下程式碼加入通用列印程式中:
if (dtPage.Rows[0]["ApplyXSLT"].ToString() != string.Empty)
{
// 用 XSL 顯示報表
XmlDataDocument xmlDoc = new XmlDataDocument(ds);
XslTransform xslTran = new XslTransform();
xslTran.Load(Server.MapPath("xslt\\" + dtPage.Rows[0]["ApplyXSLT"].ToString()));
XmlTextWriter writer = new XmlTextWriter(Server.MapPath("XSLTReports.ASPX"), System.Text.Encoding.UTF8);
xslTran.Transform(xmlDoc, null, writer);
writer.Close();
Response.Redirect("XSLTReports.ASPX");
}
套用 XSLT 樣式表可以製作專業的報表樣式,為方便製作,建議使用 XMLSpy 內建的 Stylesheet 工具。