Crystal Reports Number Parameter

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

Topic: Number Parameter

Author	Message
pungigi Newbie Joined: 02 Oct 2007 Location: United States Online Status: Offline Posts: 7	Topic: Number Parameter Posted: 02 Oct 2007 at 10:38am
	I have a parameter on a report which requires a number to be input, I want the user to be able to input a specific number OR leave blank for all, can this be done?? Thanks
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 02 Oct 2007 at 10:43am
	You can't leave it blank. But you can let them enter a zero and then create a record selection filter which says that if the parameter is zero then just select all values.
	Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
	IP Logged

pungigi Newbie Joined: 02 Oct 2007 Location: United States Online Status: Offline Posts: 7	Posted: 02 Oct 2007 at 10:45am
	where would the record selection filter go, what would it look like??
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 02 Oct 2007 at 11:22am
	You need to read my free online chapters to learn more about CR and the record selection formulas. See Chapter 4 at the following link: Crystal Reports XI Book
	Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
	IP Logged

newbie Newbie Joined: 10 Jul 2007 Online Status: Offline Posts: 29	Posted: 03 Oct 2007 at 2:38pm
	You can do it if you are using Oracle database Query. 1. Create a parameter "pm_col1" with datatype either "String" or "Number"(depends on your need) in Command. 2. Append the below condition to your existing query. and a.col1 like (select decode('{?pm_col1}',null,'%%','{?pm_col1}') from dual) Hope this helps. VK
	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.