oops ... wrong kind of grouping previous post ... here is another example: <mx:AdvancedDataGrid id="myADG" initialize="gc.refresh();" width="850" height="100%"> <mx:dataProvider> <mx:GroupingCollection id="gc" source="{flatDP}"> <mx:Grouping> <mx:GroupingField name="subRegion"> <mx:summaries> <mx:SummaryRow summaryPlacement="group"> <mx:fields> <mx:SummaryField operation="SUM" dataField="Y2009" label="Y2009"/> <mx:SummaryField operation="SUM" dataField="Y2010" label="Y2010"/> <mx:SummaryField operation="SUM" dataField="Y2011" label="Y2011"/> <mx:SummaryField operation="SUM" dataField="Y2012" label="Y2012"/> </mx:fields> </mx:SummaryRow> </mx:summaries> </mx:GroupingField> <mx:GroupingField name="team"> <mx:summaries> <mx:SummaryRow summaryPlacement="group"> <mx:fields> <mx:SummaryField operation="SUM" dataField="Y2009" label="Y2009"/> <mx:SummaryField operation="SUM" dataField="Y2010" label="Y2010"/> <mx:SummaryField operation="SUM" dataField="Y2011" label="Y2011"/> <mx:SummaryField operation="SUM" dataField="Y2012" label="Y2012"/> </mx:fields> </mx:SummaryRow> </mx:summaries> </mx:GroupingField> <mx:GroupingField name="nomadID"> <mx:summaries> <mx:SummaryRow summaryPlacement="group"> <mx:fields> <mx:SummaryField operation="SUM" dataField="Y2009" label="Y2009"/> <mx:SummaryField operation="SUM" dataField="Y2010" label="Y2010"/> <mx:SummaryField operation="SUM" dataField="Y2011" label="Y2011"/> <mx:SummaryField operation="SUM" dataField="Y2012" label="Y2012"/> </mx:fields> </mx:SummaryRow> </mx:summaries> </mx:GroupingField> </mx:Grouping> </mx:GroupingCollection> </mx:dataProvider> <mx:groupedColumns> <mx:AdvancedDataGridColumn width="80" headerText="Sub:Team:Unit" dataField="nomadID"/> <mx:AdvancedDataGridColumnGroup headerText="Account"> <mx:AdvancedDataGridColumn width="60" headerText="Type" dataField="accountName"/> <mx:AdvancedDataGridColumn width="20" headerText="No." dataField="accountNumber"/> <mx:AdvancedDataGridColumn width="10" > <mx:itemRenderer> <mx:Component> <mx:Button click="parentDocument.adminEdit();"> <mx:icon>@Embed(source='images/open.gif')</mx:icon> </mx:Button> </mx:Component> </mx:itemRenderer> </mx:AdvancedDataGridColumn> </mx:AdvancedDataGridColumnGroup> <mx:AdvancedDataGridColumnGroup headerText="Budget"> <mx:AdvancedDataGridColumn textAlign="right" width="50" headerText="Y2009" dataField="Y2009"/> <mx:AdvancedDataGridColumn textAlign="right" width="50" headerText="Y2010" dataField="Y2010"/> <mx:AdvancedDataGridColumn textAlign="right" width="50" headerText="Y2011" dataField="Y2011"/> <mx:AdvancedDataGridColumn textAlign="right" width="50" headerText="Y2012" dataField="Y2012"/> </mx:AdvancedDataGridColumnGroup> </mx:groupedColumns> </mx:AdvancedDataGrid>
--- In flexcoders@yahoogroups.com, "Don Kerr" <fusionp...@...> wrote: > > Try something like this below ... > > Don Kerr > > <mx:AdvancedDataGrid fontSize="9" id="linksDG" width="100%" height="100%" > dataProvider="{linksDP}" change="changeLink(linksDG.selectedItem.linkID);"> > <mx:groupedColumns> > > <mx:AdvancedDataGridColumn width="60" headerText="ID" > dataField="linkID"/> > <mx:AdvancedDataGridColumn width="80" headerText="Link > Name" dataField="linkName" dataTipField="linkName" showDataTips="true"/> > <mx:AdvancedDataGridColumnGroup headerText="Link > Margin"> > <mx:AdvancedDataGridColumn width="35" > headerText="Exp" dataField="linkMargin" textAlign="right"/> > <mx:AdvancedDataGridColumn width="35" > headerText="Spec" dataField="specMargin" textAlign="right"/> > </mx:AdvancedDataGridColumnGroup> > <mx:AdvancedDataGridColumn width="50" > headerText="Type" dataField="linkType"/> > <mx:AdvancedDataGridColumn width="50" headerText="Freq > Band" dataField="freqBand"/> > <mx:AdvancedDataGridColumnGroup headerText="Mission"> > <mx:AdvancedDataGridColumn width="50" > headerText="Phase" dataField="missionPhase"/> > <mx:AdvancedDataGridColumn width="60" > headerText="Links" dataField="missionSubPhase"/> > </mx:AdvancedDataGridColumnGroup> > <mx:AdvancedDataGridColumn width="60" > headerText="Service" dataField="services"/> > <mx:AdvancedDataGridColumn width="50" headerText="Time" > dataField="timePeriod"/> > <mx:AdvancedDataGridColumn width="40" > headerText="Es/No" dataField="esNo"/> > > > <mx:AdvancedDataGridColumnGroup headerText="Antenna"> > <mx:AdvancedDataGridColumn width="55" > headerText="Transmit" dataField="transmitAnt"/> > <mx:AdvancedDataGridColumn width="55" > headerText="Receive" dataField="receiveAnt"/> > </mx:AdvancedDataGridColumnGroup> > <mx:AdvancedDataGridColumnGroup headerText="Mode/Rate"> > > <mx:AdvancedDataGridColumn width="55" > headerText="Mode" dataField="mode"/> > <mx:AdvancedDataGridColumn width="55" > headerText="kbps" dataField="rate" textAlign="right"/> > </mx:AdvancedDataGridColumnGroup> > </mx:groupedColumns> > </mx:AdvancedDataGrid> > > > > > --- In flexcoders@yahoogroups.com, Patricia Han <flexhan@> wrote: > > > > Hi There, > > > > Have you ever successfully create a table or grid with hierarchical data > > and grouping some columns? I am trying to create a grid showing folders and > > want to group two columns. It does not work. Please let me know if you know > > the trick. Without the grouping, everything > > Thanks in advance! > > > > Nancy > > > > Here's code I have, > > > > <mx:AdvancedDataGrid id="myADG" > > width="100%" height="100%" > > variableRowHeight="true" selectionColor="#AAC5CE" > > initialize="gc.refresh();"> > > <mx:dataProvider> > > <mx:GroupingCollection id="gc" > > source="{serverData}"> > > <mx:grouping> > > <mx:Grouping> > > <mx:GroupingField > > name="Servers"/> > > <mx:GroupingField > > name="Port"/> > > </mx:Grouping> > > </mx:grouping> > > </mx:GroupingCollection> > > </mx:dataProvider> > > > > <mx:columns> > > <mx:AdvancedDataGridColumn > > dataField="Port" headerText="Server/Port"/> > > <mx:AdvancedDataGridColumn > > dataField="VirtualResourceType" headerText="Virtual Type"/> > > <mx:AdvancedDataGridColumn > > dataField="CIR"/> > > <mx:AdvancedDataGridColumn > > dataField="PIR"/> > > <mx:AdvancedDataGridColumnGroup > > headerText="Capacity"> > > AdvancedDataGridColumn > > dataField="Avail"/> > > AdvancedDataGridColumn > > dataField="Total"/> > > </mx:AdvancedDataGridColumnGroup> > > </mx:columns> > > </mx:AdvancedDataGrid> > > >