Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Number Parameter Post Reply Post New Topic
Author Message
pungigi
Newbie
Newbie


Joined: 02 Oct 2007
Location: United States
Online Status: Offline
Posts: 7
Quote pungigi Replybullet 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 IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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 IP Logged
pungigi
Newbie
Newbie


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

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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 IP Logged
newbie
Newbie
Newbie


Joined: 10 Jul 2007
Online Status: Offline
Posts: 29
Quote newbie Replybullet 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 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.000 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.