.Net Crystal Report Parameter Problems

Hi everyone,

Before I start, I would like to give thanks in advance for your help so far, it been greate…

Now then, I have a C# windows app. which includes a Crystal report control with the following code behide…

ReportDocument rpt = new ReportDocument();

string ReportPath = System.Configuration.ConfigurationSettings.AppSettings["Crystal:ReportDirectory"].ToString();

ReportPath = Path.Combine(ReportPath, cboReportList.SelectedItem.ToString() + ".rpt");

rpt.Load(ReportPath);

rpt.SetDatabaseLogon(System.Configuration.ConfigurationSettings.AppSettings["Crystal:ConnUserID"].ToString(), System.Configuration.ConfigurationSettings.AppSettings["Crystal:ConnPassword"].ToString(), System.Configuration.ConfigurationSettings.AppSettings["Crystal:ConnSource"].ToString(), System.Configuration.ConfigurationSettings.AppSettings["Crystal:ConnDatabase"].ToString());

My report has been setup using Crystal Reports 9 and the report uses a SQL strored procedure which takes one parameter of type string.

Now the problem than I’m experiencing is that when the reports opens, it prompts for a “Discrete Value” (…because it’s not being passed programmatically) and when you enter the value a BLANK REPORT displays.

It’s as if .Net h as a problem passing the parameter thru to the Crystal report.

I have tried the following,

Generating the report within Crystal 9 and passing the parameter – works fine

Removing the parameter, and then opening it from .Net – works fine,

Passing the parameter programmatically – Not so fine!!!

Entering the parameter when the .Net report prompts – Not so fine!!!

Any ideas???