1.In EQuIS Professional, click the Forms button (in Open group on Home EQuIS Ribbon).
2.Select and open the Active Reports Form.
3.In the Detail pane, click the cylinder-shaped database button to the left of the word "Detail". This will open the Report Data Source window.
4.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. |
5.Click OK.
6.Click File and select Preview in the Report Designer main menu. A prompt to select a location will display.
7.Select a location; click Go in the Preview menu. The report will show only water levels for that location.
8.Close the Preview window when finished.