Posted on: June 16, 2010 at 12:00 AM
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:AdvancedDataGridsortExpertMode=" 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.
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.
