O'Reilly logo

BIRT: A Field Guide to Reporting by Nola Hague, Alethea Hannemann, Diana Peh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12. Sorting and Grouping Data

When you first create a report and preview the data, the report displays the data in the order in which your data source returns it. The order varies, based on how data was entered in the data source and how you joined tables in the query.

In most cases, you will want to change the order in which data appears in the report. A customer phone list, for example, is easier to use if it is in alphabetical order. A sales report is more useful if it presents sales figures from highest to lowest, or the reverse, if you want to see low to top performers.

Compare the reports in Figure 12-1.

Reports showing unsorted and sorted data

Figure 12-1. Reports showing unsorted ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required