Report Name: ArcEQuIS Table Labels (example)
File Name: EarthSoft.Reports.Library.d36974.dll
Dependencies: Analytical Results II (EarthSoft.Reports.Library.50943.dll) and Action Level Exceedance II with Parameters (EarthSoft.Reports.Library.51729.dll)
Software: EQuIS Professional and EQuIS Enterprise
Source: EQuIS Professional install, EQuIS Enterprise install
Language: English
Output Type: Report Grid
Description: The ArcEQuIS Table Report creates and converts the crosstab into text format. The formattable text output is used with the ArcEQuIS plugin to generate Table Labels boxes on the map.
Installation Instructions:
This report assembly is part of the EQuIS Professional installation. The report must be published to the database to be used in the Table Labels modal in ArcEQuIS.
Overview:
The report takes user selected Analytical Results and Action Level parameters, including crosstab configuration, and options for formatting the background color and font of the table labels. Using these parameters, the report generates a grid table that contains a crosstab converted into text format.
Note: The tables will only display correctly in ArcGIS Pro when using a monospaced font (e.g., Courier New).
|
Report Output
|
SYS_LOC_CODE
LATITUDE
TABLELABEL
|
Y_COORD
LONGITUDE
LABELFORMAT
|
X_COORD
SURF_ELEV
|
Report Parameters
|
Analytical Results section
Location
|
Location section for selecting individual locations, location groups and whether the DT_GEOGRAPHY table should be used for coordinates.
|
Sample
|
Section for selecting sample related parameters.
|
Test
|
Section for selecting test related parameters.
|
Result
|
Section for selecting result related parameters.
|
Additional Fields
|
Section for selecting additional fields if they've been configured.
|
|
Crosstab Configuration section
Column Headers
|
Choose which fields to include in column headers.
|
Row Headers
|
Choose which fields to include in row headers.
|
Tabbed Data
|
Choose which fields to include in the tabbed data.
|
Display Action Level
|
Choose to display action level in the column header or row header.
|
Format Table Labels
|
|
Background Color
|
Choose color for labels.
|
Monospaced Font
|
Choose font for labels.
|
Header Font Format
|
Choose format for labels (Bold, Italics, Underline).
|
Header Font Size
|
Choose font size for labels.
|
|
Action Level section
Action Level 1
|
Select one action level to use for comparison.
|
Formatting 1
|
Edit formatting parameters (Text Format, Background Color, and Text Color)
|
Action Level 2
|
Select one action level to use for comparison.
|
Formatting 2
|
Edit formatting parameters (Text Format, Background Color, and Text Color)
|
Action Level 3
|
Select one action level to use for comparison.
|
Formatting 3
|
Edit formatting parameters (Text Format, Background Color, and Text Color)
|
Action Level 4
|
Select one action level to use for comparison.
|
Formatting 4
|
Edit formatting parameters (Text Format, Background Color, and Text Color)
|
Action Level 5
|
Select one action level to use for comparison.
|
Formatting 5
|
Edit formatting parameters (Text Format, Background Color, and Text Color)
|
Action Level 6
|
Select one action level to use for comparison.
|
Formatting 6
|
Edit formatting parameters (Text Format, Background Color, and Text Color)
|
Comparison
|
|
Operator
|
Select an operator: <, <=, >, >=
|
Unit
|
Select a comparison unit: ACTION_LEVEL_UNIT or REPORT_RESULT_UNIT.
|
Significant Figures
|
Select the desired number of significant figures.
|
Compare to Action Level Before Applying to Significant Figures
|
Select 'Yes' to compare results before significant figures are applied. Select 'No' to compare results After significant figures are applied.
|
Display in scientific notation
|
Yes | No
|
Flagging
|
|
Show Results
|
Select 'Show All' to show all results (with exceedances flagged) OR 'Show Only Exceedances' OR 'Show With Any Exceedance' to show results that exceed any of the selected action levels.
|
Flag Non-Detects
|
Select 'Yes' to flag non-detect results whose detection limit exceeds the action level OR 'No' to not flag them.
|
Matching Default
Match Facility
|
Match Matrix
|
Match Fractions
|
Match Method
|
Match Depth
|
Depth Type
|
|
|
Section for default matching conditions. Default values for this section are True. The default depth type is Sample Depth.
|
Matching Special
Match Subfacility
|
Match Start-End Dates
|
Match Seasonal Dates
|
Match Land Use
|
Match Geologic Unit
|
Geologic Unit Code or Type
|
Geologic Unit Columns
|
|
|
Section for special matching conditions. Default values for this section are False. The Geologic Unit section also includes parameters for Geologic Unit Code or Type and Geologic Unit Columns and does not have defaults.
|
|
|
* This table shows partially expanded parameters. Refer to related report articles for complete input parameter lists (e.g., Analytical Results II.)
** The Additional Fields parameter may be customized as explained in the help article How To Customize Additional Fields Parameter.
|
Comparison | Operator Parameter: There are four options for the Comparison | Operator parameter:
•"<" Within Limits (Exclusive): The analytical result is flagged as an exceedance if it is less than the action level and, if one exists, greater than the action_level_min. Equalities are not considered exceedances.
•"<=" Within Limits (Inclusive): Same as above, but equalities are considered exceedances.
• ">" Exceeds Limits (Exclusive): The analytical result is flagged as an exceedance if it is greater than the action level, or, if one exists, less than the ACTION_LEVEL_MIN. Equalities are not considered exceedances.
•">=" Exceeds Limits (Inclusive) (the default): Same as above, but equalities are considered exceedances.
Comparison | Unit Parameter: There are two options for the Comparison | Unit parameter:
•"report_result_unit": Values will be displayed in the units of the REPORT_RESULT column. Other columns will be converted to matching units as necessary.
•"action_level_unit": Values will be displayed in the units of the ACTION_LEVEL column. Other columns will be converted to matching units as necessary.
