Sorting the data

Top  Previous  Next

For correct working of the group, it is needed to fulfill the following condition: data source must be sorted on that column which is used in the group condition. If this condition is not fulfilled, you will see a lot of groups containing 1-2 data rows:

 

group_sort_error

 

Fortunately, there is a possibility of sorting the data source in two ways.

 

you can set up the data sorting in the group editor. Data source will be automatically sorted on group condition;
you can set up the sorting in the "Data" band editor.

 

Both methods are equivalent, however it is comfortable to use the first method. When creating groups, you set up the data grouping and sorting in one dialog.

 

In certain situations, the first method should not be used. Assuming that, we will set grouping on the first letter of the product's name. In such case, the product will be sorted only on the first letter, which is not acceptable. You should use the second method and indicate sorting on the full name of the product.