|
I am creating 2 arrays when my report opens, @showParam & @showPrefix, they can contain 1 to like 10 values.
The arrays might look like this
@showParam = {approved, issued}
@showPrefix = {HGS, PH-WP}
I want to show records that are approved or issued, with a prefix of HGS or PH-WP. All is good.
The record select formula looks like this
{Command.Status}in{@showParam} and
{Command.Prefix}in{@showPrefix}
the problem I am having is that when command.prefix contains "WP", it is passing the criteria "in" @showPrefix, but it is only a partial match of "PH-WP"
Hopefully someone can show me how to use some sort of exact matching to select my records.
|