Further development of test reports using Microsoft Reporting Services
Project duration: 4 years, 3 months
Brief description
In the customer's own custom software, an inflexible solution for PDF display of data from chemical and physical test methods is replaced by product tests. The project involves further development of a test report and implementation of two additional test reports on the SSRS platform.
Supplement
The test reports to be generated refer to data that is stored within an Oracle database. The source data is formatted and aggregated in the database so that it can be used in test report creation. The following main tasks arise within the existing customer IT infrastructure: Design and development of the report layout according to the customer's wishes. Loading of the relevant data via stored procedures implemented on an SQL server and presenting them in the report. Modification and connection of a front end integrated with the customer's standard software for calling the reports with transfer of the relevant parameters for determining the report data.
Subject description
In the customer's own custom software, an inflexible solution for PDF display of data from chemical and physical test methods is replaced by product tests. The SQL queries for determining the relevant display data are moved from the software to the database, from which the data for the test report are read dynamically at the runtime of the report rendering. The modified report and the newly developed reports also read dynamic path information for test images from the customer intranet and show the images behind the paths. An individually developed code is used to create a visually appealing view of comment texts by users of the customized software in RTF format.