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.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.
<?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> |
To view this page ensure that Adobe Flash Player version 10.0.0 or greater is installed.