Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Record select using "in" Post Reply Post New Topic
Author Message
kurt
Newbie
Newbie


Joined: 08 Sep 2014
Online Status: Offline
Posts: 22
Quote kurt Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.