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
Senior Member
Senior Member

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

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:

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

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
Admin Group
Admin Group

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1562
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

Joined: 21 Dec 2007
Online Status: Offline
Posts: 4351
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.

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.172 seconds.