Overview
Users can run EQuIS table label reports directly in ArcGIS Pro and automatically add the report output to the map as either a Link or Snapshot layer. This allows users to display tables of analytical data from an EQuIS Database directly linked to locations on their maps.
Users can run saved table label user reports or create ad hoc table label reports to add EQuIS data as map layers. The ArcEQuIS Table Labels report needs to be published to the database to be available in the Table Labels Modal. These report options are available on separate tabs in the Table Labels Modal:
•Table Label User Reports – Saved user table label reports (including ArcEQuIS Crosstab Converter reports; see additional instruction below.)
•Table Label Ad-Hoc Reports – Published ArcEQuIS Table Labels report
For each of the reports, users can select specific report parameters and save the report output to the database as well as create the map layer.
To use the Table Label and Report Modal functionality, users must:
•Be assigned to the REST API role.
•Have the following permissions, at minimum, to add a report to ArcEQuIS:
•Viewer permission on the Facility object type for the facility being associated with the report being created.
•Creator permission on the Reports object type.
Table Label User Reports Tab
1.Click the Table Labels button on the ArcEQuIS ribbon to open the Run EQuIS Report window.
2.Select the Table Label User Reports tab.
3.Select the desired facility and the desired saved user report for the ArcEQuIS Table Labels report or ArcEQuIS Crosstab Converter report, and then click Next.
Notes: •Only individual facilities can be selected, not facility groups. •The Next button will be disabled unless both a facility and report are selected. |
4.Report Parameters – The Report Parameter Editor will open for Table Labels user reports (ArcEQuIS Crosstab Converter user reports will go straight to the report preview; next step). If changing report parameter values, select the desired values in the Report Parameters Editor (see the Report Parameter Editor section for operational details). Selected report parameter values are listed next to the selected report parameter, separated by the pipe (|) character. Click Back to return to the facility and report selection screen or click Next to preview the user report output.
5.The user report output preview, based on the selected report parameters, can be reviewed to ensure the expected information is included in the report prior to adding the report layer to the map. If changes to the report parameters need to be made, click the Back button.
The report name remains the same unless the user makes any changes to parameter selections, then name of report is changed to 'Report Name [Now Datetime]'. The user can modify this auto-generated report name before adding the report to the map.
Notes: •Saved user reports cannot have the same name as reports that already exist within the connected site's database. •Saved user report names cannot contain the following SQL reserved words: ▪EXEC ▪DROP ▪ALTER ▪CREATE ▪DISABLE ▪ENABLE ▪INSERT ▪UPDATE ▪DELETE ▪TRUNCATE •Saved user report names cannot contain more than 64 characters, including white space (i.e., blanks). |
6.Once the user report preview contains all of the desired information, click the Add Layer button to save the report in the site's database as a user report and display the user report as a map layer.
a.Two options are available, As Link and As Snapshot. The As Link option loads the report with a connection to the Enterprise site, allowing the report to be refreshed to display the most recent data. The As Snapshot option loads a static, point-in-time snapshot of the report whose values are saved in an ArcGIS file on the user's computer.
Table Label Ad-Hoc Reports Tab
1.Click the Table Labels button on the ArcEQuIS ribbon to open the Run EQuIS Report window.
2.Select the Table Label Ad-Hoc Reports tab.
3.Select the desired facility and the published ArcEQuIS Table Labels report, and then click Next.
Notes: •Only individual facilities can be selected, not facility groups. •The Next button will be disabled unless both a facility and report are selected. |
4.Report Parameters – Select the desired report parameters in the window. See the Report Parameter Editor section for operational details. Selected report parameter values are listed next to the selected report parameter, separated by the pipe (|) character. Click Back to return to the facility and report selection screen or click Next to preview the ad hoc report output.
5.The ad hoc report output preview, based on the selected report parameters, can be reviewed to ensure the expected information is included in the report prior to adding the report layer to the map. If changes to the report parameters need to be made, click the Back button. Before adding the report to the map, users are able to add a custom name for the user report that will be saved when adding a layer is completed. By default, the report name will be the 'Report Name [Now Datetime]' with user name appended.
Notes: •Saved user reports cannot have the same name as reports that already exist within the connected site's database. •Saved user report names cannot contain the following SQL reserved words: ▪EXEC ▪DROP ▪ALTER ▪CREATE ▪DISABLE ▪ENABLE ▪INSERT ▪UPDATE ▪DELETE ▪TRUNCATE •Saved user report names cannot contain more than 64 characters, including white space (i.e., blanks). |
6.Once the ad hoc report preview contains all of the desired information, click the Add Layer button to save the report in the site's database as a user report and display the user report as a map layer.
b.Two options are available, As Link and As Snapshot. The As Link option loads the report with a connection to the Enterprise site, allowing the report to be refreshed to display the most recent data. The As Snapshot option loads a static, point-in-time snapshot of the report whose values are saved in an ArcGIS file on the user's computer.
ArcEQuIS Crosstab Converter Report
The ArcEQuIS Crosstab Converter Report has functionally been replaced by the ArcEQuIS Table Labels Report and EarthSoft recommends using the ArcEQuIS Table Labels report instead. Previously configured, published, and saved ArcEQuIS Crosstab Converter user reports will work in the Table Labels modal to save as layers on the map.
When using the ArcEQuIS Crosstab Converter Report rather than the ArcEQuIS Table Labels report, additional steps are required to have a saved user report be available in the Table Labels modal and work correctly to generate table labels on the map.
1.In EQuIS Professional, publish the ArcEQuIS Crosstab Converter Report (EarthSoft.Reports.Library.627608.dll) to the database.
2.Follow instructions on the ArcEQuIS Crosstab Converter Report page to publish a crosstab. Note the requirements that the crosstab configuration uses 'Separate tables by each unique' option set to SYS_LOC_CODE and is published as a grid report.
3.In EQuIS Professional or EQuIS Enterprise, open the published crosstab from Step 2. Create and save a User Report to specify the parameter selections used to generate the Table Labels.
4.In EQuIS Professional or EQuIS Enterprise, open the ArcEQuIS Crosstab Converter report. Select the User Report from Step 3, then create and save a User Report.