Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Basic Report Builder Concepts

1.1 What is Report Builder?

1.2 Tools for working with reports in Report Builder

1.2.1 Using wizards to automate report design

1.2.1.1 Report Wizard

1.2.1.2 Data Wizard

1.2.1.3 Web Wizard

1.2.2 Using the Report Editor to view and edit reports

1.2.2.1 Live Previewer

1.2.2.2 Data Model view

1.2.2.3 Layout Model view

1.2.2.4 Parameter Form view

1.2.3 Using the Object Navigator to locate report elements

1.3 Obtaining database access before you start

1.4 Other software needed before you start

1.5 Operating system considerations

2 Building a Report with Conditional Formatting

2.1 Creating the initial report with the Report Wizard

2.2 Making simple formatting modifications to the report

2.3 Adding a formatting exception to a field

2.4 Adding more functionality to the generated format trigger code

2.5 Adding a formatting exception to a repeating frame

2.6 Modifying the generated code

2.7 Summary

3 Building and Applying Report Templates

3.1 Creating a data model

3.1.1 Building two queries using the SQL Query tool

3.1.2 Renaming Data Model objects

3.1.3 Creating a break group

3.1.4 Creating a data link

3.2 Creating a report

3.2.1 Creating the default layout

3.2.2 Formatting objects using the Live Previewer

3.3 Creating a template

3.3.1 Creating a new template

3.3.2 Adding an HTML header to the template

3.3.3 Creating a format trigger

3.4 Adding the new template to the predefined templates list

3.4.1 Viewing report styles and the Predefined template list in the Report Wizard

3.4.2 Adding the template to the Predefined template list

3.4.3 Displaying sample template images in the Template page of the Report Wizard

3.5 Applying the customized template to the report

3.6 Enhancing the default attributes of the template

3.6.1 Setting default attributes

3.6.2 Inheriting and localizing property values

3.6.3 Applying changes to the template and viewing the results in Live Previewer

3.7 Overriding the default attributes of the template

3.8 Creating an additional layout

3.9 Enhancing the look of the report

3.10 Summary

4 Building a Report for the Web

4.1 Creating a data model

4.2 Modifying the look of your report output

4.2.1 Modifying the layout in the Live Previewer

4.2.2 Adding format masks

4.2.3 Changing the maximum number of rows returned by your query

4.3 Including an HTML report header

4.4 Adding bookmarks to parts of your report

4.5 Changing the page separator

4.6 Adding hyperlink destinations and hyperlinks

4.6.1 Adding hyperlink destinations

4.6.2 Adding hyperlinks to destinations within the report

4.6.3 Adding hyperlinks to external destinations

4.7 Displaying pop-ups and rollovers in HTML output

4.7.1 Adding a pop-up to an image object

4.7.2 Adding a rollover to an image object

4.8 Using PL/SQL to conditionally hide/show objects for Web output

4.9 Creating a summary section with a chart

4.9.1 Creating the data model for the summary section

4.9.2 Creating the default layout for the summary section

4.9.3 Creating a chart for the summary section

4.9.4 Adding hyperlinks to your chart

4.10 Adding Javascript

4.10.1 Creating animated objects

4.10.2 Using HTML page streaming

4.11 Running the Web report from the Reports Server

4.12 Summary

5 Building a Report with Sections

5.1 Creating a data model

5.1.1 Building queries using the Data Wizard

5.1.2 Refining the Data Model

5.2 Designing a Runtime Parameter Form

5.3 Creating a layout for the first section

5.4 Refining the layout in the Layout Model view

5.4.1 Changing the properties of objects

5.4.2 Re-arranging frames and objects

5.4.3 Adding boilerplate objects

5.5 Creating a layout for the second section

5.5.1 Creating the default layout

5.5.2 Refining the layout in the Live Previewer

5.6 Specifying landscape orientation and page break

5.7 Specifying distribution

5.7.1 Specifying distribution for the detailed section

5.7.2 Specifying distribution for the summary section

5.7.3 Distributing the report

5.8 Summary

6 Building a Report with Ref Cursor Queries

6.1 Defining a ref cursor type

6.2 Creating a ref cursor query

6.3 Refining the data model

6.4 Creating links between ref cursor queries

6.5 Adding summary columns

6.6 Creating a layout

6.7 Moving the SELECT statement into a package

6.8 Moving the packages into a library

6.9 Summary

7 Building a Report Using Express Data

7.1 Creating an Express report with the Report Wizard

7.2 Refining the Express query

7.3 Adding summary columns and custom measures to your data model

7.3.1 Renaming data objects

7.3.2 Creating summary columns

7.3.3 Creating a custom measure

7.4 Enhancing the report layout

7.4.1 Inserting summary fields in the report

7.4.2 Inserting the custom measure field into the report

7.4.3 Sorting dimension values

7.4.4 Making format changes in Live Previewer

7.5 Summary

Index