Grouping that doesn't alter data order

[Nick]

I have a requirement to create a report that lays out the data detail in a specific order (chronological). As part of this I need to surround groups of detail sections with headers and footers that describe a common feature. The following is an example of what I want:

Common feature 1 header
Detail 6:00
Detail 7:00
Common feature 1 footer
Common feature 2 header
Detail 8:00
Detail 9:00
Common feature 2 footer
Common feature 1 header
Detail 10:00
Detail 11:00
Common feature 1 footer

When I add a group for the common feature though, I get the following:

Common feature 1 header
Detail 6:00
Detail 7:00
Detail 10:00
Detail 11:00
Common feature 1 footer
Common feature 2 header
Detail 8:00
Detail 9:00
Common feature 2 footer

I must preserve the order of the detail sections and let the grouping headers and footers repeat if necessary. Is there a setting or something to allow for this?

 

[Nick]

To be clear, the headers and footers are all for the same common feature. It's merely the value of the common feature that changes (in the example, between the values 1 and 2)

Maybe this is a clearer way to represent what I am trying to achieve:

Header for Common Feature value 1
Detail 6:00
Detail 7:00
Footer for Common Feature value 1
Header for Common Feature value 2
Detail 8:00
Detail 9:00
Footer for Common Feature value 2
Header for Common Feature value 1
Detail 10:00
Detail 11:00
Footer for Common Feature value 1

[Katia]

Hi Nick,

The described behavior is expected for report groups. The groups are rendered one by one in the order specified as group sorting expression.
There is no setting to sort the detailed data for all groups after the data has been already grouped.

You can sort the detailed data chronologically by setting the report's or group's sorting expression, however, if the report has multiple groups the sorting will be applied in the context of each group.


Regards,
Katia
Telerik by Progress