Previous Next

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
Accessibility features in BIRT Report Designer
Connecting to a Data Source
About BIRT data sources
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
About data sets
How to create a SQL query to retrieve data from a JDBC data source
How to use a stored procedure to retrieve data from a JDBC data source
How to view and change output columns
How to add a computed field to a data set
How to join data sets
How to change the number of rows that appear in Preview Results
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 hide an element conditionally
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
How to create a basic report parameter
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 update a filter condition dynamically 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 containing 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
Tutorial 5: Creating a standalone chart
Task 1: Set up and query the data source
Task 2: Add the chart to the report
Task 3: Provide data for a chart
Task 4: Enlarge the report design and preview the report
Task 5: Change the chart title
Task 6: Refine the chart appearance
Displaying Data in Charts
How to group categories on the x-axis
How to change chart preview preferences
Laying Out and Formatting a Chart
How to set a chart’s background color
, How to modify the plot area
How to format an axis title
How to set the data type and format of an axis
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 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 define a bookmark
How to create a hyperlink that links two sections in a report
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 set a theme for a report design
How to drop a theme from a report design
How to add an element to a library
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 JavaScript and Java
Using both JavaScript and Java to write event handlers
Using JavaScript to Write an Event Handler
How to use BIRT Report Designer to enter a JavaScript 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 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