#47 Oracle APEX download PDF reports

Hi all,

A while ago a customer asked me if it is possible to download a (classic) report as PDF file. I know that the interactive report has a option to download it as PDF, but the classic report hasn't that option. So I've searched on the internet for a JS library that has the ability to download a PDF.

I've found the open source library jsPDF and the addon Autotables. JsPDF is a very nicefull tool HTML5 client side solution for download PDF. The addon Autotables is used for generating reports in JsPDF using JSON (AJAX call).

 How to use it in APEX:
  1. Download the source code or use file URL's.
  2. Create a AJAX callback procedure that returns JSON data. (Note: Array or object type will both work)
  3. Implement some Javascript code.
    4. function download_pdf(){
 var doc      = new jsPDF('landscape', 'pt'); //Create JSPDF
 var columns  = ["EMPNO", "ENAME"];           //Report headers
 var filename = 'Download PDF';               //filename

 // Load data into report
 apex.server.process ( "DOWNLOAD_PDF", {}, {
    success: function(Data) 
        { 
           doc.autoTable(columns, Data); //Combine headers with data
           doc.save(filename);           //Create PDF
        }
    });
}
  4. Create a dynamic action that will fire the Javascript code when the user click on the download button.
Report in APEX


Report in PDF file


Demo: https://apex.oracle.com/pls/apex/f?p=94735:20

11-12-2018: I have created a APEX plugin for this. Check it on https://apex.world/ords/f?p=100:710:5668685349080::::P710_PLG_ID:S4S_PDF_DOWNLOAD

It is also possible to customize the report, like changing header colors, fontsize, etc. For more info visit the Github page.

See you next time!

Comments

Post a Comment

Popular posts from this blog

#38 Oracle apex static height region

Hi all, In this blog I'm gonna to explain how to set a static height for a region in Oracle APEX. When you give a region a static height, a scrollbar wil appear if the content in the region is longer than the static height. Steps: 1. Create a static content region. 2. Add this code snippit: "<div style="overflow: auto; height: 430px;"> " to the header of the region. 3. Add this code snippit: "</div>" to the footer of the region. This code creates a div around the region with the static height. The code in the footer will close the div. See you soon!
Read more

#43 Add color to selected tab Oracle APEX

Image
Hi all, I use the tab region in Oracle APEX very often, but one thing I change always immediately is the color of the selected tab.The default highlighted color is white. Add this CSS to highlight the selected color to the default universal theme color (blue). .t-Tabs--pill .t-Tabs-item .is-active .t-Tabs-link , .t-Tabs--pill .t-Tabs-link :active , .t-Tabs--pill .t-Tabs-link :hover { background-color : #0572CE ; color : white ; } See you next time!
Read more

#19 Clear cache in a PL/SQL process in Oracle APEX

Hi all, In this blog I will tell how you can clear the cache in APEX with a PL/SQL process. After you install APEX, you can use several packages and functions in your application. One of them is the APEX_UTIL.CLEAR_PAGE_CACHE. This function can you run in a PL/SQL proccess. Its very simple to call the package: APEX_UTIL.CLEAR_PAGE_CACHE(100). This will clear the cache of page 100. For more information, see:  https://docs.oracle.com/cd/E11882_01/appdev.112/e12510/apex_util.htm#AEAPI101 See you next week!
Read more