[水晶报表]PUSH与PULL模式

厦门德仔

于 2016-08-17 11:03:18 发布

阅读量2.3k

点赞数

分类专栏： # 水晶报表文章标签： PUSH-PULL

本文链接：https://blog.csdn.net/david_520042/article/details/52229030

版权

水晶报表专栏收录该内容

34 篇文章 3 订阅

订阅专栏

HTML:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="PurInvoiceRpt.aspx.cs" Inherits="DzPlatForm.ERP.FIN.PurInvoiceRpt" %>

<%@ Register assembly="CrystalDecisions.Web, Version=13.0.2000.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>
</head>
<body>
    <form id="form1" runat="server">
        <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" 
            AutoDataBind="True" GroupTreeImagesFolderUrl="" Height="50px" 
            ReportSourceID="CrystalReportSource1" ToolbarImagesFolderUrl="" 
            ToolPanelWidth="200px" Width="903px" ToolPanelView="None"  />
        <CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
<%--            <Report FileName="..\..\Report\PurInvoice.rpt">
            </Report>--%>
        </CR:CrystalReportSource>

    </form>
</body>
</html>

CS:

 DataSet ds = new DataSet();
            ds = SqlHelper.ExecuteDataset(db.StringConnection(), CommandType.StoredProcedure, "DZ_PurInvoice", parms);
            //push 推模式
            if (ds != null)
            {

                CrystalDecisions.CrystalReports.Engine.ReportDocument doc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
                string reportPath = Server.MapPath("..\\..\\Report\\PurInvoice.rpt");
                doc.Load(reportPath);
                doc.SetDataSource(ds.Tables[0].DefaultView);
                CrystalReportViewer1.Width = 1200;
                CrystalReportViewer1.ID = TA001+TA002;
                CrystalReportViewer1.ReportSource = doc;


            }
            else
            {
                JScript.Alert("没有找到记录", this.Page);
            }

            //pull 拉模式
            //CrystalReportSource1.ReportDocument.SetDatabaseLogon("sa", "Supper99", "192.168.1.99", "ZM");
            //CrystalReportSource1.ReportDocument.SetParameterValue("@TA001", TA001);
            //CrystalReportSource1.ReportDocument.SetParameterValue("@TA002", TA002);
            //CrystalReportSource1.DataBind();