Page 1 of 1

Pass parameters to stored procedure in report

Posted: Fri Mar 09, 2012 3:55 pm
by fdot_appdev
I have been trying to programmatically pass the parameters to the report for weeks now with no success.

Every way under the sun has been tried and I still get this error, Procedure or function 'CONTACT_MAILINGLABEL' expects parameter '@GROUP_ID', which was not supplied. I am passing them this way.

report.CompiledReport.DataSources("CONTACT_MAILINGLABEL").Parameters(p).ParameterValue = Request.QueryString(qp)

Parameters for all of my reports are generated on-the-fly databases. This report works in Crystal Reports when passing programmatically and was not imported.

Any help would be appreciated.

Pass parameters to stored procedure in report

Posted: Mon Mar 12, 2012 7:57 am
by Alex K.
Hello,

If report compiled you can use the following code:

Code: Select all

report["@GROUP_ID"] = Request.QueryString(qp)
Thank you.

Pass parameters to stored procedure in report

Posted: Tue Mar 13, 2012 9:30 am
by fdot_appdev
That was one the options that I have already tried. No parameters are being passed.

Pass parameters to stored procedure in report

Posted: Wed Mar 14, 2012 2:12 am
by Alex K.
Hello,

We couldn't reproduce this bug.
Can you please send us a sample project which reproduces the issue for analysis.

Thank you.