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 12‑22 shows how to select the value from a drop-down list.
