如何将multipal参数值传递到水晶报表. [英] How to pass multipal Parameter Value to crystal report..?

问题描述

我有一个asp.net Web应用程序，该应用程序将包含一个水晶报表，在那里我定义了两个选择标准，并且还具有用于该选择标准的两个参数

例如FirstName，第二个是LastName

现在我想知道如何使用c#将该参数值传递给我的水晶报表
我正在使用 SAP CrystalReport for VSD2010(CR13)

I have a asp.net web application that will contain one crystal report there i have defiend two selection criteria and also have two parameter for that selection criteria

like FirstName and second is LastName

now i want to know how to pass that parameter value to my cristal report using c#

I m using SAP CrystalReport for VSD2010 (CR13)

推荐答案

看看这个将多个参数以编程方式传递给Crystal报表 [

希望这将帮助您

如何在运行时将参数传递给Crystal报表 [

HOPE THIS ONE WILL HELP U

How to Pass Parameters to Crystal Reports at Runtime[^]

检查以下内容

check below

report.Load(Server.MapPath("ReportsFolder")+ "\\YOURCRYSTALREPORT.rpt");            CrystalDecisions.Shared.ParameterValues pval1 = new ParameterValues();
CrystalDecisions.Shared.ParameterValues pval2 = new ParameterValues();
CrystalDecisions.Shared.ParameterValues pval3 = new ParameterValues();
CrystalDecisions.Shared.ParameterValues pval4 = new ParameterValues();

ParameterDiscreteValue pdisval1 = new ParameterDiscreteValue();
pdisval1.Value = strName;
pval1.Add(pdisval1);

ParameterDiscreteValue pdisval2 = new ParameterDiscreteValue();
pdisval2.Value = strID;
pval2.Add(pdisval2);

ParameterDiscreteValue pdisval3 = new ParameterDiscreteValue();
pdisval3.Value = Convert.ToInt32(ddlItems1.SelectedValue);
pval3.Add(pdisval3);
           
ParameterDiscreteValue pdisval4 = new ParameterDiscreteValue();
pdisval4.Value = Convert.ToInt32(ddlDepartments.SelectedValue);
pval4.Add(pdisval4);


report.DataDefinition.ParameterFields["@Parm1"].ApplyCurrentValues(pval1);
report.DataDefinition.ParameterFields["@Parm2"].ApplyCurrentValues(pval2);
report.DataDefinition.ParameterFields["@Parm3"].ApplyCurrentValues(pval3);
report.DataDefinition.ParameterFields["@Parm4"].ApplyCurrentValues(pval4);

//get connection string from web.config

CrystalDecisions.CrystalReports.Engine.Table myTable;
CrystalDecisions.Shared.ConnectionInfo conn = new ConnectionInfo();
CrystalDecisions.Shared.TableLogOnInfo myLog;
string strServer = ConfigurationSettings.AppSettings["SQLserver"].ToString();
string strDBName = ConfigurationSettings.AppSettings["SQLdatabaseName"].ToString();
string strUID = ConfigurationSettings.AppSettings["SQLUserName"].ToString();
string strPassword = ConfigurationSettings.AppSettings["SQLPassword"].ToString();

            conn.ServerName = strServer;
            conn.DatabaseName = strDBName;
            conn.UserID = strUID;
            conn.Password = strPassword;

            for (int i = 0; i < report.Database.Tables.Count; i++)
            {
                myTable = report.Database.Tables[i];
                myLog = myTable.LogOnInfo;
                myLog.ConnectionInfo = conn;
                myTable.ApplyLogOnInfo(myLog);
                myTable.Location = myLog.TableName;
            }

            CrystalReportViewer1.Visible = true;
            CrystalReportViewer1.DisplayGroupTree = false;

            CrystalReportViewer1.HasPageNavigationButtons = true;
            CrystalReportViewer1.HasCrystalLogo = false;
            CrystalReportViewer1.HasDrillUpButton = false;
            CrystalReportViewer1.HasSearchButton = false;
            CrystalReportViewer1.HasViewList = false;
            CrystalReportViewer1.HasToggleGroupTreeButton = false;
            CrystalReportViewer1.HasZoomFactorList = false;
            CrystalReportViewer1.ToolbarStyle.Width = new Unit("750px");

            CrystalReportViewer1.ReportSource = report;

这篇关于如何将multipal参数值传递到水晶报表.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！