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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

running a report with date parameters

Status
Not open for further replies.

susanna123

Technical User
Jan 22, 2010
79
CA
I have a crystal report that is scheduled to run on a daily basis

The report has 2 parameters, a start and end date.

Since the report is to be run on a daily basis, by selecting a start date and an end date would only give me the data
between and including those dates, no matter if it is run for today, tomorrow or the next day.

Is there a way to change the start and end date parameter values to "null" so that it runs with different data for the next day.

 
report is not based on any store procedure. It just utilizes tables.
 
What is your logical date range for each day? excample...Last two days?
 
my start date parameter and end date parameters are both of type: date.

I am trying to set a default value of 01/01/1900 so that if the default value is selected, it will display all records otherwise display records based on the selected date.

(if {?@Start Date} = date(01/01/1900) then
true
else

{@Instance Start Time} >= {?@Start Date}) and
(

(if {?@End Date} = date(01/01/1900) then
true
else

{@Instance End Time} = (datetime(9999,9,9,9,9,9)) or
{@Instance End Time} <= {?@End Date})
)

Thks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top