Disabling group sorting
As mentioned in the previous section, by default, BIRT sorts group values in ascending order. You can disable this sorting if you want to group the data rows in the order the data set returns them. For example, if you use the ORDER BY clause in a SQL query to sort data, disabling sorting in BIRT prevents unnecessary processing and improves performance.
How to disable group sorting
1 Select the table or list.
2 In Property Editor, choose the Properties tab, and choose Advanced.
3 Set the Sort By Groups property to false. Figure 9‑22 shows how to select the value from a drop-down list.
Figure 9‑22 Changing the Sort By Groups value