[flexcoders] AdvancedDataGrid grouping with different depths

[rueter007]

Hi,

I have the following dataprovider for an ADG.

                        [Bindable]
                        private var dpFlat:ArrayCollection = new 
ArrayCollection([
                          {Region:"Southwest", State:"Arizona", Title:"Barbara 
Jennings",
Actual:38865, Estimate:40000}, 
                          {Region:"Southwest", State:"Arizona", Title:"Dana 
Binn",
Actual:29885, Estimate:30000},  
                          {Region:"Southwest", State:"Central California", 
Title:"Joe
Smith", Actual:29134, Estimate:30000},  
                          {Region:"Southwest", State:"Nevada", Title:"Bethany 
Pittman",
Actual:52888, Estimate:45000},  
                          {Region:"East", State:"Northern California", 
Title:"Lauren
Ipsum", Actual:38805, Estimate:40000},
                          {Region:"East", State:"Northern California", 
Title:"T.R. Smith",
Actual:55498, Estimate:40000},  
                          {Region:"West", State:"Southern California", 
Title:"Alice Treu",
Actual:44985, Estimate:45000}, 
                          {Region:"West", State:"Southern California", 
Title:"Jane Grove",
Actual:44913, Estimate:45000},
                  {State:"Idaho", Title:"Lauren Ipsum", Actual:38805, 
Estimate:40000},
                          {Title:"ABD PST", Actual:38805, Estimate:40000}

                        ]);


I defined the grouping as follows.

    <mx:dataProvider>
        <mx:GroupingCollection id="gc" source="{dpFlat}">
            <mx:grouping>
                <mx:Grouping>
                    <mx:GroupingField name="Region">
                            <mx:summaries>
                              <mx:SummaryRow summaryPlacement="group">
                                <mx:fields>
                                        <mx:SummaryField dataField="Actual"
operation="SUM"/>
                                        <mx:SummaryField dataField="Estimate"
operation="SUM"/>
                                </mx:fields>
                              </mx:SummaryRow>
                            </mx:summaries>                     
                    </mx:GroupingField>
                    <mx:GroupingField name="State">
                            <mx:summaries>
                              <mx:SummaryRow summaryPlacement="group">
                                <mx:fields>
                                        <mx:SummaryField dataField="Actual"
operation="SUM"/>
                                        <mx:SummaryField dataField="Estimate"
operation="SUM"/>
                                </mx:fields>
                              </mx:SummaryRow>
                            </mx:summaries>                     
                    </mx:GroupingField>
                </mx:Grouping>
            </mx:grouping>
        </mx:GroupingCollection>
    </mx:dataProvider>

The problem is with the last two rows in the dataprovider. ADG forces
all of them to be at the same depth and adds 'Not Available' tree
nodes instead of placing the rows without the open/close icons at the
top level. Is it
possible to disable grouping when not necessary? This is a common
requirement and I believe there should be a way to get this working.

thanks,
venkat