ASP.NET利用Crystal Report來匯出Word,Excel,PDF檔

2008-07-16

56650
0
ASP.NET
2008-07-21

最近同事問到這個問題...小弟去找了一下資料..
教大家如何使用Crystal Report匯出Word,Excel,PDF檔

最近同事問到這個問題...小弟去找了一下資料..

教大家如何使用Crystal Report匯出Word,Excel,PDF檔

首先要先準備好一個Crystal Report檔(CrystalReport.rpt),如下圖所示(因為測試用,所以只放一張圖)

接下來就是程式的部分

asp.net(c#)

Report.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Report.aspx.cs" Inherits="Report" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Report</title> </head> <body> <form id="form1" runat="server"> <div> <asp:Button ID="Button1" runat="server" Text="Export Word" OnClick="Button1_Click" /><br /> <br /> <asp:Button ID="Button2" runat="server" Text="Export Excel" OnClick="Button2_Click" /><br /> <br /> <asp:Button ID="Button3" runat="server" Text="Export PDF" OnClick="Button3_Click" /></div> </form> </body> </html>

Report.aspx.cs

using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class Report : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Export(CrystalDecisions.Shared.ExportFormatType FileType, string FileName)//使用ExportToStream方式匯出 { //create CrystalReport object CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); //load report report.Load(Server.MapPath("CrystalReport.rpt")); System.IO.Stream stream = report.ExportToStream(FileType); byte[] bytes = new byte[stream.Length]; stream.Read(bytes, 0, bytes.Length); stream.Seek(0, System.IO.SeekOrigin.Begin); //export file Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("content-disposition", "attachment;filename=" + FileName);//excel檔名 switch (FileType) { case CrystalDecisions.Shared.ExportFormatType.Excel: Response.ContentType = "application/vnd.ms-excel"; break; case CrystalDecisions.Shared.ExportFormatType.PortableDocFormat: Response.ContentType = "application/pdf"; break; case CrystalDecisions.Shared.ExportFormatType.WordForWindows: Response.ContentType = "application/vnd.ms-word"; break; } Response.OutputStream.Write(bytes, 0, bytes.Length); Response.Flush(); Response.Close(); } protected void Export(CrystalDecisions.Shared.ExportFormatType FileType, string FileName, bool ExportModel)//使用ExportToHttpResponse方式匯出 { //create CrystalReport object CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); //load report report.Load(Server.MapPath("CrystalReport.rpt")); report.ExportToHttpResponse(FileType, Response, ExportModel, FileName);//ExportModel{true:匯出檔案,false:用browse開啓檔案} } protected void Button1_Click(object sender, EventArgs e) { //使用ExportToStream方式匯出 //Export(CrystalDecisions.Shared.ExportFormatType.WordForWindows, "test.doc"); //使用ExportToHttpResponse方式匯出 Export(CrystalDecisions.Shared.ExportFormatType.WordForWindows, "test.doc", true); } protected void Button2_Click(object sender, EventArgs e) { //使用ExportToStream方式匯出 //Export(CrystalDecisions.Shared.ExportFormatType.Excel, "test.xls"); //使用ExportToHttpResponse方式匯出 Export(CrystalDecisions.Shared.ExportFormatType.Excel, "test.xls", false); } protected void Button3_Click(object sender, EventArgs e) { //使用ExportToStream方式匯出 //Export(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, "test.pdf"); //使用ExportToHttpResponse方式匯出 Export(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, "test.pdf", true); } }

執行結果：

匯出結果：

參考網址：

http://www.dotblogs.com.tw/puma/archive/2008/06/26/1673.aspx
http://dev.21tx.com/2004/10/13/12319.html
http://www.wangchao.net.cn/bbsdetail_575844.html

回首頁