水晶报表的导出和打印 Push

_miccretti

于 2017-11-26 20:42:00 发布

阅读量179

点赞数

CC 4.0 BY-SA版权

文章标签： ui c# 数据库

原文链接：https://yq.aliyun.com/articles/380856

本文介绍了一个基于 ASP.NET 的 Web 应用中 Crystal Reports 的使用方法，包括如何从数据库获取数据并填充到报表，以及如何实现报表的导出与打印功能。提供了多种导出格式选项，如 RTF、PDF、DOC 和 XLS，并详细展示了如何通过按钮点击事件触发这些操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

@ Register TagPrefix="cr" Namespace="CrystalDecisions.Web" Assembly="CrystalDecisions.Web, Version=10.0.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" %>

@ Page language="c#" Codebehind="Main.aspx.cs" AutoEventWireup="false" Inherits="CrystalPush.WebForm1" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

<title>WebForm1</title>

</HEAD>

<CR:CRYSTALREPORTVIEWER id="Crv" style="Z-INDEX: 101; LEFT: 16px; POSITION: absolute; TOP: 54px" runat="server" Height="50px" Width="350px" HasZoomFactorList="False" HasDrillUpButton="False" HasGotoPageButton="False" HasPageNavigationButtons="False" HasSearchButton="False"></CR:CRYSTALREPORTVIEWER>

<asp:Button id="btnPrint" style="Z-INDEX: 103; LEFT: 548px; POSITION: absolute; TOP: 15px" runat="server" Width="78px" Text="打印"></asp:Button>

<asp:Button id="btnExport" style="Z-INDEX: 102; LEFT: 434px; POSITION: absolute; TOP: 14px" runat="server" Width="78px" Text="导出"></asp:Button>

<asp:Label id="Label1" style="Z-INDEX: 104; LEFT: 26px; POSITION: absolute; TOP: 19px" runat="server">请选择导出格式：</asp:Label>

<asp:DropDownList id="ddlFormat" style="Z-INDEX: 105; LEFT: 188px; POSITION: absolute; TOP: 16px" runat="server">

<asp:ListItem Value="Rich Text (RTF)">Rich Text (RTF)</asp:ListItem>

<asp:ListItem Value="Portable Document (PDF)">Portable Document (PDF)</asp:ListItem>

<asp:ListItem Value="MS Word (DOC)">MS Word (DOC)</asp:ListItem>

<asp:ListItem Value="MS Excel (XLS)">MS Excel (XLS)</asp:ListItem>

</asp:DropDownList></FONT></form>

</body>

</HTML>

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.IO;

using System.Data.SqlClient;

using UseCrystal.CrystalPush;

using CrystalDecisions.CrystalReports.Engine;

using CrystalDecisions.Shared;

namespace CrystalPush

{

/**//// <summary>

/// WebForm1 的摘要说明。

/// </summary>

public class WebForm1 : System.Web.UI.Page

{

protected System.Web.UI.WebControls.Button btnExport;

protected System.Web.UI.WebControls.Button btnPrint;

protected CrystalDecisions.Web.CrystalReportViewer Crv;

protected System.Web.UI.WebControls.Label Label1;

protected System.Web.UI.WebControls.DropDownList ddlFormat;

myReport ReportDoc = new myReport();

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

string strProvider = "Server=(local);DataBase=myDatabase;UID=sa;PWD=111";

SqlConnection MyConn = new SqlConnection(strProvider);

MyConn.Open();

string strSel = "Select * from SaleOfCuntry";

SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel,MyConn);

DataSet1 ds = new DataSet1();

MyAdapter.Fill(ds,"SaleOfCuntry");

ReportDoc.SetDataSource(ds);

Crv.ReportSource = ReportDoc;

}

Web Form Designer generated code#region Web Form Designer generated code

override protected void OnInit(EventArgs e)

{

// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。

InitializeComponent();

base.OnInit(e);

}

/**//// <summary>

/// 设计器支持所需的方法 - 不要使用代码编辑器修改

/// 此方法的内容。

/// </summary>

private void InitializeComponent()

{

this.btnExport.Click += new System.EventHandler(this.btnExport_Click);

this.btnPrint.Click += new System.EventHandler(this.btnPrint_Click);

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

private void btnExport_Click(object sender, System.EventArgs e)

{

CrystalDecisions.Shared.DiskFileDestinationOptions DiskOpts = new CrystalDecisions.Shared.DiskFileDestinationOptions();

ReportDoc.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;

switch (ddlFormat.SelectedItem.Text)

{

case "Rich Text (RTF)":

　 ReportDoc.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.RichText;//

　 DiskOpts.DiskFileName = "c:\\Output.rtf";//

break;

case "Portable Document (PDF)":

　 ReportDoc.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;//

　 DiskOpts.DiskFileName = "c:\\Output.pdf";//

break;

case "MS Word (DOC)":

　 ReportDoc.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.WordForWindows;//

　 DiskOpts.DiskFileName = "c:\\Output.doc";//

break;

case "MS Excel (XLS)":

　 ReportDoc.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.Excel;//

　 DiskOpts.DiskFileName = "c:\\Output.xls";//

break;

default:

break;

}

ReportDoc.ExportOptions.DestinationOptions = DiskOpts;

　 ReportDoc.Export();

}

private void btnPrint_Click(object sender, System.EventArgs e)

{

// 指定打印机名称，这里是网络工作站Gigi上的打印机Hp Jet 6

string strPrinterName;

strPrinterName = @"Canon Bubble-Jet BJC-210SP";

// 设置打印页边距

PageMargins margins;

margins = ReportDoc.PrintOptions.PageMargins;

margins.bottomMargin = 250;

margins.leftMargin = 350;

margins.rightMargin = 350;

margins.topMargin = 450;

ReportDoc.PrintOptions.ApplyPageMargins(margins);

//应用打印机名称

ReportDoc.PrintOptions.PrinterName = strPrinterName;

// 打印 // 打印报表。将 startPageN 和 endPageN

// 参数设置为 0 表示打印所有页。

ReportDoc.PrintToPrinter(1, false,0,0);

}

本文转自高海东博客园博客，原文链接：http://www.cnblogs.com/ghd258/archive/2005/10/25/261677.html，如需转载请自行联系原作者