Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Allow Blank Date Parameters in Crystal 11?

Status
Not open for further replies.
Oct 23, 2007
24
US
I am supposed to create a report where the user can choose to use an "as of date" or a specified "date range".
As a result I set up 3 date parameters with IF NOT ISNULL validation.
However it seems like Crystal forces me to fill all 3 parameters when I try to preview the report. Anyway, I can allow date parameters to be blank or null? Thanks.
 
If the parameter is from a stored procedure you can set it to a NULL value, and then handle the NULL's there.

I'd set the report up with a start date and End date as separate parameters and most users should be able to handle that okay.

Editor and Publisher of Crystal Clear
 
Thanks for your advice but that report isn't using a stored proc. What I ended up doing was to set up a default start date and default end date which I may or may not end up using based on some other conditions.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top