This is one of 3224 IT projects that we have successfully completed with our customers.How can we support you?
Creating and maintaining JasperReport and Oracle View reports
Project duration: 1 year, 2 months
Brief description
Involvement in the group-wide provision of reports on the steering and controlling of internal core processes, particularly processing raw goods for the food industry. Data are procured from an Oracle database using SQL queries and are then processed partly within the SQL construct and partly using Jasper Reports from TIBCO.
Supplement
The Oracle database is the core of the raw goods system and is used here as the source for reporting. TIBCO's Jaspersoft is used for data usage and representation to create the open source format 'JasperReports' .nThe report definition is created here in JRXML (XML variant of JasperReports) and the report definition is made available on a dedicated server. There are simple reports and complex 'multireports', which are composed of different subreports that can be selected and displayed depending on the selection. Examples that have been implemented by the PTA can be found in the German and Polish companies regarding documentation of income and payment. The rather long SQL of these multireports could at least be split by using the with construct and can therefore be tested separately in its individual parts.
Overview
- Industries food industry
- Specialist tasks batch processing, corporate controlling, operative controlling, product costing, product data
- DV tasks customised software support
- System environment Client/Server, host systems
- Procedure model customer standard
- Development/ test tools Jasper Reports, Oracle SQL Developer,
Project period01.07.2017 - 31.08.2018
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
