Print Page | Close Window

Comma Separated Parameter

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22319
Printed Date: 24 Apr 2024 at 5:45am


Topic: Comma Separated Parameter
Posted By: dmkanz
Subject: Comma Separated Parameter
Date Posted: 02 Jun 2017 at 10:06am
So i have a parameter that is a string that I want to allow the user to enter multiple values (i.e. 1, 12, 15)

but when I call the parameter in my Selection Formulas > Report section with an if statement it returns 1, 2, 12, 15, 5)

it seems crystal is ignoring the comma and picking every possible number

Here is my if statement

(if {?MarketTypes} <> '' then {JCJMPM.udMarketType} in {?MarketTypes}
else 1 = 1) and

Thanks DMKanz



Replies:
Posted By: dmkanz
Date Posted: 02 Jun 2017 at 10:10am
Sorry - posted to the wrong forum - recreated in correct forum - please disregard - My apologize


Print Page | Close Window