Crystal Reports Mulitple Values in Parameter

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

Topic: Mulitple Values in Parameter
	Page of 2 Next >>

Author	Message
sa-user Groupie Joined: 29 Jun 2011 Online Status: Offline Posts: 65	Topic: Mulitple Values in Parameter Posted: 12 Jul 2011 at 7:44am
	Hi I have a parameter and i have set "Allow Multiple Values" to true. However when i do a search by selectin multiple values i do not get any results back. I Must be be missing something silly. Any clues on this. Thanks in Advance
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Jul 2011 at 7:53am
	what is your select statement?
	IP Logged

sa-user Groupie Joined: 29 Jun 2011 Online Status: Offline Posts: 65	Posted: 12 Jul 2011 at 7:59am
	My SQL (Command) statement has like ('%{?Country}%'))
	IP Logged

sa-user Groupie Joined: 29 Jun 2011 Online Status: Offline Posts: 65	Posted: 12 Jul 2011 at 8:06am
	I also tried with an in in ('%{?Country}%'))
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Jul 2011 at 8:08am
	so you are using a COmmand parameter and letting uers type it content rather than a List Of Values (lov)?
	IP Logged

sa-user Groupie Joined: 29 Jun 2011 Online Status: Offline Posts: 65	Posted: 12 Jul 2011 at 8:17am
	This is how my formula looks. {Command.COUNTRY} like {?Country} Users still have to select from a list of values, But i want them to select multiple values and so the search should return all records. While what i think is happening is in the search when i select multiple values it is anding while it should or
	IP Logged

sa-user Groupie Joined: 29 Jun 2011 Online Status: Offline Posts: 65	Posted: 12 Jul 2011 at 9:39am
	What should it look like?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Jul 2011 at 11:22am
	are you using a command statement or the select expert in crystal? in crystal you can just make it = {Command.COUNTRY} = {?Country}
	IP Logged

sa-user Groupie Joined: 29 Jun 2011 Online Status: Offline Posts: 65	Posted: 12 Jul 2011 at 11:24am
	I am using command statement
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Jul 2011 at 11:31am
	i rarely use commands so not sure about this but you created the param in crystal not the command so you can populate the lov, correct? if so move your select criteria into crystal and out of the command (no where clause in teh command) as I don't think you can reference the crystal param in the command
	IP Logged

Page of 2 Next >>

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.