Hi,
I have integrated Oracle Apex version 21 with Apache FOP version 2.9 and PDF printing is working fine.
I am planning to design a screen, which will have three fields - 1) SQL query 2) XSL template 2) Report Name
A report screen will be there which will list the report name, which user saved from above screen. On click on report name, I want to call Apache FOP with SQL query result in xml format and xsl template. What is the best way to achieve this.
Note : Reason for giving a screen instead of using Report Layout and Report Query is that the organization need several ad hoc reports in specific format which keeps on changing. Hence to avoid daily changes, we want to give the ability to specific user with appropriate rights to enter the query and xsl from APEX screen and get the report generated.
Thanks in Advance,
Shijesh