Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




Eclipse BIRT Report Developer Guide
Previous Page Home Next Page

Previous Next

The report is currently sorted alphabetically by customer name. Recall that in the first tutorial, you specified that the rows in the table be sorted by customer name. In this procedure, you group the data by credit limit in intervals of 50,000. When you group data, BIRT sorts the rows into groups first, then it sorts the rows within each group, assuming that you also specify a sort condition at the table level. As you will see when you complete this task, the data rows within each credit limit group will be sorted by customer name.

Right-click the table, and choose Insert Group Above. New Group, shown in Figure 8‑6, displays the group properties you can set.

Figure 8-6 New Group

Figure 8‑6
The table in the report design displays a group header and a group footer row, as shown in Figure 8‑7. The table also shows the data element that the layout editor automatically added to the group header row. This data element serves as the group heading and, in the generated report, displays the first credit limit value of each group.

Figure 8-7 Group header and group footer rows in a report design

Select the [CREDITLIMIT] data element that appears in the group header row. Do not select the [CREDITLIMIT] data element that appears in the detail row.
In Property Editor, under Properties, choose General, then choose the B button to format the group heading as bold text.
Preview the report. Scroll down the report to view all the data. The report organizes data into four credit limit groups. At the beginning of each group, you see the following numbers in bold: 0, 61100, 113000, 227600. These numbers match the first credit limit value of each group. Within each group, customer names are sorted in alphabetical order. Figure 8‑8 shows one of the four credit limit groups.

Figure 8-8 Report preview showing one of the four credit limit groups

(c) Copyright Actuate Corporation 2009

  Published under the terms of the Eclipse Public License Version 1.0 ("EPL") Design by Interspire