This is one of 4124 IT projects that we have successfully completed with our customers.

How can we support you?

Weißes Quadrat mit umrandeten Seiten rechts oben

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

Project period01.07.2017 - 31.08.2018

Have we sparked your interest?

Portrait Herr Knudsen, Mann im Anzug

Ole Knudsen

Key Account Manager

Jetzt Kontakt aufnehmen

Zum Umgang mit den hier erhobenen Daten informieren wir in unserer Datenschutzerklärung.

Contact now

We provide information on the handling of the data collected here in our privacy policy.

Download file

We provide information on the handling of the data collected here in our privacy policy.