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.