Home Tutorial Flex Flex4 Components Displaying grouped data in AdvancedDataGrid

 
 

Displaying grouped data in AdvancedDataGrid
Posted on: June 17, 2010 at 12:00 AM
Grouped data is used the place of hierarchical data. Basically it is a flat data in which you can arrange it in hierarchical data.

Displaying grouped data in AdvancedDataGrid:

Grouped data is used the place of hierarchical data. Basically it is a flat data in which you can arrange it  in hierarchical data. We make a instance of the GroupingCollection2 class from your flat data. In this example you can see how we can use Grouped Data in AdvancedDataGrid control.

Example:

<?xml version="1.0" encoding="utf-8"?>

<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"

xmlns:s="library://ns.adobe.com/flex/spark"

xmlns:mx="library://ns.adobe.com/flex/mx"

minWidth="955" minHeight="600">

<fx:Script>

<![CDATA[

import mx.collections.ArrayCollection;

[Bindable]

private var student:ArrayCollection = new ArrayCollection([

{Course:'Course', CourseName:'B.Sc.', Branch:'Physics', Girls:60, Boys:120, TotalStudent:180,

 PASSinper:98.0, FAILinper:2.0},

{Course:'Course', CourseName:'B.Sc.', Branch:'Mathematics', Girls:50, Boys:150,

 TotalStudent:200, PASSinper:98.5, FAILinper:1.5},

{Course:'Course', CourseName:'B.Sc.', Branch:'Chemistry', Girls:100, Boys:50,

 TotalStudent:150, PASSinper:97.0, FAILinper:3.0},

{Course:'Course', CourseName:'B.tech.', Branch:'CS', Girls: 45, Boys:75, TotalStudent:120,

 PASSinper:99.0, FAILinper:1.0},

{Course:'Course', CourseName:'B.tech.', Branch:'IT', Girls: 55, Boys:65, TotalStudent:120,

 PASSinper:99.5, FAILinper:0.5},

{Course:'Course', CourseName:'B.tech.', Branch:'EC', Girls: 25, Boys:95, TotalStudent:120,

 PASSinper:96.7, FAILinper:3.3},

{Course:'Course', CourseName:'B.tech.', Branch:'EI', Girls: 40, Boys:80, TotalStudent:120,

PASSinper:95, FAILinper:5},

{Course:'Course', CourseName:'B.tech.', Branch:'Mechanical', Girls:10, Boys: 80,

 TotalStudent:90, PASSinper:97.5, FAILinper:2.5},

{Course:'Course', CourseName:'B.tech.', Branch:'Civil', Girls: 15, Boys:45, TotalStudent:60,

 PASSinper:92, FAILinper:8},

{Course:'Course', CourseName:'B.Pharma.', Branch:'Pharmacy', Girls:70, Boys:130,

 TotalStudent:200, PASSinper:99.8, FAILinper:0.2},

{Course:'Course', CourseName:'M.B.A.', Branch:'HR', Girls:48, Boys:72, TotalStudent:120,

 PASSinper:100, FAILinper:0},

{Course:'Course', CourseName:'M.B.A.', Branch:'Finance', Girls:40, Boys:80, TotalStudent:120, PASSinper:85, FAILinper:15},

{Course:'Course', CourseName:'M.B.A.', Branch:'Marketing', Girls:20, Boys:100,

 TotalStudent:120, PASSinper:99, FAILinper:1},

{Course:'Course', CourseName:'M.B.A.', Branch:'IT & HR', Girls:30, Boys:90, TotalStudent:120,

 PASSinper:100, FAILinper:0},

{Course:'Course', CourseName:'M.C.A.', Branch:'Computer Science', Girls:30, Boys:90,

 TotalStudent: 120, PASSinper:99.1, FAILinper:0.9},

]);

]]>

</fx:Script>

<s:Panel title="Displaying grouped data in AdvancedDataGrid" height="470" width="831">

<mx:AdvancedDataGrid

height="414"

x="13" y="13" initialize="gc2.refresh();">

<mx:dataProvider>

<mx:GroupingCollection2 id="gc2" source="{student}">

<mx:Grouping label="Course">

<mx:GroupingField name="Course"/>

<mx:GroupingField name="CourseName"/>

</mx:Grouping>

</mx:GroupingCollection2>

</mx:dataProvider>

<mx:columns>

<mx:AdvancedDataGridColumn dataField="Course"/>

<mx:AdvancedDataGridColumn dataField="CourseName" headerText="CourseName"/>

<mx:AdvancedDataGridColumn dataField="Branch"/>

<mx:AdvancedDataGridColumn dataField="Girls"/>

<mx:AdvancedDataGridColumn dataField="Boys"/>

<mx:AdvancedDataGridColumn dataField="TotalStudent"/>

<mx:AdvancedDataGridColumn dataField="PASSinper"/>

<mx:AdvancedDataGridColumn dataField="FAILinper"/>

</mx:columns>

</mx:AdvancedDataGrid>

</s:Panel>

</s:Application>

Output:

Running Application:

To view this page ensure that Adobe Flash Player version 10.0.0 or greater is installed.

Download this code

Related Tags for Displaying grouped data in AdvancedDataGrid:


Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.