Non Mandatory Parameter
Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6768
Printed Date: 03 May 2024 at 11:08pm
Topic: Non Mandatory Parameter
Posted By: twinkle
Subject: Non Mandatory Parameter
Date Posted: 18 Jun 2009 at 2:56am
|
Hi,
I am looking to create some parameters on a report, where they are non mandatory is this possible?
EG i may have three parameters:
Date
Revenue
Office
The user may decide to only input the date and office and not know the revenue, thus wants to not fill in this parameter.
Please advise
Thanks
 B
|
Replies:
Posted By: BrianBischof
Date Posted: 18 Jun 2009 at 11:39pm
|
You can write your record selection formula so that it only uses that field if it has a value. For example, the following condition will only use Revenue if it is not zero: {?Revenue}={table.revenue} OR {?Revenue} = 0 ------------- 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> |