Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Building a Report with a Barcode

1.1 Prerequisites for this example

1.1.1 Example files

1.1.2 Access to the sample schema

1.1.3 Update the REPORTS_CLASSPATH environment variable

1.2 Create a barcode report for paper

1.2.1 Import the Java classes into Reports Builder

1.2.2 Create a package to store your information

1.2.3 Create a Before Report trigger

1.2.4 Create a data model with a formula column

1.2.5 Create a layout for your report

1.3 Create a barcode report for the Web

1.3.1 Create a query in an existing HTML file

1.3.2 Create three formula columns in your data model

1.3.3 Initialize the barcode JavaBean and set its properties

1.3.4 Run your report to the Web

1.4 Summary

2 Bursting and Distributing a Report

2.1 Prerequisites for this example

2.1.1 Example files

2.1.2 Access to the sample schema

2.2 Set up an existing report for bursting

2.3 Edit the distribution XML definition

2.4 Run the report

2.5 Summary

3 Building a Paper Report with Ref Cursors

3.1 Prerequisites for this example

3.1.1 Access to the sample Human Resources schema

3.2 Defining a ref cursor type

3.3 Creating a ref cursor query

3.4 Refining the data model

3.5 Creating links between ref cursor queries

3.6 Adding summary columns

3.7 Creating a layout

3.8 Moving the SELECT statement into a package

3.9 Moving the packages into a library

3.10 Summary

4 Building a Report with an XML Pluggable Data Source

4.1 Prerequisites for this example

4.1.1 Example files

4.1.2 Access to the sample schema

4.2 Create a report manually with SQL and XML queries

4.2.1 Create a SQL query for your new report

4.2.2 Create an XML query to access your XML data source

4.2.3 Create a data link between two queries

4.2.4 Create a layout for your report using the Report Wizard

4.2.5 Apply alternating row colors to your report

4.2.6 Filter your XML data using groups

4.3 Run your report to paper

4.4 Summary

5 Building a Report with a Text Pluggable Data Source

5.1 Prerequisites for this example

5.2 Set up the textpds.conf file

5.3 Use the Report Wizard to create a report

5.4 Summary

6 Building a Report Using Express Data

6.1 Prerequisites for this example

6.1.1 Example files

6.1.2 Access to an Express Server

6.2 Creating an Express report with the Report Wizard

6.3 Refining the Express query

6.4 Adding summary columns and custom measures to the data model

6.4.1 Renaming data objects

6.4.2 Creating summary columns

6.4.3 Creating a custom measure

6.5 Enhancing the report layout

6.5.1 Inserting summary fields in the report

6.5.2 Inserting the custom measure field into the report

6.5.3 Sorting dimension values

6.5.4 Making format changes in the Paper Design view

6.6 Summary

Glossary

Index