Null Date Parameters

[acr1]

Team
Have searched to no avail... Can a date parameter report bring all data if you decide to have a null date range...(e.g. you might specify the Month Of April but if you dont;...you get all data for February,March and April..it may sound stupid but am sure it must work.
TIA
Angus

 

[kenhamady]

I don't think a paramater can truly be null - it will be the default for its data type. But, you could set the default to a dummy date (ie 1/1/1950) and then use an if-then for selection:

If {?date} = Date (1950,1,1)
then True else
{?date} = {tbl.Date} Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[acr1]

Ken
Thanks for your help
Am using an Oracle DB and SQL code in Seagate Info Vs 7.0 queries.. Where do I set these defaults..?? and place your Code..
TIA
Angus

 

[kenhamady]

You set the default value in the report's parameter field, and the formula would be your record selection formula in the report. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com