Before run JasperReport , start database procedure
Description
Some report data structures are very complicated. After pre-computing with the database procedure and insert data into temporary table, which is then read temporary table by the jasperreport. It can simplify the Jasper Report SQL syntax and computing time.
Environment
iDempiere 6.2
Attachments
1
07 May 2019, 08:28 AM
Activity
Show:
Ray Lee May 10, 2019 at 5:29 AM
Thank you Carlos, I test it again. It's not required.
Carlos Ruiz May 9, 2019 at 10:22 AM
The patch is not required, tested and it calls the db procedure twice because is already being called in AbstractProcessCtl.run:262
Major
Some report data structures are very complicated. After pre-computing with the database procedure and insert data into temporary table, which is then read temporary table by the jasperreport. It can simplify the Jasper Report SQL syntax and computing time.