.net – passing parameters to Crystal report from webforms

asp.netcrystal-reportsnetwebforms

i have a report and i want to display it on a webform. Reports without parameters are working nice and fine. Reports with parameters are creating headache for me. this is the code i have written in BindReport method, which is called on page load event of the form.

    ReportDocument rpt = new ReportDocument();
    rpt.Load(Server.MapPath("rptPositionwiseMontwiseActualSale.rpt"));
    rpt.FileName = Server.MapPath("rptPositionwiseMontwiseActualSale.rpt");
    rpt.SetParameterValue("CompanyName", "Cirin Pharmaceutical Pvt. Limited".ToString());
    rpt.SetParameterValue("ReportTitle", "PositionWise MonthWise Sales".ToString());
    rpt.SetParameterValue("parameters", "Year:2011".ToString());
    //CrystalReportViewer1.ParameterFieldInfo = paramFields;
    DataSet ds = getReportData();
    rpt.SetDataSource(ds.Tables[0]);
    CrystalReportViewer1.ReportSource = rpt;
    CrystalReportViewer1.ReuseParameterValuesOnRefresh = true;

    //CrystalReportViewer1.RefreshReport();

i have tried variety of things like assigning ParameterFieldInfo to reportviewer control but, it shows me prompt on page load asking for parameter values of the report. i m using .NET 4.0

EDIT i m using push model for crystal reports. does it change the way we can pass parameters to report from asp.net

thanks

Best Answer

When setting Parameter values at runtime for ASP.NET I think you need to do a bit more work than just called SetParameterValue

string rptTitle = "This is Report Title";

rpt.SetParameterValue("ReportTitle", rptTitle);

ParameterDiscreteValue val = new ParameterDiscreteValue();
val.Value = rptTitle;

ParameterValues paramVals = new ParameterValues();

paramVals.Add(val);

rpt.ParameterFields["ReportTitle"].CurrentValues = paramVals;

rpt.DataDefinition.ParameterFields[0].ApplyCurrentValues(paramVals);

This is probably a bit of overkill but it does actually work, well for me anyway. You must ensure that the parameter names match exactly.

Related Solutions

How to dynamically assign report and connectioninfo to crystal report

It turns out that the report we were using was an older Crystal Reports (8 i think) report that was using a .qry file. After we converted the query to a command object (in crystal) everything worked!

R – Problems converting crystal reports from vb6 standalone app to .net web app

Ok Problems solved. Not ideally but solved any way.

I have put this here so others may learn from my struggle.

Crystal reports (v9 included with vs2008) won't use a SQL (or any other connection) it must use either a dataset or an ODBC connection. As I don't know much about datasets, so I didnt take this path.

Crystal reports seems to be designed to use the designer you cannot create it it dynamically. and this is reflected in how hard it is to alter the connection. everything failed until I found this How do I change a Crystal Report's ODBC database connection at runtime? patm's solution was the one which provided the clues.

this is my solution c# implemented in the page_load method

        SqlConnectionStringBuilder SConn = new SqlConnectionStringBuilder(_connectionString);

        ReportDocument cryRpt = new ReportDocument();
        TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
        TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
        ConnectionInfo crConnectionInfo = new ConnectionInfo();
        crConnectionInfo.ServerName = dsn;// SConn.DataSource;
        crConnectionInfo.DatabaseName = SConn.InitialCatalog;
        crConnectionInfo.UserID = SConn.UserID;
        crConnectionInfo.Password = SConn.Password;

        String rpt = Server.MapPath(@"~/reports2/Report1.rpt");
        cryRpt.Load(rpt);
        foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in cryRpt.Database.Tables)
        {
            crtableLogoninfo = CrTable.LogOnInfo;
            crtableLogoninfo.ConnectionInfo = crConnectionInfo;
            CrTable.ApplyLogOnInfo(crtableLogoninfo);
        }

        CrystalReportViewer1.ReportSource = cryRpt;
        CrystalReportViewer1.RefreshReport();

dsn is the name of the ODBC connection NOT the server you want to connect to eg. NOT "localhost/sqlexpress"

I tried many different ways of setting a connection to the database dynamically and only the above worked. my guess is that the others required a fully licensed version of Crystal Reports although none stated it.

DC

Related Topic

Scala: list.flatten: no implicit argument matching parameter type (Any) = > Iterable[Any] was found