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

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

How to modify an existing BIRT Report Designer data source

How to delete a BIRT Report Designer data source

How to specify an additional JDBC driver

How to delete all JDBC drivers contained in a JAR file

Retrieving data

How to create a data set to access data

How to change the data source for a data set

How to specify 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 preview the results returned by a data set

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

How to set cache preferences

How to add a computed field to a data set

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 bind a data set to a list

How to create a computed field in the report layout

How to insert a linked image

How to insert an embedded image

How to insert images 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 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

Designing a multi-page report

How to display text in the header and footer

How to exclude header content from the first page

How to specify a header or footer size

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

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

Aggregating data

How to construct an aggregate expression in Expression Builder

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

Steps for enabling the user to filter database data

How to insert a parameter marker in the SQL query

How to create a data set parameter

How to create a simple report parameter

How to bind a data set parameter to a report parameter

How to dynamically update a filter condition at run time

Building a report with subreports

Tutorial 3: 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 master report

Task 9: Create the payments subreport

Task 10: Link the payments subreport to the master report

Task 11: Display only customers that have orders or payments

Task 12: Display the subreports side by side

Task 13: 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 its contents

Align the tops of the tables

Using a chart in a report

Tutorial 4: 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: Review the chart

Task 5: Updating chart titles

Task 6: Refine the chart appearance

Working with chart data

How to select a chart data set

How to set up an area, bar, or line chart using one series or a value series grouping key

How to specify data for a meter chart using one meter value series or a series grouping key

How to specify data for a pie chart using one series or a series grouping key

How to specify data for a scatter chart

How to specify data for a stock chart using one value series or a series grouping key

How to sort category series data

How to group category series data

How to define a scatter chart x axis as a value or category axis

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 the chart background color

How to add an outline to a chart

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

How to set a standard chart unit

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 specify the data the legend displays

How to add an axis title

How to format an axis title

How to add a value series title in a meter or pie chart

How to format a value series title in a meter or pie chart

How to create an axis marker

How to format a marker line

How to format a marker range

How to add a marker label

How to modify an axis line

How to modify axis tick marks

How to add or modify gridlines

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

How to link a chart to a web page, document, or image

Building a shared report development framework

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

Determining method execution sequence

Determining method execution sequence

Providing the ReportDesign.initialize code

Providing the code for the methods you want to track

Providing the ReportDesign.afterFactory code

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

Tutorial 5: Writing an event handler in JavaScript

Task 1: Open the report design

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

Task 3: Conditionally increment the counter in the Table.onRow( ) method

Task 4: Display the result, using the Table.onFinish( ) method

How to create a Java 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

Class Total

Total.ave

Total.count

Total.countDistinct

Total.first

Total.irr

Total.last

Total.max

Total.median

Total.min

Total.mirr

Total.mode

Total.movingAve

Total.npv

Total.runningNpv

Total.runningSum

Total.stdDev

Total.sum

Total.variance

Total.weightedAve

Report Object Model reference

Understanding the ROM elements

CascadingParameterGroup

Cell

Column

Data

DataSet

DataSource

DesignElement

ExtendedItem

Grid

Image

Label

Library

List

ListGroup

Listing

ListingGroup

MasterPage

Module

OdaDataSet

OdaDataSource

Parameter

ParameterGroup

ReportDesign

ReportElement

ReportItem

Row

ScalarParameter

ScriptDataSet

ScriptDataSource

SimpleMasterPage

Style

Table

TableGroup

TemplateDataSet

TemplateElement

TemplateParameterDefinition

TemplateReportItem

Text

TextData

Understanding the ROM structures

Action structure

CachedMetaData structure

ColumnHint structure

ComputedColumn structure

ConfigVar structure

DataSetParam structure

DataSetParamBinding structure

DateTimeFormatValue structure

EmbeddedImage structure

ExtendedProperty structure

FilterCondition structure

HideRule structure

HighlightRule structure

IncludeScript structure

IncludedLibrary structure

MapRule structure

NumberFormatValue structure

ParamBinding structure

PropertyBinding structure

PropertyMask structure

ResultSetColumn structure

SelectionChoice structure

SortKey structure

StringFormatValue structure

UserProperty structure

Understanding the BIRT plug-ins

About the plug-in files

The manifest file

Additional plug-in files

Understanding the individual BIRT plug-ins

org.eclipse.birt.chart.device.extension

org.eclipse.birt.chart.device.svg

org.eclipse.birt.chart.engine

org.eclipse.birt.chart.engine.extension

org.eclipse.birt.chart.reportitem

org.eclipse.birt.chart.ui

org.eclipse.birt.chart.ui.extension

org.eclipse.birt.core

org.eclipse.birt.core.ui

org.eclipse.birt.data

org.eclipse.birt.data.oda

org.eclipse.birt.data.oda.adapter.dtp

org.eclipse.birt.doc

org.eclipse.birt.report.data.oda.flatfile.ui

org.eclipse.birt.report.data.oda.flatfile

org.eclipse.birt.report.data.oda.jdbc.ui

org.eclipse.birt.report.data.oda.jdbc

org.eclipse.birt.report.data.oda.sampledb

org.eclipse.birt.report.data.oda.sampledb.ui

org.eclipse.birt.report.data.oda.xml

org.eclipse.birt.report.data.oda.xml.ui

org.eclipse.birt.report.designer.core

org.eclipse.birt.report.designer.rcp.ui

org.eclipse.birt.report.designer.ui

org.eclipse.birt.report.designer.ui.ide

org.eclipse.birt.report.designer.ui.lib.explorer

org.eclipse.birt.report.designer.ui.lib

org.eclipse.birt.report.designer.ui.rcp

org.eclipse.birt.report.engine.emitter.pdf

org.eclipse.birt.engine.emitter.html

org.eclipse.birt.report.engine

org.eclipse.birt.report.model

org.eclipse.birt.report.viewer

Plug-ins for optional samples download

org.eclipse.birt.chart.engine.examples

org.eclipse.birt.sample.reportitem.rotatedtext


(c) Copyright Actuate Corporation 2006

Previous TopicNext Topic