Using parameter Multiple values in SQL query (command)
Crystal Reports 2008
I created a crystal report with complicated query with about 6-8 parameters in it. I have 2 parameters which can be optional and also have multiple values. Report works fine if I just enter one value or leave it blank. But if I check multiple values option for those parameters and try to add more than one value, it gives 'missing right parenthesis' oracle error after accepting all the parameters.
Can someone help me to resolve this issue?
Thanks in advance
The command level parameters are always a discrete values it can accept only one value. If you want the command level parameter to accept multiple values then unless you join it with a comma separator it will not accept it as a multiple values.
The other way around is you can create a reprot level parameter and specify the condition in the Selection formula but it could hamper the report performance.