Topic: Record select using "in" Posted: 30 Jun 2015 at 6:10am
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum