Parameter Inputs

[M8KWR]

i need a report so the user can select multiple options against 1 field. I have a field called Lead_Code. In here there can be multiple options a user can enter into the database (App, A, B, C, D, E, X).

I want the user to be able to select the lead codes they want to preview in the report, without having to do a parameter options for each lead code. Is this possible??

I thought about doing a >= [value1] and <= [value2] but if the user wanted A and B, the APP leads codes would also be previewed.

I hope i have explained myself ok, and many thanks for any help in advance.

 

[lupins46]

When you create you parameter field check the option for Multiple Values. The user can then just add to a list of values they want.

 

[dgillz]

As Lupins46 indicates, you can make a paramter a mulit-value field. Then in the record selection formula, you do this:

{YourDatabaseField} in {?YourMutilvalueParmater}

To display the list of values picked by the user, create a formula using the join function, and place this in the page header:

Join({?MultivalueParameter},",")



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

http://www.gainfocus.biz