Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: multi select parameter Post Reply Post New Topic
Author Message
sanchezgmc06
Senior Member
Senior Member
Avatar

Joined: 21 Jan 2011
Online Status: Offline
Posts: 107
Quote sanchezgmc06 Replybullet Topic: multi select parameter
    Posted: 16 Sep 2021 at 6:04am
Hello

I have a multi select parameter which brings back data for similar choices even if those are not selected when running the report.

When multiple choices are selected it brings back the followin string:
1030&330&331&111

Im using:
upper(CHARINDEX (service_code, REPLACE ( '{?serv_code}','+','&') )) >0


Example:
If the user selects service code 1030 my data also brings back data for 103 because they are similar. Is there a way for it to only bring back data for 1030 which was the one selected. I cant use = '1030' because the user has the option to select multiple service codes.

Edited by sanchezgmc06 - 20 Sep 2021 at 5:40am
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 17 Sep 2021 at 4:56am
Is it only the first four characters that you are looking for, or anywhere in the string?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 20 Sep 2021 at 1:20pm
if you bracket the string with a leading & or +, then do an instring on &1030&. That will remove those annoying false positives.

HTH
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.