Configuring Report Printing

Oracle Application Express provides several features so that end users can download and print reports in various formats, including PDF. To set up this functionality, different users need to configure the printing settings:

Site Level: Oracle Application Express service administrators must specify the level of functionality (Standard or Advanced) for an entire Oracle Application Express instance, as described in this section.
Application Level: Workspace administrators and developers can define Report Queries and Report Layouts. Report Queries and Report Layouts are stored under Shared Components and are not tied to a specific page. See "Configuring Printing for Reports".
Page/Region Level: Developers can edit the Report regions on specific pages to enable printing. This, in turn, enables end users to print regions as reports in various formats. See "Configuring Print Attributes for Report Regions".

Setting Up the Printing of Reports

To configure the printing of reports at your site:

Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".
Click Manage Service.
Under Manage Environment Settings, click Instance Settings.
Scroll down to Report Printing:
For Oracle BI Publisher, select one of the following:
- Standard Support - This is the default setting. It allows you to print report regions and report queries using either the built-in templates provided with Application Express or other formats you create that are in XSL-FO format (not RTF).
- Advanced Support - If you select this option, for Report Layouts, you can upload your own customized RTF templates for printing reports within Application Express.
  
  This option requires the installation of the fully licensed version of Oracle BI Publisher (also known as Oracle XML Publisher).
For Print Server Protocol, select the protocol that the print server uses.
For Print Server Host Address, specify the host address of the print server engine.
For Print Server Port, define the port of the print server engine. By default, this is set to 8888 when the report server is installed.
For Print Server Script, define the script that is the print server engine. The default setting is:
```
/xmlpserver/convert
```
Click Apply Changes.