PL-jrxml2pdf is a PL/SQL-program which takes a report-definition in jrxml-format and generated a PDF-result from it. It's pure PL/SQL, so there's no need for any middleware.
Design your reports graphically, e.g. by using iReports from JasperSoft, then use PL-jrxml2pdf as runtime-engine to generate PDF from PL/SQL.
The software comes with an Oracle APEX-application whichs installs all required objects and samples.
Also the APEX-application allows you
- to manage all PL-jrxml2pdf-objects
- to run reports
- to view logs written when running a report
The JRXML-generator allows you to generate report-definitions out of APEX-pages to fasten the process of creating reports.
See the Wiki for detailed version-info.
Great plug in for apex pdf printing... I have been searching for this kind of feature for a long time.. We had been using Jasper server with apex.. but this helps in: 1- no need for Jasper server installation (along with the authentication problems when the link is sent from apex) 2- great tool to generate a PDF report from an application page.. in less than a minute 3- ... well... I love it altogether.. it has an issue with arabic fonts though but I'm looking for a solution.. HIGHLY RECOMMENDED
Thanks for this great plugins. So far it works quite nice for us.
PL-jrxml2pdf is an incredble solution! I was looking for a replacement for our very expensive BI Publisher reporting solution. The only feature of the product we used was the ability to create well formatted PDF reports from Oracle APEX applications. For this we needed a costly BI Publisher server and the related maintenance costs. All the web links pointed me to the JasperReports solution. This was a much more inviting solutions as it was open source and did not entail expensive licenses. It still required the setup of a JasperReports server to receive the print requests and package the PDF reports. JasperReports uses jrxml code for the report templates and provides a free full-featured free tool (iReport) to build these report templates. Before we were finished implementing the JasperReports server I came across this all-oracle solution. Mr. Weiden has built a suite of packages that, like the JasperReports server, read in the jrxml code for a report and some parameters to produces a PDF report. I tried this solution for one of my more complicated report to see if the package could handle it. It did not at first but a quick email to Mr. Weiden and he had a new version available within a day which handled my issues. As the documentation clearly states, the package is not yet a replacement for all the features of iReport: for example, iReport variables are not yet supported. I found however that all the important feautures are covered. We have since abandoned our efforts regarding the implementation of a JasperReports server in favor of this elegant all-Oracle solution. Many thanks to Andreas Wieden for providing this great package!
Very nice package. It makes it so much simpler to integrate Jasper Reports in any APEX project. I did some tests with version 0.9 and it works perfectly.
This is very useful tool for Apex and its future. Pending for long time, at least now it is getting addressed. Thanks to aweiden.