Skip to Content
0
Former Member
Sep 24, 2010 at 03:39 PM

Passing multiple selection values from Crystal UI to a stored procedure

272 Views

We have a Crystal Report that is fed by a stored procedure in SQL Server. There are two date params to the stored proc and the user can select dates which are used to filter the data. This part seems to work just fine.

There are also two additonal params which hooked to multiple selection values. If I create two additional params in the stored proc of type varchar(max), how can I extract the values selected on the Crystal parameter collection UI - say 1,2,3 - and pass them to the stored proc so SQL Server can filter the data instead of using Crystal's record selection formula?

Thanks

Carl