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