AdvancedDataGrid问题

[水中影子]

101 右边（表格第二列）Territory_Rep列，填充数据源的值

空白一片很难看。

[Bindable]
			private var dpFlat:ArrayCollection = new ArrayCollection([
				{fCode:"101", fParent:" ", 
					Territory_Rep:"Barbara Jennings", Actual:38865, Estimate:40000}, 
				{fCode:"10101", fParent:"101", 
					Territory_Rep:"Dana Binn", Actual:29885, Estimate:30000},  
				{fCode:"10102", fParent:"101", 
					Territory_Rep:"Joe Smith", Actual:29134, Estimate:30000},  
				{fCode:"201", fParent:" ", 
					Territory_Rep:"Bethany Pittman", Actual:52888, Estimate:45000},  
				{fCode:"20101", fParent:"201", 
					Territory_Rep:"Lauren Ipsum", Actual:38805, Estimate:40000}, 
				{fCode:"20102", fParent:"201", 
					Territory_Rep:"T.R. Smith", Actual:55498, Estimate:40000},  
				{fCode:"301", fParent:" ", 
					Territory_Rep:"Alice Treu", Actual:44985, Estimate:45000}, 
				{fCode:"401", fParent:" ", 
					Territory_Rep:"Jane Grove", Actual:44913, Estimate:45000}
			]);

期待高手！！！

[aseer]

不然你想怎样？

[水中影子]

[Quote=引用 1 楼 aseer 的回复:]

不然你想怎样？
[/Quote]
fcode Territory_Rep ...
我想填充数据，---------------------------
101 Barbara Jennings
10101 Dana Binn

[水中影子]

测试代码

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute">
	<mx:AdvancedDataGrid x="10" y="10" id="adg1" designViewDataType="tree" width="522" height="322"
						 creationComplete="gc.refresh();" headerSortSeparatorSkin="mx.skins.ProgrammaticSkin">
		<mx:dataProvider>
			<mx:GroupingCollection id="gc" source="{dpFlat}">
				<mx:Grouping>
					<mx:GroupingField name="fParent" descending="false">                      	
						<mx:summaries>      		
							<mx:SummaryRow summaryPlacement="group">
								<mx:fields>
									<mx:SummaryField dataField="Actual" operation="SUM" label="Actual"/>
									<mx:SummaryField dataField="Estimate" operation="SUM" label="Estimate"/>
								</mx:fields>
							</mx:SummaryRow>
						</mx:summaries>
					</mx:GroupingField>
				</mx:Grouping>
			</mx:GroupingCollection>
		</mx:dataProvider> 
		<mx:groupedColumns>
			<mx:AdvancedDataGridColumn headerText="fCode" dataField="fCode"/>
			<mx:AdvancedDataGridColumn headerText="Territory_Rep" dataField="Territory_Rep"/>
			<mx:AdvancedDataGridColumnGroup headerText="组合">
				<mx:AdvancedDataGridColumn headerText="Actual" dataField="Actual"/>
				<mx:AdvancedDataGridColumn headerText="Estimate" dataField="Estimate"/>
			</mx:AdvancedDataGridColumnGroup>	
		</mx:groupedColumns>
		
	</mx:AdvancedDataGrid>
	
	<mx:Script>
		<![CDATA[
			import mx.charts.ColumnChart;
			import mx.charts.series.ColumnSeries;
			import mx.collections.ArrayCollection;
			import mx.collections.GroupingField;
			
			[Bindable]
			private var dpFlat:ArrayCollection = new ArrayCollection([
				{fCode:"101", fParent:" ", 
					Territory_Rep:"Barbara Jennings", Actual:38865, Estimate:40000}, 
				{fCode:"10101", fParent:"101", 
					Territory_Rep:"Dana Binn", Actual:29885, Estimate:30000},  
				{fCode:"10102", fParent:"101", 
					Territory_Rep:"Joe Smith", Actual:29134, Estimate:30000},  
				{fCode:"201", fParent:" ", 
					Territory_Rep:"Bethany Pittman", Actual:52888, Estimate:45000},  
				{fCode:"20101", fParent:"201", 
					Territory_Rep:"Lauren Ipsum", Actual:38805, Estimate:40000}, 
				{fCode:"20102", fParent:"201", 
					Territory_Rep:"T.R. Smith", Actual:55498, Estimate:40000},  
				{fCode:"301", fParent:" ", 
					Territory_Rep:"Alice Treu", Actual:44985, Estimate:45000}, 
				{fCode:"401", fParent:" ", 
					Territory_Rep:"Jane Grove", Actual:44913, Estimate:45000}
			]);
			
			private function gf(item:Object, field:GroupingField):String{
				return item[field.name];
				
			}
		]]>
	</mx:Script>
	
</mx:Application>

[leemiki]

代码都没问题，改下dpflat的即可

private var dpFlat:ArrayCollection = new ArrayCollection([
{fCode:"101", fParent:" 根目录",
Territory_Rep:"Barbara Jennings", Actual:38865, Estimate:40000},
{fCode:"10101", fParent:"101",
Territory_Rep:"Dana Binn", Actual:29885, Estimate:30000},
{fCode:"10102", fParent:"101",
Territory_Rep:"Joe Smith", Actual:29134, Estimate:30000},
{fCode:"201", fParent:" 根目录",
Territory_Rep:"Bethany Pittman", Actual:52888, Estimate:45000},
{fCode:"20101", fParent:"201",
Territory_Rep:"Lauren Ipsum", Actual:38805, Estimate:40000},
{fCode:"20102", fParent:"201",
Territory_Rep:"T.R. Smith", Actual:55498, Estimate:40000},
{fCode:"301", fParent:" 根目录",
Territory_Rep:"Alice Treu", Actual:44985, Estimate:45000},
{fCode:"401", fParent:" 根目录",
Territory_Rep:"Jane Grove", Actual:44913, Estimate:45000}
]);

楼主看到这结果是不是会比较郁闷呢！

居然怎么简单，O(∩_∩)O哈哈~

[leemiki]

。。。。

我好像看错了，Territory_Rep列

GroupingCollection分组，类似于一个根节点，一般情况下确实是显示不了那个字段的

[leemiki]

试试这种方式布局，跟你要的效果应该差不多了，你重写下方法应该就可以了

<mx:SummaryRow summaryPlacement="group">
<mx:fields>
<mx:SummaryField dataField="Territory_Rep" summaryFunction="mySummaryFunction" label="Territory_Rep"/>
</mx:fields>
</mx:SummaryRow>
<mx:SummaryRow summaryPlacement="group">
<mx:fields>
<mx:SummaryField dataField="Actual" operation="SUM" label="Actual"/>
<mx:SummaryField dataField="Estimate" operation="SUM" label="Estimate"/>
</mx:fields>
</mx:SummaryRow>

[水中影子]

呵呵！自己解决了 O(∩_∩)O哈哈~

直接改变数据源 用XML作为数据源，不用ArrayCollection

（郁闷(+﹏+)~狂晕）