Creating and maintaining JasperReport and Oracle View reports

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.