Non Mandatory Parameter

Printed From: Crystal Reports Book — Forum Name: Talk with the Author

Posted By: twinkle — 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

Edited by twinkle - 18 Jun 2009 at 2:57am

Posted By: BrianBischof — 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