|Oracle Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher|
Release 11g (11.1.1)
Part Number E13881-02
This chapter covers the following topics:
The Formatting tab of the Report Properties dialog enables you to set runtime formatting properties at the report level. These properties are also set at the system level. If conflicting values are set for a property at each level, the report level will take precedence.
To set a property at the report level:
Open the report in the Report Editor. and then
Click Properties. This will launch the Report Properties dialog.
Click the Formatting tab to display the formatting properties.
For each property, Report Value is updateable and the Server Value is shown for reference.
For information on setting the properties at the server level, see Defining Runtime Configurations, Oracle Fusion Middleware Administrator's Guide for Oracle Business Intelligence Publisher
The following table describes the properties that are available for PDF output:
|Compress PDF output||Default: true|
Description: Specify "true" or "false" to control compression of the output PDF file.
|Hide PDF viewer's menu bars||Default: false|
Description: Specify "true" to hide the viewer application's menu bar when the document is active. The menu bar option is only effective when using the Export button, which displays the output in a standalone Acrobat Reader application outside of the browser.
Internal Name: pdf-hide-menubar
|Hide PDF viewer's tool bars||Default: false|
Description: Specify "true" to hide the viewer application's toolbar when the document is active.
|Replace smart quotes||Default: true|
Description: Set to "false" if you do not want curly quotes replaced with straight quotes in your PDF output.
Internal Name: pdf-replace-smartquotes
|Use only one shared resources object for all pages||Default: true|
Description: The default mode of BI Publisher creates one shared resources object for all pages in a PDF file. This mode has the advantage of creating an overall smaller file size. However, the disadvantages are the following:
Setting this property to "false" will create a resource object for each page. The file size will be bigger, but the PDF viewing will be faster and the PDF can be broken up into smaller files more easily.
Internal Name: pdf-use-one-resources
Use the following properties to control the security settings for your output PDF documents:
|Enable PDF Security||Default: false|
Description: If you specify "true," the output PDF file will be encrypted. You can then also specify the following properties:
Internal Name: pdf-security
|Open document password||Default: N/A|
Description: This password will be required for opening the document. It will enable users to open the document only. This property is enabled only when "Enable PDF Security" is set to "true".
Note that BI Publisher follows Adobe's password restrictions. The password must contain only Latin 1 characters and must be no more than 32 bytes long.
|Modify permissions password||Default: N/A|
Description: This password enables users to override the security setting. This property is effective only when "Enable PDF Security" is set to "true".
Note that BI Publisher follows the Adobe's password restrictions. The password must contain only Latin 1 characters and must be no more than 32 bytes long.
|Encryption level||Default: 2 - high|
Description: Specify the encryption level for the output PDF file. The possible values are:
This property is effective only when "Enable PDF Security" is set to "true". When Encryption level is set to 0, you can also set the following properties:
When Encryption level is set to 1 or higher, the following properties are available:
Internal Name: pdf-encryption-level
|Disable document modification||Default: false|
Description: Permission available when "Encryption level" is set to 0. When set to "true", the PDF file cannot be edited.
|Disable printing||Default: false|
Description: Permission available when "Encryption level" is set to 0. When set to "true", printing is disabled for the PDF file.
|Disable adding or changing comments and form fields||Default: false|
Description: Permission available when "Encryption level" is set to 0. When set to "true", the ability to add or change comments and form fields is disabled.
|Disable context copying, extraction, and accessibility||Default: false|
Description: Permission available when "Encryption level" is set to 0. When set to "true", the context copying, extraction, and accessibility features are disabled.
|Enable text access for screen readers||Default: true|
Description: Permission available when "Encryption level" is set to 1 or higher. When set to "true", text access for screen reader devices is enabled.
|Enable copying of text, images, and other content||Default: false|
Description: Permission available when "Encryption level" is set to 1 or higher. When set to "true", copying of text, images, and other content is enabled.
Internal Name: pdf-enable-copying
|Allowed change level||Default: 0|
Description: Permission available when "Encryption level" is set to 1 or higher. Valid Values are:
|Allowed printing level||Default: 0|
Description: Permission available when "Encryption level" is set to 1 or higher. Valid values are:
The following properties should only be set at the report level to enable digital signature for a report and to define the placement of the signature in the output PDF document. For more information on how to enable digital signature for your output PDF documents, see Implementing a Digital Signature, Oracle Fusion Middleware Administrator's Guide for Oracle Business Intelligence Publisher.
Note that to implement digital signature for a report based on a PDF layout template or an RTF layout template, you must set the property Enable Digital Signature to "True" for the report.
You also must set the appropriate properties to place the digital signature in the desired location on your output report. Your choices for placement of the digital signature depend on the template type. The choices are as follows:
(PDF only) Place the digital signature in a specific field by setting the Existing signature field name property.
(RTF and PDF) Place the digital signature in a general location of the page (top left, top center, or top right) by setting the Signature field location property.
(RTF and PDF) Place the digital signature in a specific location designated by x and y coordinates by setting the Signature field x coordinate and Signature field y coordinate properties.
If you choose this option, you can also set Signature field width and Signature field height to define the size of the field in your document.
Note that if you enable digital signature, but do not set any location properties, the digital signature placement will default to the top left of the document.
|Enable Digital Signature||Default: false|
Description: Set this to "true" to enable digital signature for the report.
Internal Name: signature-enable
|Existing signature field name||Default: N/A|
Description: This property applies to PDF layout templates only. If your report is based on a PDF template, you can enter a field from the PDF template in which to place the digital signature. For more information on defining a field for the signature in a PDF template, see Adding or Designating a Field for a Digital Signature.
Internal Name: signature-field-name
|Signature field location||Default: top-left|
Description: This property can apply to RTF or PDF layout templates. This property provides a list containing the following values: Top Left, Top Center, Top Right. Choose one of these general locations and BI Publisher will insert the digital signature to the output document, sized and positioned appropriately. If you choose to set this property, do not enter X and Y coordinates or width and height properties.
Internal Name: signature-field-location
|Signature field X coordinate||Default: 0|
Description: This property can apply to RTF or PDF layout templates. Using the left edge of the document as the zero point of the X axis, enter the position in points that you want the digital signature to be placed from the left. For example, if you want the digital signature to be placed horizontally in the middle of an 8.5 inch by 11 inch document (that is, 612 points in width and 792 points in height), enter 306.
Internal Name: signature-field-pos-x
|Signature field Y coordinate||Default: 0|
Description: This property can apply to RTF or PDF layout templates. Using the bottom edge of the document as the zero point of the Y axis, enter the position in points that you want the digital signature to be placed from the bottom. For example, if you want the digital signature to be placed vertically in the middle of an 8.5 inch by 11 inch document (that is, 612 points in width and 792 points in height), enter 396.
Internal Name: signature-field-pos-y
|Signature field width||Default: 0|
Description: Enter in points (72 points equal one inch) the desired width of the inserted digital signature field. This applies only if you are also setting the properties Signature field x coordinate and Signature field Y coordinate.
Internal Name: signature-field-width
|Signature field height||Default: 0|
Description: Enter in points (72 points equal one inch) the desired height of the inserted digital signature field. This applies only if you are also setting the properties Signature field x coordinate and Signature field Y coordinate.
Internal Name: signature-field-height
The following properties can be set to govern RTF output files:
|Enable change tracking||Default: false|
Description: Set to "true" to enable change tracking in the output RTF document.
Internal Name: rtf-track-changes
|Protect document for tracked changes||Default: false|
Description: Set to "true" to protect the document for tracked changes.
|Default font||Default: Arial:12|
Description: Use this property to define the font style and size in RTF output when no other font has been defined. This is particularly useful to control the sizing of empty table cells in generated reports.
Enter the font name and size in the following format <FontName>:<size>
for example: Arial:12.
Note that the font you choose must be available to the BI Publisher processing engine at runtime. See Defining Font Mappings for information on installing fonts for the BI Publisher server and also for the list of fonts predefined for BI Publisher.
Internal Name: rtf-output-default-font
The following properties can be set to govern HTML output files:
|Show header||Default: true|
Description: Set to "false" to suppress the template header in HTML output.
Internal Name: html-show-header
|Show footer||Default: true|
Description: Set to "false" to suppress the template footer in HTML output.
Internal Name: html-show-footer
|Replace smart quotes||Default: true |
Description: Set to "false" if you do not want curly quotes replaced with straight quotes in your HTML output.
Internal Name: html-replace-smartquotes
|Character set||Default: UTF-8|
Description: Specifies the output HTML character set.
Internal Name: html-output-charset
|Make HTML output accessible||Default: false|
Description: Specify true if you want to make the HTML output accessible.
Internal Name: make-accessible
|Use percentage width for table columns||Default: true|
Description: Set this property to true to render table columns according to a percentage value of the total width of the table rather than as a value in points.
This property is especially useful if your browser renders tables with extremely wide columns. Setting this property to true will improve readability of the tables.
Internal Name: html-output-width-in-percentage
The following properties can be set to govern FO processing:
|Use BI Publisher's XSLT processor||Default: true|
Description: Controls BI Publisher's parser usage. If set to false, XSLT will not be parsed.
Internal Name: xslt-xdoparser
|Enable scalable feature of XSLT processor||Default: false|
Description: Controls the scalable feature of the XDO parser. The property "Use BI Publisher's XSLT processor" must be set to "true" for this property to be effective.
Internal Name: xslt-scalable
|Enable XSLT runtime optimization||Default: true|
Description: When set to "true", the overall performance of the FO processor is increased and the size of the temporary FO files generated in the temp directory is significantly decreased. Note that for small reports (for example 1-2 pages) the increase in performance is not as marked.
To further enhance performance when you set this property to true, it is recommended that you set the property Extract attribute sets to "false". See RTF Template Properties.
Internal Name: xslt-runtime-optimization
|Enable XPath Optimization||Default: false|
Description: When set to "true", the XML data file will be analyzed for element frequency. The information is then used to optimize XPath in XSL.
Internal Name: xslt-xpath-optimization
|Pages cached during processing||Default: 50|
Description: This property is enabled only when you have specified a Temporary Directory (under General properties). During table of contents generation, the FO Processor caches the pages until the number of pages exceeds the value specified for this property. It then writes the pages to a file in the Temporary Directory.
Internal Name: system-cache-page-size
|Bidi language digit substitution type||Default: None|
Description: Valid values are "None" and "National". When set to "None", Eastern European numbers will be used. When set to "National", Hindi format (Arabic-Indic digits) will be used. This setting is effective only when the locale is Arabic, otherwise it is ignored.
Internal Name: digit-substitution
|Disable variable header support||Default: false|
Description: If "true", prevents variable header support. Variable header support automatically extends the size of the header to accommodate the contents.
Internal Name: fo-prevent-variable-header
|Add prefix to IDs when merging FO||Default: false|
Description: When merging multiple XSL-FO inputs, the FO Processor automatically adds random prefixes to resolve conflicting IDs. Setting this property to "true" disables this feature.
Internal Name: fo-merge-conflict-resolution
|Enable multithreading||Default: false|
Description: If you have a multiprocessor machine or a machine with a dual-core single processor, you may be able to achieve faster document generation by setting this option to True.
Internal Name: fo-multi-threads
|Disable external references||Default: true|
Description: A "true" setting (default) disallows the importing of secondary files such as subtemplates or other XML documents during XSL processing and XML parsing. This increases the security of your system. Set this to "false" if your report or template calls external files.
Internal Name: xdk-secure-io-mode
|FO Parsing Buffer Size||Default: 1000000|
Description: Sets the size of the buffer for the FO Processor. When the buffer is full, the elements from the buffer will be rendered in the report. Reports with large tables or pivot tables that require complex formatting and calculations may require a larger buffer to properly render those objects in the report. Increase the size of the buffer at the report level for these reports. Note that increasing this value will affect the memory consumption of your system.
Internal Name: fo-chunk-size
|Enable XSLT runtime optimization for sub-template||Default: true
Note: The default is true on the BI Publisher server. If you call the FOProcessor directly, the default is false.
Description: Provides an option to perform XSL import in FOProcessor before passing only one XSL to XDK for further processing. This allows xslt-optimization to be applied to the entire main XSL template which already includes all its subtemplates.
Internal Name: xslt-do-import
|Enable PPTX native chart support||Default: true|
Description: This property applies to PowerPoint 2007 output. When set to true, charts in PowerPoint 2007 output will be rendered as native PowerPoint (PPTX) charts. If this property is set to false, the chart will be rendered as an embedded PNG image.
Internal Name: pptx-native-chart
The following properties can be set to govern RTF templates:
|Extract attribute sets||Default: Auto|
Description: The RTF processor will automatically extract attribute sets within the generated XSL-FO. The extracted sets are placed in an extra FO block, which can be referenced. This improves processing performance and reduces file size.
Valid values are:
|Enable XPath rewriting||Default: true|
Description: When converting an RTF template to XSL-FO, the RTF processor will automatically rewrite the XML tag names to represent the full XPath notations. Set this property to "false" to disable this feature.
Internal Name: rtf-rewrite-path
|Characters used for checkbox||Default: Albany WT J;9746;9747/A|
Description: The BI Publisher default PDF output font does not include a glyph to represent a checkbox. If your template contains a checkbox, use this property to define a Unicode font for the representation of checkboxes in your PDF output. You must define the Unicode font number for the "checked" state and the Unicode font number for the "unchecked" state using the following syntax: fontname;<unicode font number for true value's glyph >;<unicode font number for false value's glyph>
Example: Albany WT J;9746;9747/A
Note that the font that you specify must be made available to BI Publisher at runtime.
Internal Name: rtf-checkbox-glyph
The following properties can be set to govern PDF templates:
|Remove PDF fields from output||Default: false|
Description: Specify "true" to remove PDF fields from the output. When PDF fields are removed, data entered in the fields cannot be extracted. For more information, see Setting Fields as Updateable or Read Only.
Internal Name: remove-pdf-fields
|Set all fields as read only in output||Default: true|
Description: By default, BI Publisher sets all fields in the output PDF of a PDF template to be read only. If you want to set all fields to be updateable, set this property to "false". For more information, see Setting Fields as Updateable or Read Only.
Internal Name: all-field-readonly
|Maintain each field's read only setting||Default: false|
Description: Set this property to "true" if you want to maintain the "Read Only" setting of each field as defined in the PDF template. This property overrides the settings of "Set all fields as read only in output." For more information, see Setting Fields as Updateable or Read Only.
Internal Name: all-fields-readonly-asis
The following properties can be set to govern Flash templates:
|Page width of wrapper document||Default: 792|
Description: Specify in points the width of the output PDF document. The default is 792, or 11 inches.
|Page height of wrapper document||Default: 612|
Description: Specify in points the height of the output PDF document. The default is 612, or 8.5 inches
Internal Name: flash-page-height
|Start x position of Flash area in PDF||Default: 18|
Description: Using the left edge of the document as the 0 axis point, specify in points the beginning horizontal position of the Flash object in the PDF document. The default is 18, or .25 inch
Internal Name: flash-startx
|Start y position of Flash area in PDF||Default: 18|
Description: Using the upper left corner of the document as the 0 axis point, specify in points the beginning vertical position of the Flash object in the PDF document. The default is 18, or .25 inch.
Internal Name: flash-starty
|Width of Flash area||Default: Same as flash width in points in swf|
Description: Enter in points the width of the area in the document for the Flash object to occupy. The default is the width of the SWF object.
Internal Name: flash-width
|Height of Flash area||Default: Same as flash height in points in swf|
Description: Enter in points the height of the area in the document for the Flash object to occupy. The default is the height of the SWF object.
Internal Name: flash-height
Use the following properties to control comma-separated value output:
|CSV delimiter||Default: ,|
Description: Specifies the character used to delimit the data in comma-separated value output. Other options are: Semicolon (;), Tab (\t) and Pipe (|).
|Remove leading and trailing white space||Default: false|
Description: Specify "True" to remove leading and trailing white space between data elements and the delimiter.
Use the following properties to control Excel 2007 output:
|Show grid lines||Default: false|
Description: Set to true to show the Excel table grid lines in the report output.
|Page break as a new sheet||Default: true|
Description: When set to "True" a page break specified in the report template will generate a new sheet in the Excel workbook.
|Minimum column width||Default: 3 (in points, 0.04 inch)|
Description: When the column width is less than the specified minimum and it contains no data, the column will be merged with the preceding column.
|Minimum row height||Default: 1 (in points, 0.01 inch)|
Description: When the row height is less than the specified minimum and it contains no data, the row will be removed.
|Hide version number in output||Default: true|
Description: Some report output documents display Oracle BI Publisher in the document properties. For example, PDF documents identify Oracle BI Publisher as the PDF Producer in the properties for the document. If you wish to include the version of BI Publisher (for example, Oracle BI Publisher 18.104.22.168.0) that generated the document, set this property to false.
BI Publisher's Font Mapping feature enables you to map base fonts in RTF or PDF templates to target fonts to be used in the published document. Font Mappings can be specified at the site or report level. Font mapping is performed only for PDF PowerPoint output.
There are two types of font mappings:
RTF Templates - for mapping fonts from RTF templates and XSL-FO templates to PDF and PowerPoint output fonts
PDF Templates - for mapping fonts from PDF templates to different PDF output fonts.
BI Publisher provides a set of Type1 fonts and a set of TrueType fonts. You can select any of the fonts in these sets as a target font with no additional setup required. For a list of the predefined fonts see BI Publisher's Predefined Fonts.
The predefined fonts are located in the Oracle Business Intelligence Oracle home, in: ORACLE_HOME/common/fonts. If you wish to map to another font, you must place the font in this directory to make it available to BI Publisher at runtime. If your environment is clustered, you must place the font on every server.
Note: The font location is set by the XDO_FONT_DIR variable. If this variable is not set in your environment the fonts will be located in $JAVA_HOME/jre/lib/fonts.
A font mapping can be defined at the site level or the report level:
To set a mapping at the site level, select the Font Mappings link from the Admin page.
To set a mapping at the report level, select the Configuration link for the report, then select the Font Mappings tab. These settings will apply to the selected report only.
The report-level settings will take precedence over the site-level settings.
From the Admin page, under Runtime Configuration, select Font Mappings.
To create a Font Mapping
Under RTF Templates or PDF Templates, select Add Font Mapping.
Enter the following on the Add Font Mapping page:
Base Font - enter the font family that will be mapped to a new font. Example: Arial
Select the Style: Normal or Italic (Not applicable to PDF Template font mappings)
Select the Weight: Normal or Bold (Not applicable to PDF Template font mappings)
Select the Target Font Type: Type 1 or TrueType
Enter the Target Font
If you selected TrueType, you can enter a specific numbered font in the collection. Enter the TrueType Collection (TTC) Number of the desired font.
For a list of the predefined fonts see BI Publisher's Predefined Fonts
The following Type1 fonts are built-in to Adobe Acrobat and BI Publisher provides a mapping for these fonts by default. You can select any of these fonts as a target font with no additional setup required.
The Type1 fonts are listed in the following table:
|Number||Font Family||Style||Weight||Font Name|
The TrueType fonts are listed in the following table. All TrueType fonts will be subsetted and embedded into PDF.
|Number||Font Family Name||Style||Weight||Actual Font||Actual Font Type|
|1||Albany WT||normal||normal||ALBANYWT.ttf||TrueType (Latin1 only)|
|2||Albany WT J||normal||normal||ALBANWTJ.ttf||TrueType (Japanese flavor)|
|3||Albany WT K||normal||normal||ALBANWTK.ttf||TrueType (Korean flavor)|
|4||Albany WT SC||normal||normal||ALBANWTS.ttf||TrueType (Simplified Chinese flavor)|
|5||Albany WT TC||normal||normal||ALBANWTT.ttf||TrueType (Traditional Chinese flavor)|
|6||Andale Duospace WT||normal||normal||ADUO.ttf||TrueType (Latin1 only, Fixed width)|
|6||Andale Duospace WT||bold||bold||ADUOB.ttf||TrueType (Latin1 only, Fixed width)|
|7||Andale Duospace WT J||normal||normal||ADUOJ.ttf||TrueType (Japanese flavor, Fixed width)|
|7||Andale Duospace WT J||bold||bold||ADUOJB.ttf||TrueType (Japanese flavor, Fixed width)|
|8||Andale Duospace WT K||normal||normal||ADUOK.ttf||TrueType (Korean flavor, Fixed width)|
|8||Andale Duospace WT K||bold||bold||ADUOKB.ttf||TrueType (Korean flavor, Fixed width)|
|9||Andale Duospace WT SC||normal||normal||ADUOSC.ttf||TrueType (Simplified Chinese flavor, Fixed width)|
|9||Andale Duospace WT SC||bold||bold||ADUOSCB.ttf||TrueType (Simplified Chinese flavor, Fixed width)|
|10||Andale Duospace WT TC||normal||normal||ADUOTC.ttf||TrueType (Traditional Chinese flavor, Fixed width)|
|10||Andale Duospace WT TC||bold||bold||ADUOTCB.ttf||TrueType (Traditional Chinese flavor, Fixed width)|
BI Publisher also includes the following barcode fonts:
|Font File||Supported Algorithm|
|128R00.TTF||code128a, code128b, and code128c|
For information on using barcode fonts in an RTF template, see Using the Barcodes Shipped with BI Publisher.
Copyright © 2010, 2011, Oracle and/or its affiliates. All rights reserved.