Crystal Reports Parameter - Mulitple select

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Parameter - Mulitple select

Author	Message
sa-user Groupie Joined: 29 Jun 2011 Online Status: Offline Posts: 65	Topic: Parameter - Mulitple select 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. Edited by sa-user - 12 Jul 2011 at 9:53am
	IP Logged

sharona Senior Member Joined: 16 Oct 2008 Location: United States Online Status: Offline Posts: 255	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
	IP Logged

sharona Senior Member Joined: 16 Oct 2008 Location: United States Online Status: Offline Posts: 255	Posted: 14 Jul 2011 at 3:21am
	i found this also, {?Recruiter} = {field} or {?Recruiter} like '%'
	sharona
	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.016 seconds.