Create Reports with User Defined Queries

To generate a report spreadsheet by exporting data from user-defined database SQL queries, open the Customised Report tab.

Note: For this tab to be displayed, the Display Customised Report checkbox on the Options tab of the Options dialog must be checked.

Existing queries are listed in the top-left hand section of the tab.

Note: The list includes the pre-defined queries (refer to Create Reports with Predefined Queries) which can be used to create reports, plus pre-defined queries used when data is transferred to AVEVA Engineering (refer to "Setting up AVEVA P&ID to Connect with AVEVA Engineering" appendix in the AVEVA P&ID documentation for details). These queries may be edited if required.

Note: Queries prefixed with EXCEL_TABLE will be available for selection when placing lists of components using multi-line designators on P&ID drawings (refer to AVEVA P&ID documentation for details).

Note: In order for a report to be generated from an Excel report from a custom query, the [ID] column must be included in the query as there is a dependency on the [ID] column of the table.