Anyone have an idea on this problem? Thanks in advance.
--- In flexcoders@yahoogroups.com, "rueter007" <[EMAIL PROTECTED]> wrote:
>
> 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
>