Create and Edit Custom Reports

Custom reports are reports defined by the user from SQL queries on project data.

To create a custom report:

1. Click New on the Home tab to display the Select Type Report window:

   

2. Select the Custom option and click OK. The Custom Report Editor window is then displayed.

Custom reports can also be created by amending the queries from which reports generated from a list are constructed (see Create a New Report). Reports edited in this way are automatically converted into reports of the "custom" type. To edit a report in this way, click the Edit Query button on the AVEVA Electrical Report window, as described in Edit Report Details. The Custom Report Editor window is then opened, with the current queries of the report displayed.

Revision sub-reports are also custom reports, and can be edited in the same way as other reports if required. Refer to Create Revision Sub-Reports for information on how to create a revision sub-report.

To edit a custom report:

3. Select it from the Reports list and click Edit. The Custom Report Editor window is then displayed.

   

   Enter or Edit Basic Details

4. Select the plant area that the report is associated with from the list in the Area field.

5. The Grid Name field displays the name of the selected grid and cannot be changed.

6. Enter a unique name for the report in the Document No field. Enter a description in the Description field.

   Note:
   The Document No and Description fields must be completed.

7. Set the report to be "public" for the project by checking the Public checkbox. Access to the report is restricted to the current user if the checkbox is left unchecked.

8. If required, enter a full title for the report in the Title 1 and Title 2 fields.

   Add and Edit Queries

9. To add an SQL query, click Add Query. The SQL Query Maker is then displayed, in which the query can be defined.

10. To edit an existing query, select it from the list beneath the button and click Edit Query. The SQL Query maker is then displayed with definition of the selected query displayed for editing.

    

    Note:
    In order for user-defined properties to be available when constructing queries for custom reports, the Available for Custom Reports checkbox for those properties must be checked. Refer to Electrical Engineer module documentation for details.

    For information on how to use the SQL Query maker, refer to www.activequerybuilder.com.

• To delete a query, select it from the list beneath the button and click Delete Query. A message is displayed requesting that the deletion be confirmed. Click Yes to proceed.

• Click Save to save changes to the report definition and exit the window.

• Click Cancel to exit the window without saving.