Browser version scriptSkip Headers

Oracle Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher
Release 11g (11.1.1)
Part Number E13881-02
Go to next page

Oracle Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher


Title and Copyright Information

Send Us Your Comments




Overview of the Oracle Business Intelligence Publisher Report Designer's Guide
New Features for Oracle Business Intelligence Publisher 11g Release 1 (11.1.1)

Creating Reports and Layouts

Creating or Editing a Report

About Report Components
Process Overview
Launching the Report Editor
Selecting the Data Model
About the Report Editor Interface
Adding Layouts to the Report Definition
Configuring Layouts
Configuring Parameter Settings for the Report
Configuring Report Properties

Creating BI Publisher Layout Templates

Launching the Layout Editor
About the Layout Editor Interface
The Page Layout Tab
Inserting Layout Components
About Layout Grids
About Repeating Sections
About Data Tables
About Charts
About Gauge Charts
About Pivot Tables
About Text Items
About Images
About Lists
Setting Predefined or Custom Formulas
Saving a Layout

Creating RTF Templates

What Is an RTF Template?
About XSLT Compatibility
Getting Started
      About Adding BI Publisher Code
Key Concepts
      Associating the XML Data to the Template Layout
Designing the Template Layout
Adding Markup to the Template Layout
      Creating Placeholders
      Defining Groups
Defining Headers and Footers
      Native Support
Inserting Images and Charts
      Chart Support
Drawing, Shape, and Clip Art Support
Supported Native Formatting Features
      General Features
      Date Fields
      Multicolumn Page Support
      Background and Watermark Support
Template Features
      Page Breaks
      Initial Page Number
      Last Page Only Content
      End on Even or End on Odd Page
      Table of Contents
      Generating Bookmarks in PDF Output
      Check Boxes
      Drop Down Lists
Conditional Formatting
      If Statements
      If Statements in Boilerplate Text
      If-then-Else Statements
      Choose Statements
      Column Formatting
      Row Formatting
      Cell Highlighting
Page-Level Calculations
      Displaying Page Totals
      Brought Forward/Carried Forward Totals
      Running Totals
Data Handling
      Checking for Nulls
      Regrouping the XML Data
Using Variables
Defining Parameters
Setting Properties
Advanced Report Layouts
      Batch Reports
      Handling No Data Found Conditions
      Pivot Table Support
      Dynamic Data Columns
Number, Date, and Currency Formatting
Calendar and Timezone Support
Using External Fonts
      Custom Barcode Formatting
Controlling the Placement of Instructions Using the Context Commands
Using XPath Commands
Namespace Support
Using XSL Elements
Using FO Elements
Guidelines for Designing RTF Templates for Microsoft PowerPoint Output

Creating RTF Templates Using the Template Builder for Word

Getting Started
Accessing Data for Building Your Template
Inserting Components to the Template
Previewing a Template
Template Editing Tools
Uploading a Template to the BI Publisher Server
Using the Template Builder Translation Tools
Setting Options for the Template Builder
Setting Up a Configuration File
BI Publisher Menu Reference

Creating Excel Templates

Building a Simple Template
Formatting Dates
Defining BI Publisher Functions
      Reporting Functions
      Formatting Functions That Rely on Specific Data Attribute Values
      Grouping Functions
Preprocessing the Data Using an XSL Transformation (XSLT) File
Using the Template Viewer to Debug a Template

Creating PDF Templates

Designing the Template
Adding Markup to the Template
      Creating a Placeholder
      Defining Groups of Repeating Fields
Adding Page Numbers
Performing Calculations
Completed PDF Layout Example
Runtime Behavior
Creating a Layout from a Predefined PDF Form
Adding or Designating a Field for a Digital Signature

Creating Flash Templates

Building a Flash Template
Uploading the Flash Template to the Report Definition
Setting Properties for PDF Output
For More Information

Creating eText Templates

Structure of eText Templates
Constructing the Data Tables
      Command Rows
      Structure of the Data Rows
Setup Command Tables
Creating a Filler Block
Expressions, Control Structures, and Functions
Identifiers, Operators, and Literals

Setting Report Processing and Output Document Properties

PDF Output Properties
PDF Security Properties
PDF Digital Signature Properties
RTF Output Properties
HTML Output Properties
FO Processing Properties
RTF Template Properties
PDF Template Properties
Flash Template Properties
CSV Output Properties
Excel 2007 Output Properties
All Outputs
Defining Font Mappings

Creating and Implementing Style Templates

Creating and Implementing Style Templates

Understanding Style Templates
Creating a Style Template RTF File
Uploading a Style Template File to the Catalog
Assigning a Style Template to a Report Layout
Updating a Style Template
Adding Translations to Your Style Template Definition

Creating and Implementing Sub Templates

Understanding Subtemplates

What is a Subtemplate
Supported Locations for Subtemplates
Designing a Subtemplate
Testing Subtemplates from the Desktop
Creating the Sub Template Object in the Catalog
Calling a Subtemplate from an External Source

Designing RTF Subtemplates

Understanding RTF Subtemplates
Process Overview for Creating and Implementing RTF Subtemplates
Creating an RTF Subtemplate File
Calling a Subtemplate from Your Main Template
When to Use RTF Subtemplates
Adding Translations to an RTF Subtemplate

Designing XSL Subtemplates

Understanding XSL Subtemplates
Process Overview for Creating and Implementing XSL Subtemplates
Creating an XSL Subtemplate File
Calling an XSL Subtemplate from Your Main Template
Creating the Sub Template Object in the Catalog
Example Uses of XSL Subtemplates

Translating Reports and Catalog Objects

Translation Support Overview and Concepts

Translation Support Overview
Working with Translation Files
What Is an XLIFF?
Structure of the XLIFF File
Locale Selection Logic

Translating Individual Templates

Types of Translations
Using the XLIFF Option
Using the Localized Template Option

Translating Catalog Objects, Data Models, and Templates

What Can Be Translated
Exporting the XLIFF File
Identifying and Updating the Object Tags
Importing the XLIFF File

Techniques for Handling Large Output Files

Techniques for Handling Large PDF Output Files
Reusing Static Content
Generating Zipped PDF Output
Implementing PDF Splitting for an RTF Template
Implementing PDF Splitting for a PDF Template

Extended Function Support in RTF Templates

Extended SQL and XSL Functions
XSL Equivalents
Using FO Elements

Designing Accessible Reports

Avoiding Nested Tables or Separated Tables
Defining a Document Title
Defining Alternative Text for an Image
Defining a Table Summary
Defining a Table Column Header
Defining a Table Row Header
Sample Supported Tables

Supported XSL-FO Elements

Supported XSL-FO Elements