Classic Reporting

Two actions are used to generate the query results:

GenerateHTMLreport for an HTML report in a new browser window

GenerateCSVReport for a tab-separated file on disk

Parameters

base: the base URl where the resources can be found. By default this will be com/trax/ogf/print/templates

stylesheet: this is the style sheet which will be used for the generated results. The available style sheets can be seen in the print-xml properties file. Examples are report.html and report.csv.

customizer: Optional customization can be done here. A java class has to be written in order to use these customizations. As value, they have the customizer setting (between xml and customizer) from the print-xml properties file. For example custom will stand for xml.custom.customizer. the configured parameter will thus be customizer set as custom

Print-XML Properties File

format.date=dd/MM/yyyy format.datetime=dd/MM/yyyy HH\:mm\:ss format.bigdecimal.maxscale=2

xsl.AccountStatement.AccountStatement.template=com/trax/accountstatement/print/Ac- countStatement.html.xsl xml.AccountStatement.AccountStatement.customizer=com.trax.accountstatement.print.Ac- countStatementXmlCustomizer

xml.AccountStatement.AccountStatement.depth=4 xsl.Payment.Envelope.template=com/trax/payment/print/Envelope.html.xsl xml.Payment.Envelope.customizer=com.trax.payment.print.EnvelopeXmlCustomizer xml.Payment.Envelope.depth=4 report.html=com/trax/ogf/print/templates/report.html.xsl report.csv=com/trax/ogf/print/templates/report.csv.xsl custom.report=com/trax/template/print/report.html.xsl xml.custom.customizer=com.trax.template.print.CustomCustomizer

File 72 Print-xml.properties

To change the images for the generated file, modify the resources in application.properties file. resources.url=http://localhost:8081/webstart. The logo itself is a png file in the webstart.war

Impact on Performance

Both of these reports use the same parameters and are based on the generate report rule. Since generation takes place on the server, performance of the entire application would suffer if large queries were performed. For this reason, a default limit of 20.000 data rows & fields has been implemented. This means that the total of number of rows x number of fields per row may not exceed 20.000. A counter will track the number of resulting data fields which have to be returned and display a warning if the result exceeds the size. The “report-limit” parameter can be set in the application.properties file. If no value is set, the default of report-limit = 20000 will be supposed.

Every query is also a database connection so care must be taken that not too many connections happen in parallel as the amount of possible connections is limited by a setting in the application.properties file.