Printable Page Options page: Page Setup tab

Previous

Next

---

Use this page to choose the sizing options to use for generating a Portable Document Format (PDF) version of the current worksheet.

You can also use this page to preview a preview PDF version (i.e. the first 50 rows of data) or generate a printable PDF version of the entire worksheet. Having generated a PDF version, Discoverer displays either the "PDF Ready page" or the "PDF Sample Ready page" from where you can view, save or print the PDF file.

For more information, see:

• "How to preview worksheets before printing"

• "How to print worksheets"

Paper Setup

Use these settings to specify the paper size and page orientation for the PDF version that you use for printing.

• Size

  Use this drop down list to choose the paper size from a list of available paper sizes.

  The paper size that you specify here is represented in the preview or printable PDF version of the worksheet that is generated. When you subsequently print the PDF version of the worksheet it will appear the same as when viewed in the PDF version.

  Note: The list of available paper sizes displayed here is configured by the Discoverer manager.

Orientation

Use these radio buttons to specify the orientation for the PDF version that you use for printing.

• Portrait

  Use this radio button to specify the portrait orientation for printing.

• Landscape

  Use this radio button to specify the landscape orientation for printing.

Margins

Use these fields to specify the size of the page margins for the PDF version that you use for printing. Page margins define the width of the border that surrounds the area where data is printed in a worksheet page. When page margins become narrower, the area where data is printed becomes greater, enabling more data to fit into on each page

• Top

  Use this field to specify the size of the top margin.

• Bottom

  Use this field to specify the size of the bottom margin.

• Left

  Use this field to specify the size of the left margin.

• Right

  Use this field to specify the size of the right margin.

Note: The default unit of measure (e.g. centimeters, inches) used to print worksheets, is configured by the Discoverer manager.

Scaling

Use this drop down list to choose the percentage amount to change the size of the worksheet relative to its original size, for the PDF version that you use for printing. For example to fit a large worksheet onto a single page you might make it smaller by using this control.

After you have specified graph and column sizes (i.e. in the "Printable Page Options page: Page Content tab" and on this page), scaling can take effect. For example, if the original graph size is specified as 4 cm by 6 cm and you want the graph size to become 2 cm by 3 cm you can choose the 50% from the list to reduce the relative size of the graph to 50% of its original size.

Column Sizes

Use these settings to change the width of the columns in your worksheet and specify whether to wrap the text when it exceeds the specified width, for the PDF version that you use for printing.

• Column size (e.g. Pixels)

  Use each field to enter a number to change the width of the corresponding column.

  Discoverer displays default values for column sizes as follows:

  If a column size was specified in Discoverer Plus, that size is displayed here.

  If no column size was specified in Discoverer Plus, the default size is calculated based on the first few hundred rows of data.

• Wrap text when size exceeds column width

  Select this check box to wrap text when it becomes wider than the width of a column. The default value for this check box is to be selected.

  Clear this check box to not wrap text when it becomes wider than the width of a column.

  Note: When you clear this check box and text is wider than the width of a column, Discoverer truncates the text.

Preview

Use this button to generate a preview PDF file (based on the first 50 rows of data in the worksheet). You can display the preview PDF file to confirm that the settings you specify in this page produce the output you expect. Having created the preview PDF file, Discoverer displays the "PDF Sample Ready page" from where you can view, save or print the preview PDF file.

Printable PDF

Use this button to generate the PDF file. Having created the PDF file, Discoverer displays the "PDF Ready page" from where you can view, save or print the PDF file.

Note: Under certain rare circumstances, printing a worksheet might require additional memory when there are many columns, even if there is a small number of rows. To work around this issue, either rotate the column axis with the row axis and try to print again, or increase the memory for the OC4J_BI_Forms JVM process, as described in Oracle Business Intelligence Discoverer Configuration Guide. For more information about changing the worksheet layout, see "How to change the layout of a worksheet".