Showing Summary with the Group Node
Posted by: Sameer on: February 13, 2008
- In: Actionscript| Flex
- Comment!
This example shows how AdvancedDataGrid can be configured to show summary with the Group node.
Here, I’m using GroupingCollection to calculate the Summary with summaryPlacement being “group”. Then using groupLabelFunction in AdvancedDataGrid and returning the Group Node’s value plus the Summary value.
Source mxml is located here.
14 Responses to "Showing Summary with the Group Node"
August 4, 2008 at 10:39 am
See if you can get that by using SummaryObjectFunction and SummaryFunction.
November 26, 2008 at 4:52 pm
Hi sameer….
How can u make ur “From” column sort i.e it should sort group also along with flat data.
For quite a while Iam looking for the solution…
Thanks in advance
November 26, 2008 at 9:15 pm
Just make the Grouping label property same as the datafield of the column in which Group nodes are shown.
Create the Grouping as –
<mx:Grouping label="From">
....
November 27, 2008 at 2:48 pm
Hey sameer,
Thanks man it worked my label property was not setting properly.
Now iam able to set it properly and sort it.
December 15, 2008 at 3:46 pm
Thank you for posting the way of configuring it. It is really helpful!
February 4, 2009 at 10:29 am
Hey sameer,
iam using XMLListCollection(searchResultXMLColl) as my FlatDataProvider
here goes the code…
var sumRow:SummaryRow= new SummaryRow();
var sumField1:SummaryField= new SummaryField(‘SPEND_PRE’,'SUM’);
var sumField2:SummaryField= new SummaryField(‘SPEND_CUR’,'SUM’);
gf = new GroupingField();
grp = new Grouping();
gc= new GroupingCollection2();
gc.source = searchResultXMLColl;
sumRow.summaryPlacement=’group’;
sumRow.fields=[sumField1,sumField2];
gf.numeric=true;
gf.name=’DBDUNS_NUM’;
gf.summaries=[sumRow];
grp.fields=[gf];
gc.grouping=grp;
gc.refresh();
adg1.dataProvider=gc
But one problem is like iam not able to calculate Summary?
At the Summary Row it is showing 0
earlier when I was using ArrayCollection as a source It was giving me accurate total.
I am also using Itemrenderer(LinkButton) on my first column of dataGrid.The link button was coming fine and also the summary when the groupingCollection’s source was ArrayCollection
But now iam not getting any summary except 0 and Itemrenderer is ignored and a simple text been diplayed at the first column.
February 4, 2009 at 2:33 pm
Can you send a simple sample or the sample xml which shows this issue?
March 4, 2009 at 5:52 am
Good work Sameer.. , was very much handy in time..
Thanks,
Shankar.
April 23, 2009 at 2:58 am
How to set the background color for root node
April 26, 2009 at 4:22 pm
You need to set the background property to true in the UITextField which is used in the AdvancedDataGridGroupItemRenderer and then set the backgroundColor property.
Extend AdvancedDataGridGroupItemRenderer, override createLabel() method and set these properties to the label UITextField.
September 4, 2009 at 10:52 pm
Great example of the operation=”COUNT” function. There are almost no examples in the Flex documentation.
Thank you!
Jonathan
September 25, 2009 at 10:38 am
If it is with the HierarchicalData how can we reach this approch?
below is the example of my code..
.myCPStyle {
background-color:#D6C097, #E7D2A7;
openIcon: Embed(source=”upArrow.png”);
closedIcon: Embed(source=”downArrow.png”);
}
September 26, 2009 at 10:42 am
Do you already have Hierarchical data and want to add summaries to it? Well summaries are only supported if GroupingCollection is used.
Well, somehow your code couldn’t make it through. Can you try again.
FeedBurner
August 3, 2008 at 10:09 pm
sameer,
i am trying to build a report using ADG and i have a scenario where i have to show another columns value on the summary.
example
id name age dept
1 x 30 Sales
2 y 20 Sales
3 z 25 Sales
4 x1 30 HR
5 y1 20 HR
6 z1 25 HR
i have to group the data by dept and i have to show the min age, that is fine…. but just next to min age how can i show the persons name who has the minimum age.