.NET匯出水晶報表功能實現代碼-CSDN博客

本文链接：https://blog.csdn.net/jackterq/article/details/4837860

1. 先在Web.config中作如下配置:

Web.config

<?xml version="1.0"?> <configuration> <configSections> ....... <appSettings> ...  <add key="rptSeverName" value="localhost"/> <add key="rptUser" value="testId"/> <add key="rptPwd" value="testPwd"/> </appSettings> <connectionStrings/> <system.web> <compilation> <assemblies>  <add assembly="CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/> <add assembly="CrystalDecisions.ReportSource, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/> <add assembly="CrystalDecisions.Shared, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/> <add assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/> <add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/> <add assembly="CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/> <add assembly="CrystalDecisions.Enterprise.InfoStore, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/> ...</assemblies> </compilation> </system.web> </configuration>

2.報表匯出處理頁面:

report.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="report.aspx.cs" Inherits="report" %> <%@ Register Assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" Namespace="CrystalDecisions.Web" TagPrefix="CR" %> <!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>顯示報表</title> <link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" mce_href="aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css" rel="stylesheet" type="text/css" /> </head> <body> <form id="form1" runat="server"> <div align=center> <cr:crystalreportviewer id="CrystalReportViewer" runat="server" autodatabind="true" Height="50px" Width="350px" DisplayGroupTree="False"></cr:crystalreportviewer> </div> </form> </body> </html>

3.報表匯出處理後台邏輯代碼:

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; using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; using Com.Everunion.Util; public partial class report : System.Web.UI.Page { //報表檔案 private ReportDocument reportdoc; //log private static readonly log4net.ILog log = log4net.LogManager.GetLogger(typeof(report)); /// <summary> /// 加載 /// </summary> /// <param name="sender">物件</param> /// <param name="e">事信誓旦旦</param> protected void Page_Load(object sender, EventArgs e) { ConfigureCrystalReports(); } /// <summary> /// 設定報表資訊 /// </summary> private void ConfigureCrystalReports() { reportdoc = new ReportDocument(); string rptName = Request.Params["rpt"]; string reportPath = Server.MapPath("rpt/" + rptName); reportdoc.Load(reportPath); //設定參數 for ( int i = 0; i < reportdoc.ParameterFields.Count; i ++ ) { string key = reportdoc.ParameterFields[i].Name; reportdoc.SetParameterValue(key, StringUtil.ToStr(Request.Params[key])); } //取得報表DataSource連結參數 String rptServerName = ConfigurationManager.AppSettings["rptSeverName"].ToString(); String rptUser = ConfigurationManager.AppSettings["rptUser"].ToString(); String rptPwd = ConfigurationManager.AppSettings["rptPwd"].ToString(); //設定數據源 TableLogOnInfo logonInfo = new TableLogOnInfo(); foreach ( CrystalDecisions.CrystalReports.Engine.Table table in reportdoc.Database.Tables ) { logonInfo = table.LogOnInfo; logonInfo.ConnectionInfo.ServerName = rptServerName; logonInfo.ConnectionInfo.UserID = rptUser; logonInfo.ConnectionInfo.Password = rptPwd; table.ApplyLogOnInfo(logonInfo); } //直接在瀏覽器上顯示 //CrystalReportViewer.ReportSource = reportdoc; //匯出至檔案中 //報表類型 string rptType = Request.Params["rptType"].Trim(); //預設報表名稱 string filename = rptName.Replace(".rpt", ""); //PDF格式 if ( rptType.ToUpper().Equals("PDF") ) { reportdoc.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, filename); } //EXCEL格式 else if ( rptType.ToUpper().Equals("XLS") ) { reportdoc.ExportToHttpResponse(ExportFormatType.Excel, Response, true, filename); } //HTML格式 else if ( rptType.ToUpper().Equals("HTML") ) { reportdoc.ExportToHttpResponse(ExportFormatType.HTML32, Response, true, filename); } //DOC格式 else if ( rptType.ToUpper().Equals("DOC") ) { reportdoc.ExportToHttpResponse(ExportFormatType.WordForWindows, Response, true, filename); } //RTF格式 else if ( rptType.ToUpper().Equals("RTF") ) { reportdoc.ExportToHttpResponse(ExportFormatType.RichText, Response, true, filename); } else Response.Write("錯誤的報表格式:" + rptType); } }

4.調用方法: widow.open("report.aspx?rpt=sample.rpt&rptType=xls&params=....");

rpt水晶為報表名稱:後綴名為.rpt

rptType為報表類類型,如: xls,pdf,doc,rtf等....

params為報表所需的內部參數,根據報表參數需要自行添加