18.1 About printing in Discoverer Plus Relational

Discoverer enables you to print worksheet data and graphs. For example, you might want to mail a printed copy of a Discoverer worksheet to a colleague. Or, if you have Adobe Acrobat installed, you might want to create an Adobe Acrobat Portable Document Format (PDF) file that you can send to colleagues using e-mail.

When you print a worksheet that contains page items, you can either print the current page item values (that is, exactly what you see on the screen), or all page item values. For example, if you display Month in the page item area and you are currently displaying January data, you can print the January data or data for all months.

If you print worksheets that contain active parameters, Discoverer prompts you to enter parameter values to refine the data that you print.

When you print a worksheet with a graph in Discoverer Plus Relational, the worksheet and graph print on separate pages. To print a worksheet with a graph on the same printed page, you can do one of the following:

Print the worksheet and graph in Discoverer Viewer

Use Discoverer Portlet Provider to display multiple worksheets and graphs as portlets on a single portal page, and print the portal page (for more information, see Oracle Fusion Middleware Guide to Publishing Oracle Business Intelligence Discoverer Portlets)

Export the worksheet and graph to an external application (for example, HTML) and print the page

18.2 About elements of a printed worksheet in Discoverer Plus Relational

18.3 What are Page Setup options

Page Setup options are worksheet settings that affect how a worksheet prints out. For example:

The Orientation setting (that is, Portrait or Landscape) determines the position of the worksheet relative to the printed page. The example below shows the same worksheet printed with a portrait orientation and a landscape orientation.

Key to figure:
a Discoverer worksheet with a portrait orientation
b Discoverer worksheet with a landscape orientation

The Header settings enable you to add a header to the top of a printed worksheet. The example below shows a worksheet containing a header that is on the printed page but is not displayed on-screen in Discoverer Plus Relational. In this example, the header contains the name of the worksheet author, the worksheet title, the date and time, and a separating line.

Figure 18-3 Discoverer worksheet with a header

Key to figure:
a. The worksheet header that is displayed on the printed page

Note: The Graph tab is displayed when a worksheet has a graph currently displayed or the Graph check box is selected on the "Print dialog".

To display the Page Setup dialog, choose Page Setup from either the File menu, Print dialog, or Print Preview dialog. When you save a workbook, you save the Page Setup options that you have specified for each worksheet in that workbook.

Once you have selected Page Setup options, you click Print do display the operating system print dialog, which enables you set additional print settings. The example below shows the Windows print dialog.

Figure 18-5 Operating system print dialog

For example, for a multi-page worksheet, you might want to print the first page only to check the layout.

18.4 About Page Setup options for graphs

Page Setup options for graphs enable you to print a Discoverer graph in exactly the size you want. You set Page Setup options for a graph using the "Page Setup dialog: Graph tab".

Figure 18-6 Page Setup options dialog: Graph tab

For example, you might have a large graph displayed on screen (see screenshot below).

Figure 18-7 Discoverer worksheet containing a large graph

If you select the Actual size check box on the "Page Setup dialog: Graph tab" and print the graph, Discoverer crops the graph. In the screenshot below you can see that Discoverer crops the graph legend from the right hand side.

Figure 18-8 Discoverer printed worksheet with a cropped graph

If you select the Fit to page check box on the "Page Setup dialog: Graph tab" and print the graph, Discoverer prints the whole graph (see screenshot below).

If you select the Fit to page check box with Preserve the Ratio of Height and Width selected on the "Page Setup dialog: Graph tab" and print the graph, Discoverer maintains the graph proportions (see screenshot below).

Figure 18-10 Discoverer graph with maintained proportions

If you select the Fit to page check box with Preserve the Ratio of Height and Width selected and Preserve the Actual Font Size selected on the "Page Setup dialog: Graph tab" and print the graph, Discoverer maintains the graph proportions and original font size (see screenshot below).

Discoverer applies the Page Setup options for the current session. To save the Page Setup options permanently for the selected worksheet, you must save the workbook (for more information, see "How to save workbooks").

18.6 How to print Discoverer workbooks

You print a Discoverer workbook when you want to print all worksheets in a workbook. When you print a workbook, you print all worksheet data and graphs based on Page Setup options selected for the individual worksheets (for more information, see "What are Page Setup options").

Discoverer then displays the operating system print dialog. For example, if you are using Windows, Discoverer displays the Windows Print dialog.

Use the operating system print dialog to set additional print options if required, and start the print job.

Discoverer prints the workbook on the printer selected.

18.7 How to print Discoverer worksheets

You print a Discoverer worksheet to print the currently displayed worksheet. You can print the worksheet data or graph, and select the page items you want to print. If the worksheet contains active parameters, Discoverer prompts you to enter parameter values to refine the data that you print.

Discoverer displays the operating system print dialog. For example, if you are using Windows, Discoverer displays the Windows Print dialog.

Use the operating system print dialog to set additional print options if required, and start the print job.

Discoverer prints the worksheet on the printer selected.

When you print a worksheet with a graph in Discoverer Plus Relational, the worksheet and graph print on separate pages. To print a worksheet with a graph on the same printed page, you can do one of the following:

Print the worksheet in Discoverer Viewer

Use Discoverer Portlet Provider to display multiple worksheets and graphs as portlets on a single portal page, and print the portal page (for more information, see Oracle Fusion Middleware Guide to Publishing Oracle Business Intelligence Discoverer Portlets)

Export the worksheet and graph to an external application (for example, HTML) and print the page

18.8 How to print Discoverer workbooks and worksheets to PDF files

Discoverer enables you to print Discoverer workbooks and worksheets to a Portable Document Format (PDF) file. For example, you might want to send an e-mail containing a worksheet to a colleague who uses PDF files to share information.

For example, when you click OK on the Discoverer Print dialog, if you are using Windows, Discoverer displays the Windows Print dialog.

In the operating system print dialog, select a PDF format (for example, Adobe Acrobat, Acrobat Distiller) from the printer list.

Follow the on-screen instructions to create the PDF file.

You can now open the Discoverer workbook or worksheet in an Adobe Acrobat reader.

Notes

You can also create a PDF file by exporting the workbook or worksheet to Portable Document Format (for more information, see "How to export Discoverer data").

You might also print to a postscript file from the operating system print dialog.

The formatting of worksheets in PDF format is the same as in printed worksheets. For example, if a worksheet is printed on three sides of A4 paper, the worksheet in PDF format consists of three pages of A4-sized content.

Scripting on this page enhances content navigation, but does not change the content in any way.