select multiple values in parameter

[cocopud]

I am using CR11 and have an oracle stored procedure. One of the parameters in the report is for a field that can be one of 3 values 'Y' 'N' or 'M'. Currently the line in the procedure allows me to select only one value or no value: (L.STATUS = pSTATUS OR pSTATUS IS NULL)

I need to be able to select 1, 2 or all 3 values in the parameter (i.e., Y or N or M or Y N or Y M or NM or Y N M). As I am not really good with stored procedures, I am not sure where to start. Any suggestions/examples of how to do this would be greatly appreciated. Thanks.

 

[dgillz]

Edit the parameter field and there is an allow multiple values property. Change it from false to true.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[cocopud]

I was looking for a way to do it the stored procedure in oracle, so that when we put the reports onto a report server the list box that would be put on there would work since.