Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. Repositories
  4. XML Data Source
  5. Tests for XML Data Sources
  6. Connections
  7. Expressions
  8. Table Pairs
  9. Tests for Table Pairs
  10. Single-Table Constraints
  11. Tests for Single-Table Constraints
  12. Examples of Tests from Spreadsheets
  13. SQL Views
  14. Lookup Views
  15. Join Views
  16. Aggregate Views
  17. Business Intelligence and Reporting Tools Reports
  18. Dashboards
  19. DVOCmd Command Line Program
  20. Troubleshooting
  21. Appendix A: Datatype Reference
  22. Appendix B: Reporting Views
  23. Appendix C: Metadata Import Syntax
  24. Appendix D: Jasper Reports
  25. Appendix E: Glossary

Data Validation Option User Guide

Data Validation Option User Guide

BIRT Report Generation

BIRT Report Generation

You can generate a report for one or more table pairs or single tables. You can also generate a report for all table pairs and single tables in a folder or a test.
Right-click the objects for which you want to generate a report, and select
Generate Report
. The
Report Parameters
dialog box appears.
The following table describes the report options:
Option
Description
User
User that created the tests. By default, Data Validation Option generates a report for the tests that the current user creates and runs. Select
All
to display tests created and run by all users. Select a user name to display tests created and run by that user.
Table Pair
Table pairs or single tables for which you want to run a report. You can generate a report on all table pairs and single tables, on the table pairs and single tables in a folder, or on a test. Data Validation Option gives you different options depending on what you select in the Navigator or details area. For example, you can generate a report on all table pairs and single tables or on the table pairs and single tables in the folder.
Recency
Test runs for which you want to run a report. You can select the latest test runs or all test runs.
Result Type
Test results for which you want to run a report. You can select all results, tests that pass, or tests that do not pass.
Run Dates
The test run dates. Enter the from date, to date, or both in the format MM/DD/YYYY.
Report Subtitle
Data Validation Option displays the subtitle on each page of the report.
Show Bad Records Detail
Show details of bad records. The report displays a delimiter before and after string values to help you identify whitespace. The report displays the difference in value along with the percentage of difference for numeric data types. This option is available only for the Detailed Test Results report.
If you change the Data Validation Option repository after you configure BIRT reports, you must restart the Data Validation Client to generate accurate reports.