1.Open the Report Data Source window (see Steps 1-2 in Active Reports - Create Active Report).
2.Add SYS_LOC_CODE as a parameter 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%>'
Note: If an error message is received, make sure the SQL code is entered exactly as it appears here.
2.Click File and select Preview in the Report Designer main menu. A prompt to select a location will display.
3.Select a location; click Go in the Preview menu. The report will show only water levels for that location.
4.Close the Preview window when finished.
Copyright © 2021 EarthSoft, Inc • Modified: 17 Nov 2020