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.
IP Logged
