Compare Differences Between Issued Reports: Workflow

Create a query or stored procedure to fetch the required data for the report.

Create a new user defined directive in the Settings sub-category of the Miscellaneous Configuration Category of the AVEVA P&ID Project Administrator. New user defined directive should be in the following format:

• USER_UNIQUENESS_QUERYNAME

Where QUERYNAME is the name of the query or stored procedure created in AVEVA P&ID Reports.

"Value" represents report column numbers separated by commas (,). Column numbers are used to identify row uniqueness when comparing data.

In the above example, the user defined directive created is USER_UNIQUENESS_CU_LINE_LIST = 1,6. Where:

• CU_LINE_LIST is the name of the stored procedure created in AVEVA P&D Reports

• 1,6 indicates that column 1(LINE NO) and column 6(P&ID Nos) determine the uniqueness of a row in the following report:

Execute the query

The new query will be added to the list of customised reports in the Customised Report tab.

Right-click it and select the Execute option.

View the Excel Reports

After executing the query, right-click on it and select View Excel Report.

The report is then generated. Issue the report by clicking Issue and entering the required details (refer to Generate a Report for details):

Highlight Differences Between Issues

To view the differences between the current report and a previous issue, click Highlight Issue Changes. A list of all the Issues of the report is then displayed:

Select the required issue from the list. Changed data is then highlighted. If there has been a change in an attribute, then that attribute's cell is highlighted. If a new row has been added, then the entire row is highlighted: