Crystal Reports XI using SQL stored procedure

[nguyenmiket]

I have created a crystal report in XI that uses a stored procedure with two date parameters. When i run it in Crystal reports it prompts me for the dates. When i put it in a view in a .aspx page, it fails with this message:

Method 'IPromptingHTML RenderOption_re serve10' on type 'CrystalDecisio ns.ReportAppSer ver.Prompting.P romptingHTMLRen derOptionClass' from assembly 'CrystalDecisio ns.ReportAppSer ver.Prompting, Version=11.0.33 00.0, Culture=neutral , PublicKeyToken= 692fbea5521e130 4' is overriding a method that has been overridden.


How do have the user enter in the parameters for the dates and pass it to the SQL stored procedures and then run the report????

BTW - I'm new to crystal reports and ASP.NET, but not new to ASP.NET

Thanks!

[kenobewan]

Could you use a web form to get the user to input the date?

[markchimes]

Hi nguyenmiket,

If I understand your problem correctly you are receiving an error when trying to pass parameters to a SQL SP?

Passing scoping parameters to Crystal Reports is best accomplished as follows...
Place this code where you call the report...
RptParams RollParams = new RptParams(this) ;
RollParams.Show Dialog();
if (lSuccess)
{
RollsByFormClas s RollsByForm = new RollsByFormClas s(strFormula);
RollsByForm.Sho w();
}

Place this code in your report form...
if (strFormula != string.Empty)
crReportDocumen t.DataDefinitio n.RecordSelecti onFormula = strFormula;

strFormula contains all the parameters you want to pass to the report and completely replaces the scoping phrases in Crystal.

eg: strFormula = "{Customer.Surn ame} = " + TextBox1.Text.T rim();

I'm not familiar mwith Crystal XI (Still using 10), but I think the concpet is the same.
Good luck.

cheers,
Mark Chimes

I have created a crystal report in XI that uses a stored procedure with two date parameters. When i run it in Crystal reports it prompts me for the dates. When i put it in a view in a .aspx page, it fails with this message:

Method 'IPromptingHTML RenderOption_re serve10' on type 'CrystalDecisio ns.ReportAppSer ver.Prompting.P romptingHTMLRen derOptionClass' from assembly 'CrystalDecisio ns.ReportAppSer ver.Prompting, Version=11.0.33 00.0, Culture=neutral , PublicKeyToken= 692fbea5521e130 4' is overriding a method that has been overridden.


How do have the user enter in the parameters for the dates and pass it to the SQL stored procedures and then run the report????

BTW - I'm new to crystal reports and ASP.NET, but not new to ASP.NET

Thanks!