When there is a need to move to an Opensource technology like BIRT, the following aspects need to be kept in mind while validating the reports, when comparing with the source report.
- Data Validation:This can be done by visually comparing the PDF outputs or by comparing the excel outputs using macros and Excel functions.
- Functionality: By providing multiple prompt values. Note that if source platform (like Oracle Report Builder) has Stored Procedure, the object need to be in separate Dataset and it should reflect in Master Page by Binding.
- Performance: By running huge volumes of data under multiple scenarios.
- Filters and Formulae – Compare the filters and formulae. This can be done by manually comparing with the source SQL and PL/SQL.