Entering nothing or blank values for a parameter

[susanna123]

I currently have a start and end time parameter and a processing time parameter.
Is there a way to allow it so that these fields can be left blank and when the report runs, it will run for all records.

 

[JasonDove]

If you're using Crystal Reports 2008, select the "Optional Prompt" and use the HasValue formula function.

If not, then it takes some formula coding to work around it.

"Crystal Reports Formulas Explained" is the most advanced book on the market. Currently available with a free 70 page Crystal Reports XI tutorial:

http://www.scry-business-intelligence.com/products/bookoffer.php

 

[susanna123]

this version is crystal reports 11.5.11.1470. How can the coding be done. Can you provide an example?

 

[JasonDove]

You need to set default date values for the parameters, then make their use conditional with an if statement.

Something like:

IF {?ParameterDate} = #1066,01,01# THEN
TRUE
ELSE
{Database.DateFieldYouCareAbout} > {?ParameterDate};

Assuming you are using it for record selection and the ELSE is the comparison you want.

Be warned: this can make a report slow.

"Crystal Reports Formulas Explained" is the most advanced book on the market. Currently available with a free 70 page Crystal Reports XI tutorial:

http://www.scry-business-intelligence.com/products/bookoffer.php

 

[chelseatech]

If your date parameter is a RANGE parameter, you can set it to NO UPPER BOUND or NO LOWER BOUND to include all dates up to or up from a single date.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm