Passing Multi-Value Parameter to a Stored Procedure

[Former Member]

Has anyone experienced passing a Parameter (MultiValue) to a Stored Procedure? I am aware that Crystal Passes the Param as an Array. How would you go about handling this within a Stored Procedure???

[Former Member]

Hi Daniel

Try as below:

1. Create a Crystal report, and add a multi-value parameter.

2. Since the multi-value parameter is treated as an array, create a formula that uses the JOIN function. Create a formula as below:

//Formula: @JoinFormula

Join ({?Multi-value parameter array},";")

====================

NOTE:

In the formula above, a semi-colon (";") is the delimiter.

====================

3. Within the main report, create a subreport based on the stored procedure, and include the parameter to be populated with the multi-value list.

4. Link the Join formula in the main report to the stored procedure parameter in the subreport.

Doing so passes a multi-value parameter to the stored procedure.

Hope this helps!!!!

Regards

Sourashree