Create Reports on Duplicated and Untagged Items

To generate a report spreadsheet by exporting data from predefined database queries on duplicated items, untagged items and lines with no source and/or destination defined, select either the Export > Report Inconsistencies option from File tab menu or the Report Inconsistencies option from the Reports group of Home tab.

A Save As dialog is then displayed. Specify the name and location of the spreadsheet to be generated.

The Select reports dialog is then displayed.

The dialog includes a checkbox for the duplicated item, untagged item and lines with no defined source or destination database queries. For each query to be used to generate a report, make sure that the appropriate checkbox is checked.

To check or uncheck all the checkboxes, right-click and click on the required menu from the menu that is then displayed.

Click OK. The report spreadsheet is then generated. A separate report sheet in the spreadsheet will display the results of each selected query.

Note: The Excel template used when generating the report spreadsheet is specified on the Excel Reports tab of the Options dialog. If no template is specified on this tab, a default template is used.

Whether or not the width of columns in the report spreadsheets is to be automatically adjusted to the width of the data they contain is also set on this tab.