Previous TopicNext Topic


Table of Contents

Learning the Basics

Tutorial 1: Building a simple listing report

Task 1: Create a new project

Task 2: Create a new report

Task 3: Build a data source

Task 4: Build a data set

Task 5: Lay out the report

Task 6: Sort the data

Task 7: Format the report

Edit the column headings

Format the column headings

Display first and last names on the same line

Increase the space between rows

Task 8: Create a report title

Next steps

Connecting to a Data Source

Working with data sources

How to create a BIRT data source

How to modify an existing BIRT data source

How to delete a BIRT Report Designer data source

How to specify the connection information for a database or other JDBC data source

How to add a JDBC driver

How to delete all JDBC drivers that are in a JAR file

Retrieving Data

How to create a data set

How to change the data source for a data set

How to create a SQL query for a JDBC data set

How to specify a stored procedure for a JDBC data set

How to view and change output columns

How to change the number of rows that appear in Preview Results

How to add a computed field to a data set

How to join data sets

How to define a dynamic query

Binding Data

How to create a column binding

Laying Out a Report

How to add a row or column

How to delete a row or column

How to bind a data set to a table

How to insert a linked image

How to insert an embedded image

How to insert images that are stored in a data source

Displaying Text

How to use a dynamic text element

Formatting Report Content

How to create a style

How to import styles

How to link a CSS file

How to apply a style

How to modify a style

How to delete a style

How to create a formatting rule

How to modify a formatting rule

How to delete a formatting rule

How to resize a column or row by dragging its boundary

How to specify a row height

How to specify a column width

How to merge table or grid cells

How to conditionally hide an element

Sorting and Grouping Data

Tutorial 2: Grouping report data

Task 1: Open the report design

Task 2: Save the report as a new file

Task 3: Add the credit limit field to the data set

Task 4: Add credit limit data to the report

Task 5: Group customer data by credit limit

Task 6: Display credit limit ranges in the group header

Task 7: Display aggregate information

Display the number of customers in each group

Display the number of customers in the report

Task 8: Format the report

Remove credit limit data from the detail rows

Display group headings on the first row of each group

Separate each group with a line

Task 9: Preview the report in the BIRT report viewer

Task 10: Display credit limit ranges in the table of contents

Aggregating Data

How to display aggregate data

Writing Expressions

Filtering Data

How to filter the rows to retrieve from a JDBC data source

How to filter at the data set level

How to filter at the report element level

How to filter at the group level

Enabling the User to Filter Data

Enabling the user to filter at query run time

How to create a basic report parameter

How to insert a parameter marker in the SQL query

How to create a data set parameter

How to dynamically update a filter condition when the report runs

Tutorial 3: Creating and using report parameters

Task 1: Create a new report

Task 2: Build a data source

Task 3: Build a data set

Task 4: Lay out the data

Task 5: Create a report parameter that prompts for a minimum product quantity

Task 6: Create a report parameter that prompts for a vendor name

Task 7: Edit the query

Task 8: Create data set parameters and bind them to the report parameters

Task 9: Test the report parameters

Task 10: Provide the option to select all vendors

Task 11: Create a title that uses the report parameter values

Building a Report That Contains Subreports

Tutorial 4: Building a report with side-by-side subreports

Task 1: Create a new report

Task 2: Build a data source

Task 3: Build a data set for the customer report

Task 4: Build a data set for the orders subreport

Task 5: Build a data set for the payments subreport

Task 6: Create the customer master report

Task 7: Create the orders subreport

Task 8: Link the orders subreport to the customers master report

Task 9: Create the payments subreport

Task 10: Link the payments subreport to the customers master report

Task 11: Display only customers that have orders or payments

Task 12: Display the subreports next to one another

Task 13: View the outline of the report

Task 14: Format the report

Highlight the customer names

Edit the column headings

Change the date formats

Change the number formats

Increase the vertical space between elements

Increase the horizontal space between the Orders and Payments tables

Add borders around the tables

Increase the space between the table borders and contents

Using a Chart in a Report

Tutorial 5: Creating a chart

Task 1: Set up the report design file

Task 2: Add the chart to the report

Task 3: Providing data for a chart

Task 4: Enlarge and preview the chart

Task 5: Updating the chart title

Task 6: Refine the chart appearance

Displaying Data in Charts

How to select a chart data set

How to group category series data

How to set the data type and format of an axis

How to change chart preview preferences

Laying Out and Formatting a Chart

How to set a chart's background color

How to define a custom color

How to set the wall or floor color of a chart with depth or a three-dimensional chart

How to set chart area insets

How to set a background color for the plot

How to outline the plot area

How to shadow the plot area within the axes

How to adjust the placement and padding of a chart plot

How to format an axis title

How to modify an axis line

How to modify axis tick marks

How to add or modify gridlines

Presenting Data in a Cross Tab

Tutorial 6: Creating a cross tab

Task 1: Create a new report

Task 2: Build a data source

Task 3: Build a data set

Task 4: Add a cross tab to the report

Task 5: Organize data for the cross tab

Task 6: Insert data in the cross tab

Task 7: Add grand totals

Task 8: Format the cross tab

Display a string in empty cells

Change the format of the numbers

Edit the column headings

Use darker lines around the cross tab and around the cells

Designing a Multipage Report

How to display text in the header and footer

How to specify a header or footer size

How to exclude header content from the first page

Adding Interactive Viewing Features

How to create a bookmark

How to link two report sections

How to link two reports

How to create a table of contents entry

How to export report data

Building a Shared Report Development Framework

How to add an element to a library

How to set a theme for a report design

How to drop a theme from a report design

How to create a template report item

How to set up a template folder

How to publish a template

How to use a template report item

Localizing Text

How to assign a resource file to a report

How to assign an existing resource key to a label or text element

How to preview a report in a different locale

Using Scripting in a Report Design

Overview of BIRT scripting

Choosing between Java and JavaScript

Using both Java and JavaScript to write event handlers

Calling a method of a class that resides in a plugin

Getting the HTTPSession object

Using JavaScript to Write an Event Handler

How to use BIRT Report Designer to enter a JavaScript event handler

Determining method execution sequence

Providing the ReportDesign.initialize code

How to provide code for the ReportDesign.initialize method

Providing the code for the methods you want to track

Providing the ReportDesign.afterFactory code

Tutorial 7: Writing an event handler in JavaScript

Task 1: Open the report design

Task 2: Create and initialize a counter in the Table.onCreate( ) method

Task 3: Conditionally increment the counter in the Row.onCreate( ) method

Task 4: Display the result, using the ReportDesign.afterFactory( ) method

Using Java to Write an Event Handler

How to create an event handler class and add it to the Java project

How to associate a Java class with a report element

Scripting reference

Class DateTimeSpan

DateTimeSpan.addDate

DateTimeSpan.addTime

DateTimeSpan.days

DateTimeSpan.hours

DateTimeSpan.minutes

DateTimeSpan.months

DateTimeSpan.seconds

DateTimeSpan.subDate

DateTimeSpan.subTime

DateTimeSpan.years

Class Finance

Finance.ddb

Finance.fv

Finance.ipmt

Finance.irr

Finance.mirr

Finance.nper

Finance.npv

Finance.percent

Finance.pmt

Finance.ppmt

Finance.pv

Finance.rate

Finance.sln

Finance.syd


(c) Copyright Actuate Corporation 2006

Previous TopicNext Topic