- 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.
- 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.
- 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.
This tutorial covers how to create PDF reports using the APEX Listener and Oracle Application Express.
Time to Complete
Approximately 30 minutes.
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:
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.
Before starting this tutorial, you should have:
- Access to an Oracle Database 11g database or above that has the sample schema installed.
- Installed Oracle Application Express Release 4.2 into your Oracle Database.
- Installed Oracle Application Express Listener 2.0 or higher.
- Access to the OEHR tables. If necessary, download and install OEHR Sample Objects available from OTN at http://www.oracle.com/technetwork/testcontent/oehr-sample-objects-131098.zip
Logging Into Oracle Application Express as an Instance Administrator and Setting up the Print Server
In this topic, you log into Oracle Application Express as an Instance Administrator and select APEX Listener as Print Server.
Creating a Classic Report in a Database Application
In this topic, you create a classic report in a database application which can then be used to print by exporting it to PDF format.
Enabling PDF Printing for the Classic Report
In this topic, you enable PDF printing for the classic report you have created in the previous topic.
In this tutorial, you have learned how to:
- Log into Application Express as an Instance Administrator and set up the Print server
- Create a Classic Report in a Database Application
- Enable PDF Printing for the Classic Report
- APEX OTN Home Page
- To learn more about Application Express 4.2, refer to additional OBEs in the Oracle Learning Library
- Oracle Application Express: Developing Web Applications
- Oracle University
- Lead Curriculum Developer: Anupama Mandya
To navigate this Oracle by Example tutorial, note the following:
- Hide Header Buttons:
- Click the title to hide the buttons in the header. To show the buttons again, click the title again.
- Topic List:
- Click a topic to navigate to that section.
- Expand All Topics:
- Click the button to show or hide the details for the sections. By default, all topics are collapsed.
- Hide All Images:
- Click the button to show or hide the screenshots. By default, all images are displayed.
- Click the button to print the content. The content that is currently displayed or hidden is printed.
To navigate to a particular section in this tutorial, select the topic from the list.