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 |
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 |