Generate error reports

You can create full reports of your row by row comparisons in one of two formats:

Define error report settings

Define all settings directly in the XTestStepValues under General Options->Error Reporting.

You need to specify at least the Report Filename.

Specify Error Reporting

Use the following XTestStepValues for your report definition:

Value

Description

Optional

Max Errors

Maximum number of errors before execution is aborted.

The default value is 100.

X

Report Filename

Full path and file name for the report, e.g. C:\Tosca_Projects\BIReports\Report.html.

The path must exist before you start the execution.

 

Format

Select CSV or HTML as format for the report.

The default format is HTML.

X

Report Unmatched Target Rows

If set to True, Tosca BI reports all unmatched target rows.

Depending on the amount of rows, this can affect the performance.

X

File Column Separator

Character which delimits new columns in CSV files.

By default, the vertical bar | is used.

X

HTML Report

The HTML report displays comparison results sorted by different criteria. Use the tabs to filter the following information:

  • Summary: shows the comparison results of the source and target data source, including an overview and column error summary.

  • Differences: shows an overview of the source and target data source. To display columns with differences only, select the check box Shows columns with differences only.

  • In source only

  • In target only

  • Invalid in source

  • Invalid in target

HTML report

If you don't specify a valid name for a column in your SQL statement, the HTML report displays the column's position as column name, e.g. #2 or #5.

To display a valid column name in the report, modify your SQL statement and run the test again.

CSV Report

The CSV report contains the differences between source and target data.

Unmatched rows are stored in a separate Unmatched.csv report.

In this example, Tosca BI compares the rows of the files SampleData.csv and SampleData2.csv.

The Street, City and Zip columns identify a row uniquely.

The report F:\reports\Report.html contains all information about the comparison.

TestCase with report