views:

8

answers:

0

I have a very large table that I need to be able to select specific records from. I at first just created a parameter in Crystal and made it accept multiple values, but because of the size of the table, the reading of the records was very slow before it even got to the record selection. So I decided to create a stored procedure instead and to pass the parameter values to the sp. However, when you use a stored proc as a data source in Crystal, the parameter that is created does NOT allow you to change the parameter to be a multi-value parameter. SO, then I decided to write the sql script from my stored procedure as a command data source and to create a parameter when entering the command. This does allow you to specify that the parameter is multi-value. BUT when I run the report and enter more than one parameter value, I get a syntax error "near ','" which leads me to believe that there is a problem with passing the multiple value parameter to the sql statement. In the sql statement I have the where clause set to Where cm.CLAIMNO in({?Claims}) . The parameter is a string, static and again, it is set to allow multiple values. What am I doing wrong?