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 [email protected], "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 [email protected], 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>
> >
>
