ASP.NET MVC Crystal Report parameter value is not displayed in report

I have a crystal report to which i am passing 3 parameters - ID, clientname and address. Code is as follows

ReportDocument cryRpt = new ReportDocument();
MySqlCommand objcmd = new MySqlCommand("rptreport", conn);
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.Parameters.AddWithValue("ID", ID);
objcmd.Parameters.AddWithValue("clientName", clientname);
objcmd.Parameters.AddWithValue("Address", address)
MySqlDataAdapter da = new MySqlDataAdapter();
DataTable dt = new DataTable();
da.SelectCommand = objcmd;
da.Fill(dt);
cryRpt.Load("C:/Report/" + reportname + ".rpt");
cryRpt.SetDataSource(dt);
cryRpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat,"C:/Report/" + reportname + ".pdf");
byte[] bytes = File.ReadAllBytes("C:/Report/" + reportname + ".pdf");
result = Convert.ToBase64String(bytes);

While designing report, in report header section I need to show client name and address. So from Field explorer window , in parameter fields , I just drag cilentname and address and drop in report header section.

When I run or print the report; client name and address are not getting displayed in report header section. It shows blank in report header section.

How to show these parameter fields in report?

Any help would be appreciated. Thank you.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
Accepted answer
hi

These parameters for sql server commnad not for crystal report.

The crystal report paramerets assign to parameterinfo object
Then the parameterinfo object assign to reportviewer parameterinfo

Please follow the link for details

https://www.encodedna.com/2012/12/pass-parameter-to-crystal-report-aspdotnet.htm

Thanks and Regards
dip s6y ago
Thank you @Laxmidhar Sahoo