Hi,

I am not sure if I am doing this the correct way or if there is a different approach to this. I have created a report which summarizes inventory by item category.  Instead of having multiple similar reports, I would like to parameterize it so the user can select which report they would like to view.  The report works well if I use the select expert and filter the category using the “Is Like” statement, as I have a number of groups and the statement W?? selects all of the groups that I need.  I am also able to add multiple categories using the same “Is Like” statement.  My issue is that I am having a slight problem translating this to parameters. 

I have created a parameter called ReportSelection and fed it to the select expert using the “Is Like” statement.  I am unable to add multiple items to the same parameter item line.  I have added descriptions to the parameter choices and hidden the selections to the users.  The only lines that seem to work are lines with single items. 

 

I have arranged it as follows:

Value                                    Description

*                                          All Items

CIG, CIGS                             Cigars and Cigarettes

COF, MHS                              Coffee and Misc Hotel Supplies

JC                                         Juice

LIQ, LI3                                Local Liquor and Liquers

W??                                      Wines

 

The only ones that work are All Items, Juice and Wines.  I have tried using single and double quotes to no avail.

 

Is there any way to accomplish this task or am I looking at this the wrong way?

Cheers and thanks in advance.