Grouping that doesn't alter data order

3 posts, 0 answers
  1. Nick
    Nick avatar
    4 posts
    Member since:
    Mar 2011

    Posted 18 Oct Link to this post

    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. Nick
    Nick avatar
    4 posts
    Member since:
    Mar 2011

    Posted 18 Oct Link to this post

    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

  3. DevCraft banner
  4. Katia
    Admin
    Katia avatar
    303 posts

    Posted 21 Oct Link to this post

    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
Back to Top