OLL Mobile

You can configure a classic report region to print by exporting it to several different formats such as Adobe Portable Document Format (PDF), Microsoft Word Rich Text Format (RTF), or Microsoft Excel Format (XLS), or Extensible Markup Language (XML). Oracle Application Express provides three report printing configuration options. They are:

1. Oracle Application Express Listener: Select this option if you are using the Oracle Application Express Listener 2.0 or higher. This option enables you to use the basic printing functionality, which includes creating report queries and printing report regions using the default templates provided in Application Express and using your own customized XSL-FO templates.
   Note: The Oracle Application Express Listener option does not require an external print server, instead the report data and stylesheet are downloaded to the listener, rendered into PDF format by the listener and then sent to the client. The PDF documents in this setup are not returned back to the database, thus the print APIs are not supported when using the Oracle Application Express Listener - based configuration.
2. External (Apache FOP): Select this option if you are using Apache FOP on an external J2EE server. This option enables you to use the basic printing functionality, which i8ncludes creating report queries and printing report regions using the default templates provided in Application Express and using your own customized XSL-FO templates.
3. Oracle BI Publisher: This option requires a valid license of Oracle BI Publisher. This option enables you to take report query results and convert them from XML to RTF format using Oracle BI Publisher. Select this option to upload your own customized RTF or XSL-FO templates for printing reports with Oracle Application Express.

In this tutorial, you use the APEX Listener for PDF printing of a classic report. APEX Listener for PDF printing has the FOP libraries actually built into the listener thereby making the configuration setup easy. You log into the APEX Instance Administration, select Application Express as the Print Server, and then enable PDF printing for Classic Reports, Interactive Reports, or Report Queries.

Release Date: 12-Sep-13

Duration: 30 minutes

Credited To: -

No Flash Plugin Needed

efren.ramirez

21-Nov-13

Great workshop. Thanks.