2 Replies Latest reply on Oct 25, 2010 9:04 AM by flex_fiend

    how to change the order of groups in AdvancedDataGrid

    flex_fiend

      Hello,

       

      I have a dataset similar to the following:

       

       

      Region   Sales
      ======   ======
      North     10
      North     15
      South     5
      East      20
      West      5
      West      4
      West      3
      

       

       

      I'd like to group by Region and sort the groups by the Sales subtotal for each group. I already have the data grouped correctly using GroupingCollection2. How can I sort the groups by the sales subtotal (it sorts by region name by default)? I've seen some posts that talk about creating a custom groupingObjectFunction and applying a group sort. But I'm still confused. Can someone give me some pointers on how to achieve this?

       

      So ideally, the AdvancedDataGrid would end up looking like this with the regions sorted by sales subtotal;

       

      Region    Sales
      ======    ======
      North
                10
                15
       subtotal 45
      East
                20
       subtotal 20
      West
                5
                4
                3
       subtotal 12
      South
                5
       subtotal 5
      
        • 2. Re: how to change the order of groups in AdvancedDataGrid
          flex_fiend Level 1

          Thanks, I looked at that earlier but it doesn't contain the solution I was hoping to find.

           

          I ended up not using GroupingCollection. I think GroupingCollection is cool, but it isn't really customizable to the extent I need.

           

          I just ended up transforming my data into a hierarchical form that could be used directly by AdvancedDataGrid. At the top level of my hierarchy, I have the detail txn groups, subtotal groups, and grand total groups. To sort the groups, I use custom SortFields. So, for example, if I want to sort by group name, I add a SortField for the groupName attribute. Both the Detail Group and the Subtotal Group share the same group name. Then I add a SortField for a summaryRow attribute. Only the subtotal group has that attribute. This ensures that the Detail Group is always followed by the associated Subtotal Group after sorting. I store my groups in an XMLListCollection and then set the sort attribute, then call refresh().

           

          Not ideal, but it works. If my requirements were more complex, perhaps my approach wouldn't have worked as well. But as it stands it works well and has good performance.

           

          I was hoping that ADG could handle this kind of sorting for me, but after looking at the source code, it seems like this is not possible without implementing my own custom GroupingCollection class and possibly other supporting classes.

           

          One key thing to note is that clicking the column header to sort within groups works fine. However, if you then attempt to sort at the group level, ADG hangs while trying to refresh itself. The trick is to assign the dataProvider.sort attribute to a temporary variable, then set it to null (this sort variable contains the ADG column sorts that the user clicked). Apply your group level sort and then reapply the dataProvider.sort attribute.