cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Report XI 11.5.10.1263

Former Member
0 Kudos

I have a stored procedure with multiple value parameter (varchar(MAX)) example: 5245,5246,5277.  When I executed the stored procedure on server all are all right.

But when I loaded the stored procedure into Crystal Report the parameter created by Crystal Report can not be change to have multiples values.  When I created a new one I can't associated the new dynamic parameter with multiple value to the existant parameter automatically created within Crystal Report.  I haved the error message : this parameter group are already links parameters on each level.  If you want to alter this parameter group, select one of the link parameter in the item list.

I don't know whar's the problem are.

Thank's

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Sylvie -

You cannot pass multiple values to SP in crystal reports but one work around is to create a main report and have the required parameters defined in main report and then pass these parameter values from main to the sub report. you can suppress you main report you will only use main report for passing parameters to subreport.

Main report : With parameters defined

Sub report: with a SP

Link : Main report parameters to Sub report parameters.

Let me know if you have questions.

Thanks

Abhi

abhilash_kumar
Active Contributor
0 Kudos

Hi Abhi,

It might not be that straightforward after all!

You can't simply link a Multi-valued parameter to the Stored Proc parameter. You need a formula as a mediator - a formula that actually creates a comma separated string ready to be linked to the Stored Proc prompt. The formula would be:

Join({?Prompt_Name}, ",");

-Abhilash

abhilash_kumar
Active Contributor
0 Kudos

Hi Sylvie,

Never seen that error before. Are you simply trying to create a 'static' parameter that lets you 'type in' multiple values and send them to the Stored Proc?

-Abhilash