This is a migrated thread and some comments may be shown as answers.

Grouping that doesn't alter data order

2 Answers 16 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Nick
Top achievements
Rank 2
Nick asked on 18 Oct 2016, 08:20 PM

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?

 

2 Answers, 1 is accepted

Sort by
0
Nick
Top achievements
Rank 2
answered on 18 Oct 2016, 08:26 PM

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

0
Katia
Telerik team
answered on 21 Oct 2016, 11:43 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Nick
Top achievements
Rank 2
Answers by
Nick
Top achievements
Rank 2
Katia
Telerik team
Share this question
or