Print Page | Close Window

Parameter - Mulitple select

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13721
Printed Date: 28 May 2024 at 2:18am


Topic: Parameter - Mulitple select
Posted By: sa-user
Subject: Parameter - Mulitple select
Date Posted: 12 Jul 2011 at 9:40am
Hi,
 
Can any one give me steps to configure a parameter to select mulitple values.
 
I am using a Command SQL statement, The where clause is as below
 
where name like ('%{?PF}%') and identification_code like ('%{?PFC}%')
 
 
I have created 2 parameters PF and PFC.
 


Replies:
Posted By: sharona
Date Posted: 14 Jul 2011 at 2:02am
i found this on the web, not sure it is accurate but...

The parameter editor in the SQL command dialog box lets you enter only a single default value. So if you wish to load more default values, return to the Field Explorer and add more default values to the parameter there.

This feature supports string, date and numeric parameters, but they must be a single value. Multi value parameters are not supported.



-------------
sharona

Posted By: sharona
Date Posted: 14 Jul 2011 at 3:21am
i found this also,

{?Recruiter} = {field}

or {?Recruiter} like '%'


-------------
sharona


Print Page | Close Window