在 asp.net 中通过 C# 将参数传递给 CRYSTAL REPORTS

Passing parameters to CRYSTAL REPORTS via C# in asp.net(在 asp.net 中通过 C# 将参数传递给 CRYSTAL REPORTS)

问题描述

我是 Crystal Reports 的新手.我通过以下链接设计了一个水晶报表:带有 SQL 存储过程参数和 Visual Studio 的水晶报表我需要做的是将不同的 ID(SP 的输入值)传递给我与 Crystal Report 连接的 SP.

I am new to Crystal Reports. I have designed a Crystal Report by following this link: Crystal Report with SQL Stored Procedure Parameter and Visual Studio What I need to do is pass different ID's (Input value of the SP) to the SP that I connected with the Crystal Report.

这是我将 ID 传递给 Crystal Report 的代码:

This is the code I have which passes the ID to the Crystal Report :

        protected void Button1_Click(object sender, EventArgs e)
        {
        string QuotationID = ViewState["QUOTATION_ID"].ToString();
        ReportDocument reportDocument = new ReportDocument();
        ParameterField paramField = new ParameterField();
        ParameterFields paramFields = new ParameterFields();
        ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();


       
        paramField.Name = "@id";


        paramDiscreteValue.Value = QuotationID;

        paramField.CurrentValues.Add(paramDiscreteValue);
        paramFields.Add(paramField);

        
        paramFields.Add(paramField);

        CrystalReportViewer1.ParameterFieldInfo = paramFields;

        string reportPath = Server.MapPath("~/CrystalReport.rpt");

        reportDocument.Load(reportPath);

       
        CrystalReportViewer1.ReportSource = reportDocument;
        }

但每当我点击按钮时，它都会要求输入 ID...

But whenever I click the button it asks for the ID...

推荐答案

在水晶上设置参数我总是这样:

To set parameter on crystal I always do it this way:

ReportDocument reportDocument = new ReportDocument();
reportDocument.Load(reportPath);
reportDocument.SetParameterValue("@id", QuotationID);

如果您想将报告转换为 pdf:

if you want to convert your report to a pdf:

var exportOptions = reportDocument.ExportOptions;
exportOptions.ExportDestinationType = ExportDestinationType.NoDestination;
exportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
var req = new ExportRequestContext {ExportInfo = exportOptions};
var stream = reportDocument.FormatEngine.ExportToStream(req);

这会返回一个文件流，您可以从 aspx 页面打开该文件流.

this returns you back a filestream that you can open from the aspx page.

这篇关于在 asp.net 中通过 C# 将参数传递给 CRYSTAL REPORTS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！