Dear Friends,
How to pass parameters in c# to Crystal Report.
I already create Crystal Reprot using store Procedure.
But How can i pass parameters to that reoprts.
*********************************************
My Code: -
==========
Add Librarioes: -
---------
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using CrystalDecisions.ReportSource;
-----------
sqlcmd.CommandText = "Sp_Report1";
sqlcmd.CommandType = CommandType.StoredProcedure;

sqlcmd.Connection = con;
con.Open();

string path;
ReportDocument orpt = new ReportDocument();

path = Request.PhysicalApplicationPath;
path = path + "SellPro.rpt";
orpt.Load(path);

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

            orpt.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableD ocFormat;
            orpt.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.Disk File;

path = Request.PhysicalApplicationPath;
diskOpts.DiskFileName = path + "1.pdf";
orpt.ExportOptions.DestinationOptions = diskOpts;

            orpt.Export();

************************************************** ***
What i do?



Brijesh Shah

Brijesh Shah

Hi, I've got some .NET 2003 C# code that may help you. The code sample below extracts an HTML form value passed to the aspx page, then assigns it as a Parameter Field (PF) which is passed to my sprocs, plus assigns ADO connection info to the report datasources. (My report is actually a master report with a bunch of subreports that produce a single PDF.) The main parameter, @strSprocParameter, is what gets passed into the sprocs. You can use add'l params the same way, like my bSubReportX params. In my case, the same param is passed to all my sprocs. You can set up subreport parameter fields in exactly the same way, linking the strParameter param to each subreport's param. I believe you can set up more than 1 param, but I didn't need to. Another quick-n-dirty method is to pass a string that you can break up into an array of params in your sproc, but that's kind of kludgy. :)


using CrystalDecisions;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports;
using CrystalDecisions.CrystalReports.Engine;

private void Page_Load(object sender, System.EventArgs e)
{
    // Put user code to initialize the page here
    int i, j;
    CrystalDecisions.CrystalReports.Engine.ReportDocum ent objReport
        = new CrystalDecisions.CrystalReports.Engine.ReportDocum ent();
    CrystalDecisions.Shared.ConnectionInfo conn = new ConnectionInfo();
    CrystalDecisions.CrystalReports.Engine.Table myTable;
    CrystalDecisions.Shared.TableLogOnInfo myLog;
    System.IO.MemoryStream ios;
    ios = new System.IO.MemoryStream();

    // retrieve HTML form fields passed to the aspx page
    string strParameter = Request.Form.Get("txtParameter");
    string strReportPath = Request.Form.Get("txtReportPath");

    // which subreports are to be generated? each is an HTML checkbox
    bool bSubReportA = Request.Form.Get("chkSubReportA") == "on" ? true : false;
    bool bSubReportB = Request.Form.Get("chkSubReportB") == "on" ? true : false;
    bool bSubReportC = Request.Form.Get("chkSubReportC") == "on" ? true : false;

    // load the report and set its runtime parameters
    // Note: each needs to be added to the report as a Parameter Field, and the
    objReport.Load(strReportPath);//, OpenReportMethod.OpenReportByTempCopy);
    objReport.Refresh(); // needed so report will accept new parameters
    objReport.SetParameterValue("@strSprocParameter", strParameter);
    objReport.SetParameterValue("bSubReportA", bSubReportA);
    objReport.SetParameterValue("bSubReportB", bSubReportB);
    objReport.SetParameterValue("bSubReportC", bSubReportC);

    // assign the same database connection for each report
    conn.ServerName = "My_System_DSN";
    conn.DatabaseName = "MY_Database";
    conn.UserID = "SomeUserID";
    conn.Password = "SomePassword";
    for (i=0; i<objReport.Database.Tables.Count; i++) {
        myTable = objReport.Database.Tables[i];
        myLog = myTable.LogOnInfo;
        myLog.ConnectionInfo = conn;
        myTable.ApplyLogOnInfo(myLog);
        myTable.Location = myLog.TableName;
    }

    // execute the report and export to a PDF memory buffer
    ios = (MemoryStream)objReport.ExportToStream(CrystalDeci sions.Shared.ExportFormatType.PortableDocFormat);
    Response.Clear();
    Response.Buffer= true;
    Response.ContentType = "application/pdf";
    Response.BinaryWrite(ios.ToArray());
}

I hope that helps. The 1st parameter is the std type set up according to the directions in the CR help docs built into both the MSDN help and CR's Report Designer (the standalone design software). That's why you see the "@" in its name. The others are extra parameters I added so I can include/exclude any of the subreports.

Thanks for Reply.


Brijesh Shah

ParameterFieldDefinitions crParameterFieldDefinitions ;
ParameterFieldDefinition crParameterFieldDefinition ;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();

crParameterDiscreteValue.Value = "Your Value"
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["Your Field"];
crParameterValues = crParameterFieldDefinition.CurrentValues;

crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crPa rameterValues);

http://csharp.net-informations.com/c...-parameter.htm

hu.

Thanks so much hu_yang, your code saved my life!