This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4813 IT projects that we have successfully completed with our customers.How can we support you?
Setup and creation of Microsoft Reporting Services for displaying test reports
Project duration: 2 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 to be replaced by product tests. The project includes integration and operation of Microsoft SQL Server Reporting Services (SSRS) into the customer's existing IT landscape, as well as the implementation of a test report 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. Loading of the relevant data from the Oracle DB via stored procedures implemented on an SQL server and their formatting for presentation in the report. Implementation of a frontend integrated with the customer's standard software for calling the report with transfer of the relevant parameters.
Subject description
In the customer's own custom software, an inflexible solution for PDF display of data from chemical and physical test methods is to be 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 developed report also reads dynamic path information for test images from the customer intranet and shows the images behind the paths.
IT project data
- Industries services
- Specialist tasks inspection management, Reporting
- DP tasks customised software new development
- System environments Client/Server
- Procedure model customer standard
- Programming languages C-Sharp, VBA
- Databases MS SQL Server
- Development and test tool MS Visual Studio
- Middleware and frameworks MS SQL Server Reporting Services (SSRS)
Project period01.03.2014 - 01.05.2014
Customers who trust us
