parameters with multiple values, select expert

[mcaizpp2]

Hello,

My problem is with a parameters that accepts multiple values. The parameters name is country.
I want the user to be able to select multiple countries if they wish or they can select "*" (all).

My select expert works like this -
(IF {?@Country} = "*" THEN TRUE ELSE {VIEW_RPT_ScoreByBand.Country} LIKE {?@Country}


This works fine for parameters with a single value but errors for a parameters with multiple values. I get some sort of array subscript error.

Does anyone know of a work around for dealing with parameters with multiple values?

Thanks in advance.

 

[MisterMo]

Why are you using the like option? Are the value on your list not equal to the data on your table?

if they are you could try something like

IF {?@Country} <> "*" THEN
{VIEW_RPT_ScoreByBand.Country} = {?@Country}


-Mo