Loading

Loading Crystal Report with parameters - ASP.NET Web forms

Loading Crystal Report with parameters - ASP.NET Web forms

Dealy

10y3.6k.NET

Hello,

I'm trying to load a crystal reports with parameters using a stored procedure as a data source.I'm using Visual Studio 2015 with ASP.NET Web forms.

I've created the report (Report1.rpt) using wizard, binding it on my stored procedure. When I was asked to enter the parameters I left it blank.

Here's my code:

protected void Button1_Click(object sender, EventArgs e)
{
ReportDocument reportDocument = new ReportDocument();
ParameterField paramField = new ParameterField();
ParameterFields paramFields = new ParameterFields();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
paramField.Name = "@id";
paramDiscreteValue.Value = "123";
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramFields.Add(paramField);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
string reportPath = Server.MapPath("~/User/Report1.rpt");
reportDocument.SetDatabaseLogon("user", "pass","SERVER", "DB1", false);
reportDocument.Load(reportPath);
CrystalReportViewer1.ReportSource = reportDocument;

1. When I click on the button I get nothing. Any ideas why the report is not loading?

2. If i use the following code I get error in "SERVER\TSQL2012"

reportDocument.SetDatabaseLogon("user", "pass","SERVER\TSQL2012", "DB1", false);

Any kind of help would be appreciated!

Thank you in advance.

4 Replies

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

Dealy10y ago
Now I'm getting the following error on the same line:
reportDocument.SetParameterValue("@id", 123);
An exception of type 'System.Runtime.InteropServices.COMException' occurred in CrystalDecisions.CrystalReports.Engine.dll but was not handled in user code

Thanks again for the help!
0
Balamurali Krishnan R10y ago
ohhh !
set Parameter value after load report document
ReportDocument reportDocument = new ReportDocument();
string reportPath = Server.MapPath("~/User/Report1.rpt");
reportDocument.SetDatabaseLogon("user", "pass","SERVER", "DB1", false);
reportDocument.Load(reportPath);
reportDocument.SetParameterValue("@id", 123);
nCrystalReportViewer1.ReportSource = reportDocument;
0
Dealy10y ago
Thank you for your answer!
I added that line of code but I get the following error message
An exception of type 'CrystalDecisions.CrystalReports.Engine.LoadSaveReportException' occurred in CrystalDecisions.CrystalReports.Engine.dll but was not handled in user code
Additional information: Invalid report file path.
0

Balamurali Krishnan R

Balamurali Krishnan R10y ago

use the following syntax setting parameter value after setting server map path

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

reportDocument.SetParameterValue("@id", 123);

0