Skip to Content
0
Former Member
Apr 30, 2014 at 09:03 PM

Using a parameter within a command that allows multiple values

35 Views

I am talking about the parameter on the right side of the Command window, not the parameter in the field explorer.

I have a report I am trying to limit the time it needs to run. It is written in Command, and takes about 2 minutes to run. I have created a parameter and that runs great and super fast- if I only want one value. I have tried checking the 'Allow Multiple Values' and now it won't work. I have tried using "=" with single quotes around the parameter and using "LIKE" without the single quotes.

I have tried with the parameter like "({p_test},', ') and that didn't work. I get an "Incorrect syntax near ',' " error.

I have been able to use the Command Parameters to select a range, but I can't get it to select multiple values.

Please help.