Param Help

[fmrock]

I have the a Param called "Group"

In the select Expert I do the following code.

(
if ucase({?Group}) <> "ALL" then
    {SG_LOGS.GROUPID} = {?Group} else
if ucase({?Group}) = "ALL" then
    true
)

This way the user call pull all Groups back into the report.

The user is wanting to enter 1 group, Multiple groups, or get all groups.

If I updated the param to allow mulitple values, how would i update the formual in my select expert.

if I do it now, its asking me to subscript the array, but I cant seem to get it to work any of the ways I tried.

Any help would be great.

Thanks.

 

[fmrock]

Also, I am using version 9

 

[lbass]

The problem is with the ucase()--otherwise your formula should work, so my question is whether you could be building "All" into a picklist, so that it is in a standard case.

-LB

 

[fmrock]

Thanks lbass... worked great.