Sorting and Grouping Data
Sorting data
Ways to sort data
How to sort data through the query
How to sort data in BIRT
Setting the sort strength
Sorting string data ignoring capitalization
Grouping data
How to group data
Grouping data by intervals
Grouping string data by intervals
How to group string data by intervals
Grouping numeric data by intervals
How to group numeric data by intervals
Grouping date-and-time data by intervals
How to group date-and-time data by intervals
Sorting data at the group level
How to sort data at the group level
Disabling group sorting
How to disable group sorting
Creating multiple groups
Changing the order of groups
How to change the order of groups
Adding group headings
Inserting group header rows
How to insert a group header row
Displaying group headings in the detail row
How to drop a group heading to the detail row
Specifying expressions for group headings
Tutorial 2: Grouping report data
Task 1: Open the report design
Task 2: Save the report as a new file
Task 3: Add the credit limit field to the data set
Task 4: Add credit limit data to the report
Task 5: Group customer data by credit limit
Task 6: Display credit limit ranges in the group header
Task 7: Display aggregate information
Display the number of customers in each group
Display the total number of customers in the report
Task 8: Format the report
Adjust the column widths
Remove credit limit data from the detail rows
Display group headings on the first row of each group
Separate each group with a line
Display the number of customers text on one line
Task 9: Preview the report in the BIRT report viewer
Task 10: Display credit limit ranges in the table of contents
Sorting and Grouping Data
Display credit limit ranges in the table of contents