Passing dynamic parameter value to stored procedure in Crystal Reports

[ycrofts]

I have a Crystal XI report, based on a stored procedure (SQL Server 2005 database), which expects a few input parameters. Crystal reports automatically includes these parameters for the procedure (preceded with a @) in the report, resulting in a basic text prompt dialog whereby the user is expected to type in the value for each parameter.

...However, I'm wanting to have these parameters appear as dynamic - each selecting a list of values for the user to select from, from an existing table in the database, and the selected value for each then being passed as the input parameters for the stored procedure.

I've tried modifying the parameters that were automatically created as being dynamic, but this doesn't work

I've searched for ages trying to find a solution but no luck as yet.

Any help would be greatly appreciated, please!

Yvonne

 

[lita1215]

Have you figured out how to solve this issue? I'm having the same problem.

 

[ycrofts]

Yes I finally managed to solve this after a lot of pain

This involved creating a report with a sub-report - the main report selected the desired dynamic values from the database via parameters, and when bringing in the subreport, you create "subreport links" that link each parameter from the main report, to the "@..." parameters in the subreport.


It works!