•Applying Excel Templates to Exports
Export the results of a grid report, such as Analytical Results II (AR II), to an Excel file by clicking Send to Microsoft Excel.
To change report values (such as reference values) without changing anything in the database, use the remap feature via the Find 
button.
Warning: In some cases, using a single "custom" filter on a column can also lead to an export that is incomplete. For specifics, see Using Custom Filters on Data Tables. |
The exported result Excel file contains two worksheets: the Sheet1 tab for results, and the Parameters tab for the parameters used to generate the results.
Note: Users can load the report file to load its parameters to the report generating the results, or a report with all or some of the used parameters (for example, loading an Excel file of Action Level Exceedance II into its dependency Analytical Results II, or vice versa). |
Applying Excel Templates to Exports
Any published report or saved user report can be configured to export to Excel in an Excel Template via the following steps:
1.Upload the template file into the DT_FILE table using the Docs and Photos Form.
2.Once the file is in DT_FILE, copy the FILE_NAME of the file you just uploaded.
3.a) For published reports, administrators can open ST_REPORT, and filter on the DISPLAY_NAME to find the record for the report you wish to apply the template to. Then, paste the FILE_NAME from DT_FILE into the XLT field in ST_REPORT. Save.
b) For saved user reports, open ST_USER_REPORT, clear the filter, then filter on the DISPLAY_NAME to find the record for the user report you wish to apply the template to. Then, paste the FILE_NAME from DT_FILE into the XLT field in ST_USER_REPORT. Save.