Crystal Reports Parameter help needed

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Parameter help needed

Author	Message
robert Newbie Joined: 18 Nov 2009 Location: United Kingdom Online Status: Offline Posts: 15	Topic: Parameter help needed Posted: 06 Jan 2010 at 3:27am
	ok i have a report which has a parameter called "depot" and in there is two options depot1 and depot2. what i want is another option called "all depots" and have it select both. how the hell do i do this????
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 06 Jan 2010 at 4:58pm
	create a param with all 3 options in it (a static param not a dynamic param). In you select statement use an or statement to handle it as: {?param}="all depots" or {?param}={table.depotfield}
	IP Logged

robert Newbie Joined: 18 Nov 2009 Location: United Kingdom Online Status: Offline Posts: 15	Posted: 07 Jan 2010 at 1:08am
	Thanks for replying, i didnt do what you said becuase i found a different way, i created another option for all depots and put the value as * then in the formula changed the = to a LIKE and that seems to work.
	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.