Pass parameters to stored procedure in report

[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.

[Alex K.]

Hello,

If report compiled you can use the following code:

Code: Select all

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

Thank you.

[fdot_appdev]

That was one the options that I have already tried. No parameters are being passed.

[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.