Record select using "in"
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21574
Printed Date: 29 Apr 2024 at 12:33am
Topic: Record select using "in"
Posted By: kurt
Subject: Record select using "in"
Date 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.
|
|