Table of Contents
- Title and Copyright Information
- Preface
-
Part I Create Pixel-Perfect Reports and Layouts
- 1 Introduction to Designing Reports
-
2
Create and Edit Reports
- About Report Components
- Create Reports: Process Overview
- Create Reports
- Create Reports Using a Direct Connection to a Subject Area
- Edit Reports
- Add Layouts to the Report Definition
- Configure Layouts Using the List View
- Configure Parameter Settings for the Report
- Configure Report Properties
- Access Reports via a URL
- About the Layout Editor Interface
-
3
Create Publisher Layout Templates
- Overview of Publisher Layouts
- Launch the Layout Editor
- Page Layout Tab
- Insert Layout Components
- Insert Layout Grids
- About Repeating Sections
- About Data Tables
- About Charts
- About Gauge Charts
- About Pivot Tables
- About Text Items
- About Images
- About Lists
- Set Predefined or Custom Formulas
- Save a Layout
-
4
Create RTF Templates
- Get Started
- Associate the XML Data to the Template Layout
- Add Markup to the Template Layout
- Define Groups
- Define Headers and Footers
- Insert Images and Charts
-
Add Drawings, Shapes, and Clip Art
- Add Freehand Drawings
- Add Hyperlinks
- Layer Shapes
- Use 3-D Effects
- Add Microsoft Equations
- Add Organization Charts
- Add WordArt
- Add Data-Driven Shapes
- Include Manipulation Commands
- Replicate Shapes
- Add Text to Shapes
- Add Text Along a Path
- Move a Shape
- Rotate a Shape
- Skew a Shape
- Change the Size of Shapes
- Combine Commands
- CD Ratings Example
- Grouped Shape Example
- Supported Formatting Features of Microsoft Word
- Template Features
- Use Conditional Formatting
- Insert Page-Level Calculations
- Handle Data
- Set Variables, Parameters, and Properties
- Use Advanced Report Layouts
-
Format Numbers, Dates, and Currencies
- Format Numbers
- Data Source Requirements
- Localization Considerations
- Use the Microsoft Number Format Mask
- Supported Microsoft Format Mask Definitions
- Use the Oracle Format Mask
- Format Dates
- Data Source Requirements
- Use the Microsoft Date Format Mask
- Use the Oracle Format Mask
- Default Format Mask
- Oracle Abstract Format Masks
- Display the System Date (sysdate) in Reports
- Format Currencies
- Apply a Currency Format to a Field
- Example: Display Multiple Currency Formats in a Report
- Example: Display Multiple Currency Codes in a Single Report
- Support Calendars and Time Zones
- Use External Fonts
- Control the Placement of Instructions Using the Context Commands
- Use XPath Commands
- Declare Namespaces
- Use FO Elements and XSL Elements
- Guidelines for Designing RTF Templates for Microsoft PowerPoint Output
- Guidelines for Designing RTF Templates for Microsoft Excel 2007 Output
- Render HTML Formatted Data in a Report
- Embed PCL Commands for Check Printing
- 2D Barcode Functions
-
5
Create RTF Templates Using the Template Builder for Word
- Overview
- Get Started Using the Template Builder
- Access Data for Building Templates
-
Insert Components to the Template
- Insert a Field
- Insert a Table Using the Table Wizard
- Insert a Table or Form Using the Insert Table/Form Dialog
- Insert a Chart
- Insert a Repeating Group
- Create Grouping Fields Around an Existing Block
- Insert a Pivot Table
- Manually Edit a Pivot Table
- Insert and Edit Conditional Regions
- Insert Conditional Formatting
- Preview a Template
- Template Editing Tools
- Upload a Template to Publisher
- Use the Template Builder Translation Tools
- Set Options for the Template Builder
- Set Up a Configuration File
- Publisher Menu Reference
-
6
Create Excel Templates
- Introduction to Excel Templates
- Understand the Mappings Between Template and Data
- Use the Template Builder for Excel
- Build a Basic Template Using the Template Builder
- Format Dates
- Understand Excel Template
- Use Advanced Publisher Functions
- Preprocess the Data Using an XSL Transformation (XSLT) File
-
7
Create PDF Templates
- Overview
- Requirements
- Design the Template
- Add Markup to the Template
- Create a Placeholder
- Define Groups of Repeating Fields
- Repeat a PDF Template by Using the document-repeat-elementname Form Field
- Add Page Numbers and Breaks
- Perform Calculations
- Completed PDF Layout Example
- Runtime Behavior
- Create a Layout from a Predefined PDF Form
- Add or Designate a Field for a Digital Signature
- PDF Template Limitations
-
8
Create eText Templates
- Overview
- Structure of eText Templates
- Construct the Data Tables
- Command Rows
- Structure of the Data Rows
-
Set Up Command Tables
- TEMPLATE TYPE Command
- DEFINE LEVEL Command
- DEFINE SEQUENCE Command
- Define Concatenation Command
- Base Level Subcommand
- Element Subcommand
- Delimiter Subcommand
- Use the SUBSTR Function
- Invalid Characters and Replacement Characters Commands
- Output Character Set and New Record Character Commands
- Output Length Mode
- Number Thousands Separator and Number Decimal Separator
- CASE CONVERSION
- Create a Filler Block
- Expressions, Control Structures, and Functions
- Identifiers, Operators, and Literals
-
9
Set Report Processing and Output Document Properties
- Overview
- PDF Output Properties
- PDF Digital Signature Properties
- PDF Accessibility Properties
- PDF/A Output Properties
- PDF/X Output Properties
- DOCX Output Properties
- RTF Output Properties
- PPTX Output Properties
- HTML Output Properties
- FO Processing Properties
- RTF Template Properties
- XPT Template Properties
- PDF Template Properties
- Excel Template Properties
- CSV Output Properties
- Excel Output Properties
- EText Output Properties
- All Outputs Properties
- Define Font Mappings
-
Part II Create Style Templates and Subtemplates
- 10 Create and Implement Style Templates
- 11 Understand Subtemplates
- 12 Design RTF Subtemplates
- 13 Design XSL Subtemplates
-
Part III Translate Objects in Pixel-Perfect Reports
- 14 Translation Support Overview and Concepts
- 15 Translate Individual Templates
- 16 Translate Catalog Objects, Data Models, and Templates
-
Part IV Reference Information
- 17 Techniques for Handling Large Output Files
- 18 Extended Function Support in RTF Templates
-
19
Design Accessible Reports
- Design for Accessibility
- Design Accessible Reports Using RTF Templates
- Design Accessible Reports Using Publisher Layouts
- 20 Supported XSL-FO Elements
- 21 Generate PDF/A and PDF/X Output
- 22 Generate Accessible PDF Output
- 23 Generate CSV Output
- 24 PDF Version Support
- 25 Test Templates with Template Viewer