Active Reports - Add Date Range

1.Open the Report Data Source window (see Steps 1-2 in the help article Creating an Active Report).

2.Add start date and end date parameters in the Query text box as shown below.

SELECT * FROM dt_water_level WHERE facility_id =

<%@facility_id|Facility ID:|1|S%> and sys_loc_code =

'<%@sys_loc_code|Location:^select sys_loc_code from dt_location

where facility_id = @facility_id||S%>' and measurement_date

between '<%@start_date|Date Range\Start:|1/1/2000|D%>' and

'<%@end_date|Date Range\End:|12/31/2000|D%>'

1.Click OK.

2.In the Report Designer main menu, click File and select Preview. Select a location and date range when prompted.

3.After selecting the location and date range, click Go in the Preview menu. The report will show only water levels for that location within the selected date range.

Tip: When selecting date ranges, either enter the dates manually or select from the calendar by clicking the arrow beside the date text box.

4.When finished, close the Preview window.