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

Task 6: 

When you first create and preview a report, the report displays the data rows in the order in which the query returns them. The order can vary, depending on many factors, such as how data was supplied in the data source. In most cases, you will want to change the order in which data appears in the report.

Open Property Editor, if necessary. If you use the default report design perspective, Property Editor appears below the layout editor. If it is not open, choose WindowShow ViewProperty Editor.
In the layout editor, select the table by selecting the Table tab in the lower left corner. This tab appears when you hover the mouse pointer over this area. Property Editor displays the properties for the table, as shown in Figure 1‑19.

Figure 1-19 Property Editor displaying the general properties of the table

Figure 1‑20 shows the sort definition.

Figure 1-20 Sort definition in New Sort Key

Figure 1-21 Data sorted by customer name

Notice that names with uppercase letters appear at the top of the list. BIRT sorts string data by UCS2 code point values. In ASCII-based character sets, uppercase letters have lower code point values than lowercase letters. Therefore, uppercase letters appear before lowercase letters.
Sort the customer names case-insensitively so that ANG Resellers appears after American Souvenirs Inc., rather than before.
On the Sort page, shown in Figure 1‑22, select the sort key, then choose Edit.

Figure 1-22 Sort key displayed on the Sort page

This expression uses the JavaScript toUpperCase( ) function to convert all the customer name values to uppercase before sorting. JavaScript function names are case-sensitive, so you must type toUpperCase( ) exactly as shown. References to column names are also case-sensitive. In this expression, row["CUSTOMERNAME"] is the correct name to use. If you type row["customername"], for example, BIRT Report Designer displays an error when you run the report. You can verify the capitalization of a column name by looking at the name that is displayed in Data Explorer.
Preview the report. The customer names appear in a different order. Names with uppercase letters do not appear at the top of the list.

(c) Copyright Actuate Corporation 2009

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