Now that I’m done with my disclaimers here’s how to customize IR downloads (don’t forget to download the code). Since grants are required from the APEX schema I can’t post a working example of this application on. If you need to use these grants in a production instance I suggest creating a special “APEX” schema and write some custom wrapper functions. It’s also important to note that some of the grant privileges could have security implications and is not recommend to be run for public applications.
Note: This code is NOT ready for a production environment!. Since the code is fairly long you’ll need to get a copy of the code here (please save the file as pkg_apex_report.zip). When users download a report it should reflect what is currently being displayed on the screen.Īfter digging through the APEX packages I was able to write some code to generate my own custom download function for IRs.
This is really important since users may add columns, change the ordering of columns, etc. Denes Kubicek has a package to download regular reports in Excel format, however it does not return the query that the user is currently viewing. A few months ago I needed to modify the downloaded Interactive Report (IR) to CSV function so that we could include group headings, report description, and report parameters (please see Column Groups in APEX Interactive Reports on how to display column groups in IR).
0 kommentar(er)
