Table Difference Report

Table Difference Report shows the differences between two selected table variable revisions. In a Table Difference Report one revision serves as the base to which the other revision will be compared. Differences are listed in a PDF report. The Table Difference Report is available to any global or local table variable. The differences that are recognized are:

  • Table data that has a different value. The row and the differing values are displayed.
  • Changes to attributes and columns.

Only revisions of the same table variable can be compared. You cannot compare revision 2 of Table A to revision 3 of Table B.

Reports are displayed in the Insbridge Document Viewer. Reports can be saved to your local drive or network or printed. No editing can be done on the Insbridge Document Viewer.

Table Difference Report Right Click Menu

Table Difference Report Right Click Menu

Note: NOTE: OBI Publisher must be installed and running in order for reports to be displayed. If you receive an OBI Publisher error, please contact your system administrator.

Where you select to run the report determines what revision acts as the base. You can select the comparison table only. If you run the report from the Program Details tab, the base revision is revision 1.  If you want another revision to serve as base, you must show/hide revisions and select the revision you want to act as base. Right click and select to run the Table Difference Report from that revision.

 

Running a Table Difference Report
  1. Select the table variable where you want to view the differences between revisions.
  1. Right click and select Table Difference Report. A wizard is displayed.

Selecting Revisions to Compare

Selecting Revisions to Compare

  1. The base revision is determined by where the run report was executed and cannot be changed in the wizard. If this is not the revision you want to serve as base, close the wizard to return to the window that contains that revision you want to serve as base. Run the report from that revision.
  1. If the base is correct, select the Comparison Table Revision. All revisions are listed. This can be any other revision, either newer or older.
  1. Click Run to start the report. The progress is displayed as the report runs

Successful Run of a Table Comparison Report

Successful Run of a Table Comparison Report

  1. When the wizard finishes, click the “Click here to view the report” link. The report is displayed in the Insbridge Document Viewer.

If any errors occurred while running the report or displaying the report, please contact your system administrator.

Page 2 of Table Comparison Report

Page 2 of Table Comparison Report

The first page contains a description of the table variable and location of the program from where the report was run. The second page of the table comparison report lists out the details. The definition changes are listed first and data changes are next.

Table Difference Reports are limited to the first 500 rows of data.

Reports are displayed in the Insbridge Document Viewer. These documents are read-only. Reports can be saved to your local hard drive or network or printed. No editing can be done on the Insbridge Document Viewer.

Note: When you do a “Save As” from the Insbridge Document Viewer, you should rename the file. By default, when you go to save a file in the Insbridge Document Viewer, everything is named “InsbridgeDocument”. It is recommended that you rename the file.