Multiple values in parameter 1

[Kasten]

Oracle 9.0
CR 9 and CR 10.

I have created a string parameter that allows multiple values. When I run the report I try to add "a01" and "A01" to the list but CR won't take both values. This is probably a ucase lcase problem but how can I solve it. I tride to change the Case sensitive option but it doesn't help.

Any suggestions?

Best regards
/Fredrik

 

[lbass]

This doesn't happen in CR XI, but did happen in 8.5 when I tested it. What you might do is a work around. You could either enter one of the options with a space at one end of the entry, and then reference it in your record selection formula as:

{table.field} = trim({?parm})

This would probably work best if you added the parameter options to a list when you set up the parameter, so that you can enter the spaces when necessary--so the user isn't expected to.

-LB

 

[Kasten]

Thanks a lot.