Note: This article creates a report using data from two data sources (Water Levels (Most Recent) and VW_WELL) in the database. Therefore, users need to create a JOIN in the SQL Data Source to select bounds from both reports in the Report Explorer. |
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 the VW_WELL fields to the Bounds list by entering the following to the end of the Data Source query for the report:
as wl inner join vw_well as w on wl.facility_id = w.facility_id and wl.sys_loc_code = w.sys_loc_code inner join dt_facility as f on w.facility_id = f.facility_id |
5.Click OK.
6.Go to File > Save As and save the report as <Your Initials>_Most Recent.rpx.
7.In the current version of Active Reports, the Bounds list does not update to reflect the additions made to the Data Source query. Show the additions by doing the following:
a.Open the Data Source code window and copy (Ctrl + C) the code from the saved report.
b.Close Active Reports.
c.Launch Active Reports.
d.Open the Data Source window and paste (Ctrl + V) the code in the Report Data Source Window.
e.Expand the Bounds in Report Explorer; the data source will be added.
f.Open the created rpx file by selecting File > Load Report > From File. All of the fields for the Data Source will still be listed in the Bounds.