Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Record selection on parameter Post Reply Post New Topic
Author Message
Parry2k
Newbie
Newbie


Joined: 15 Aug 2008
Online Status: Offline
Posts: 3
Quote Parry2k Replybullet Topic: Record selection on parameter
     Posted: 15 Aug 2008 at 1:14pm
Hi,

i have one report which list customer. I want to set a parameter to filter the customer.

for example, if i want to see the customer starting with name A, B and C then i want to input parameter value seperated by comma and then want to do the record selection to list customer only starting with 'A,B,C'.

Is there any way to work it out?

Thanks in advance,
P
IP IP Logged
themessenger
Groupie
Groupie
Avatar

Joined: 15 Aug 2008
Location: United Kingdom
Online Status: Offline
Posts: 48
Quote themessenger Replybullet Posted: 15 Aug 2008 at 2:18pm
I suppose you could do something like:

In your record selection

(UCASE(LEFT({Customer},1)) in UCASE({?Param1})

This should test the first char of the customer to see if it is contained in the passed in parameter.
Managing Director
www.allmymenus.com
IP IP Logged
Parry2k
Newbie
Newbie


Joined: 15 Aug 2008
Online Status: Offline
Posts: 3
Quote Parry2k Replybullet Posted: 15 Aug 2008 at 3:55pm
thanks, i will check it out and let you know.
 
regards,
 
p
IP IP Logged
Parry2k
Newbie
Newbie


Joined: 15 Aug 2008
Online Status: Offline
Posts: 3
Quote Parry2k Replybullet Posted: 21 Aug 2008 at 11:37am
thanks it worked like charm.
 
best regards,
parv
IP IP Logged
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