DataFormatter in Column in AdvancedDataGrid


 

DataFormatter in Column in AdvancedDataGrid

In this example you can see how we can use a dataFormatter in AdvancedDataGrid.

In this example you can see how we can use a dataFormatter in AdvancedDataGrid.

DataFormatter in Column in AdvancedDataGrid:

In this example you can see how we can use a dataFormatter in AdvancedDataGrid.
In this example we use a TotalFine column and use a CurrencyFormatter for providing a actual format of currency.

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", categories: [

{Course:"B.Sc.", categories:[

{Branch:"Physics", Girls:60, Boys:120, TotalStudent:180, PASSinper:98.0, FAILinper:2.0,

 TotalFine:11000},

{Branch:"Chemistry", Girls:100, Boys:50, TotalStudent:150, PASSinper:97.0, FAILinper:3.0,

 TotalFine:12000},

{Branch:"Mathematics", Girls:50, Boys:150, TotalStudent:200, PASSinper:98.5, FAILinper:1.5,

 TotalFine:12500}]},

{Course:"B.tech.", categories:[

{Branch:"CS", Girls: 45, Boys:75, TotalStudent:120, PASSinper:99.0, FAILinper:1.0,

 TotalFine:10000},

{Branch:"IT", Girls: 55, Boys:65, TotalStudent:120, PASSinper:99.5, FAILinper:0.5,

 TotalFine:15000},

{Branch:"EC", Girls: 25, Boys:95, TotalStudent:120, PASSinper:96.7, FAILinper:3.3,

 TotalFine:9000},

{Branch:"EI", Girls: 40, Boys:80, TotalStudent:120, PASSinper:95, FAILinper:5, TotalFine:8500},

{Branch:"Mechanical", Girls:10, Boys: 80, TotalStudent:90, PASSinper:97.5, FAILinper:2.5,

 TotalFine:8000},

{Branch:"Civil", Girls: 15, Boys:45, TotalStudent:60, PASSinper:92, FAILinper:8, TotalFine:12000

}]},

{Course:"B.Pharma.", categories:[

{Branch:"Pharmacy", Girls:70, Boys:130, TotalStudent:200, PASSinper:99.8, FAILinper:0.2,

 TotalFine:10000}]},

{Course:"M.B.A.", categories:[

{Branch:'HR', Girls:48, Boys:72, TotalStudent:120, PASSinper:100, FAILinper:0, TotalFine:10500},

{Branch:'Finance', Girls:40, Boys:80, TotalStudent:120, PASSinper:85, FAILinper:15,

 TotalFine:12500},

{Branch:'Marketing', Girls:20, Boys:100, TotalStudent:120, PASSinper:99, FAILinper:1,

 TotalFine:15500},

{Branch:'IT & HR', Girls:30, Boys:90, TotalStudent:120, PASSinper:100, FAILinper:0,

 TotalFine:6000}]},

{Course:"M.C.A.", categories:[

{Branch:"Computer Science", Girls:30, Boys:90, TotalStudent: 120, PASSinper:99.1,

 FAILinper:0.9, TotalFine:10000}]}

]}

]);

]]>

</fx:Script>

<s:Panel title="Data Formatter in Column in AdvancedDataGrid" height="419" width="728">

<mx:AdvancedDataGrid

sortExpertMode="true"

height="363"

x="13" y="13"

width="703">

<mx:dataProvider>

<mx:HierarchicalData source="{student}" childrenField="categories"/>

</mx:dataProvider>

<mx:columns>

<mx:AdvancedDataGridColumn dataField="Course"/>

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

<mx:AdvancedDataGridColumn dataField="Girls"/>

<mx:AdvancedDataGridColumn dataField="Boys"/>

<mx:AdvancedDataGridColumn dataField="TotalStudent"/>

<mx:AdvancedDataGridColumn dataField="PASSinper"/>

<mx:AdvancedDataGridColumn dataField="FAILinper"/>

<mx:AdvancedDataGridColumn dataField="TotalFine">

<mx:formatter>

<mx:CurrencyFormatter currencySymbol="Rs" useThousandsSeparator="true"/>

</mx:formatter>

</mx:AdvancedDataGridColumn>

</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

Ads