Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions  
Message Icon Topic: Crystal Command Format a String Post Reply Post New Topic
Author Message
Hackareatech
Newbie
Newbie


Joined: 07 Jan 2019
Online Status: Offline
Posts: 1
Quote Hackareatech Replybullet Topic: Crystal Command Format a String
    Posted: 11 Jan 2019 at 4:47am
I am writing a Crystal Command for use with a Cache DB.

My parameter sent in to the command is a STRING variable in the format of Prog&Prog&Prog (ex. 1-BA04&1-BA05&7-FN01) with no preceding or trailing characters such as ' " space, etc.

The where clause in my query looks similar to this:
WHERE program_code IN {?program_list}

Because this is alphanumeric list, I need the format to ultimately be:
WHERE program_code IN '1-BA04','1-BA05','7-FN01'

My question is how to add the beginning and ending single quote ' AND the ',' (single quote comma single quote) between the program names.

I have modified my WHERE to look like this:
WHERE program_code IN REPLACE(?program_list),'&',''',''')

I'm not sure if that will truly replace my & with ',' and I'm still missing the beginning and ending '

Any help in this would be most appreciated.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 8959
Quote DBlank Replybullet Posted: 11 Jan 2019 at 10:54am
are you asking how to multi-select in a parameter (from a program list) and use the multiple selections to filter the data set?

Edited by DBlank - 11 Jan 2019 at 10:55am
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.