There is no simple way to default date parameters to a date that is relative to the current date. You have to use a formula to get the default values.
If your report is not based on a stored procedure, you can do the following:
1. Create two date parameters that have a default value of something like 1/1/1900 - this date should be out of the range of the dates you would expect to see on your report.
2. Create two formulas - one for the start date and one for the end date. The start date might look something like this:
DateVar StartDate;
If {?Admission Start Date} = Date('1/1/1900') then
(
StartDate := DateAdd('m', -1, CurrentDate);
StartDate := Date(Year(StartDate), Month(StartDate), 1);
)
else
StartDate := {?Admission Start Date};
StartDate
You'll do something similar for the end date - I recommend getting the first day of the current month and subtracting 1.
3. In the Select Expert, edit the selection formula so that it looks something like this:
If you're using a stored procedure to get the data for your report, there are a couple of other things that you need to do.
-Dell
IP Logged
