Sorting on multiple columns
You can sort data by up to three columns. When you sort by multiple columns, you use the Advanced Sort dialog box, as shown in Figure 4-4.
Figure 4-4  
When sorting data on multiple columns, it is important to understand the order of precedence for the sort. On Advanced Sort, select the columns in the order in which to sort data. For example, to sort data by city first, then by customer name, you must select the columns in that order on Advanced Sort.
How to sort data on multiple columns
1  
2  
Right-click the selected column, then choose SortAdvanced Sort from the context menu.
3  
4  
5  
Optionally, select a third column on which to sort. Figure 4-4 shows the sort criteria for the report design in Figure 4-2.

Additional Links:

Copyright Actuate Corporation 2013 BIRT iHub 2