Super Easy Report Printing in Oracle APEX 20.2!

In the Oracle APEX 20.2 release, there have been substantial improvements made in support of printing and native data export. This includes Built-in PDF printing and Excel download, APIs to programmatically generate PDF, CSV, Excel, HTML, JSON and XML files, more language support, and even enhanced integration with BI Publisher and the printing capabilities of Oracle Analytics Cloud. In this session, the product developer and architect of these features, Menno Hoogendijk, will present and demonstrate all of these rich capabilities.

[@ERPstuff]

Hi, APEX community is waiting to get an option to print PDF reports like PO, Invoice documents etc not just tabular reports.

[@it-ze5768]

Use jasper for that reports

[@ERPstuff]

@@it-ze5768 Builtin is always preferred all others are workarounds. thanks

[@chaudhryzarrar7465]

Do you know any possible way outs with cloud based application to print documents like Invoice/PO?

[@ERPstuff]

Hi now please share further details what kind of cloud service you have SaaS, PaaS then free or paid? @@chaudhryzarrar7465

[@jkl8577]

Great session Menoo. Thanks for putting this together.

[@karthikg8266]

in a page within a single region I have 2 classic reports. Can I get the outputs of both the reports in a single PDF or single HTML page. I need this to be saved in File system finally.

[@ka8209]

want to develop app with Apex and autonomous database . The column that will contain invoice number should have hyperlink that will redirect user to the location where the soft copy of invoice is stored (bucket). kindly help on how to figure it out

[@junaidbabarkhan1221]

Can we have a Form-Like report through Native Printing or only tabular reports can be printed. Apex Office Print is bit expensive...

[@alexandrarenee5357]

Hi, how can I show two reports on the same sheet in restful service?, thanks

[@elibenhemoa.o.tmanpowersup2875]

Hi I'm looking for the jsPdf plugin , Can someone post the url here, thanks

[@podunkman2709]

This option is available only with some 'remote printing service' (probably paid)? Or is it also included within new Apex?

[@mohamedsameer3549]

Thanks very useful content.

[@ifeolu8501]

Hi, Would like to know if Oracle Apex 21.2 can now allow us to add logo to our PDF report or maybe create a html header and footer we can use in our PDF report. Thanks

[@OracleAPEX]

Hello, thanks for your message! Please, follow all the news of APEX at this link: apex.oracle.com/en/learn/documentation/. If you have further questions, we invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum

[@sebastiannmoreno885]

Hello Menoo. Great video. How can I install the pluggin in oracle apex and where can I get it? Thank you.

[@dynalogics5804]

Can I print a master detail report via native data export? Two regions combined in one single PDF?

[@nickyslinger2171]

How can you include the search parameters on the export report?

[@OracleAPEX]

Hi! Thanks for your message! We would like to invite you to explore the APEX Community Technical Discussion Forum: apex.oracle.com/forum. You can search for information about APEX and also post your questions.

[@yakaka1]

how to remove headings from report

[@OracleAPEX]

Thanks for reaching out to us! Classic Report has an attribute to set the column headers to none. If Classic Report is not a solution, please, feel free to add an idea to our ideas app with your use case, by clicking here: apex.oracle.com/en/community/ideas/. Cheers!

[@parthparth8680]

HOW TO MORE THAN 1 HEADER LINE OR MORE THAN 1 FOOTER LINE WHEN GENERATING PDF/CSV FILE AND AUTOMATIC POPUP PDF/CSV FILE IN NEW BROWSE WINDOW CLASSIC REPORT / INTERACTIVE REPORT CAN GENERATE BEGINNER ONLY NOT PROFESSIONAL ONE

[@meucanalyoutube]

Hello Menoo. Great video. Thank you for sharing your knowledge. Where can I download the jsPDF plugin to use in Apex?

[@jkl8577]

I have found it with this link: parall.ax/products/jspdf, hope this helps.

[@meucanalyoutube]

@@jkl8577 Thanks!

[@samikzr]

@@jkl8577 how do you import it to Apex appliation? there's no sql file

[@jkl8577]

@@samikzr You download the library and you upload the JS library file as static file and then you can reference it inside APEX. This is not a APEX package. It is just a JS package. It's been a while since I touch this. So hope that his will work.

[@habrom1000]

@46:20 post request send email as PDF and with attachment

[@ajtonyvarga8916]

If it’s super easy, why does it take an hour to explain?