StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I solved the problem, I am attaching the code for someone to refer in future </p> <p>[Application mxml]</p> <pre><code><?xml version="1.0" encoding="utf-8"?> <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="vertical"> <mx:Script> <![CDATA[ import mx.collections.HierarchicalData; private var masterData:Array = [ { OrderId: 10248, CustomerId:"WILMK", EmployeeId:5, OrderDate:"1-Feb-2007", children:[ [ {ProductId:11, ProductName:"Quesbo Cabrales", UnitPrice:14, Quantity:12, Discount:0, Price:168, children:[[{count:"28",place:"HYD",Amount:"1234"},{count:"28",place:"HYD",Amount:"1234"}]]}, {ProductId:42, ProductName:"Singaporean Hokkien Fried Mee", UnitPrice:9.8, Quantity:10, Discount:0, Price:98, children:[[{count:"28",place:"HYD",Amount:"1234"},{count:"28",place:"HYD",Amount:"1234"}]]}, {ProductId:42, ProductName:"Mozzarella di Giovanni", UnitPrice:34.8, Quantity:5, Discount:0, Price:174, children:[[{count:"28",place:"HYD",Amount:"1234"},{count:"28",place:"HYD",Amount:"1234"}]]} ] ]}, { OrderId: 10249, CustomerId:"TRADH", EmployeeId:6, OrderDate:"3-Feb-2007", children:[ [ {ProductId:51, ProductName:"Manjimup Dried Appels", UnitPrice:42.4, Quantity:40, Discount:0, Price:1696, children:[[{count:"28",place:"HYD",Amount:"1234"},{count:"28",place:"HYD",Amount:"1234"}]]}, {ProductId:14, ProductName:"Tofu", UnitPrice:18.6, Quantity:9, Discount:0, Price:167.4, children:[[{count:"28",place:"HYD",Amount:"1234"},{count:"28",place:"HYD",Amount:"1234"}]]} ] ]}, { OrderId: 10250, CustomerId:"HANAR", EmployeeId:4, OrderDate:"4-Feb-2007", children:[ [ {ProductId:51, ProductName:"Manjimup Dried Appels", UnitPrice:42.4, Quantity:35, Discount:0.15, Price:1261, children:[[{count:"28",place:"HYD",Amount:"1234"},{count:"28",place:"HYD",Amount:"1234"}]]}, {ProductId:41, ProductName:"Jack's Clam Chowder", UnitPrice:7.7, Quantity:10, Discount:0, Price:77, children:[[{count:"28",place:"HYD",Amount:"1234"},{count:"28",place:"HYD",Amount:"1234"}]]}, {ProductId:65, ProductName:"Hot pepper Sauce", UnitPrice:16.8, Quantity:10, Discount:0.15, Price:214.2, children:[[{count:"28",place:"HYD",Amount:"1234"},{count:"28",place:"HYD",Amount:"1234"}]]} ] ]} ]; ]]> </mx:Script> <mx:AdvancedDataGrid dataProvider="{new HierarchicalData(masterData)}" variableRowHeight="true" width="600" height="600"> <mx:columns> <mx:AdvancedDataGridColumn dataField="OrderId" headerText="Ordere ID" width="100"/> <mx:AdvancedDataGridColumn dataField="CustomerId" headerText="Customer ID" /> <mx:AdvancedDataGridColumn dataField="EmployeeId" headerText="Employee ID" /> <mx:AdvancedDataGridColumn dataField="OrderDate" headerText="Order Date" /> </mx:columns> <mx:rendererProviders> <mx:AdvancedDataGridRendererProvider depth="2" columnIndex="1" renderer="DetailGrid" columnSpan="0" /> </mx:rendererProviders> </mx:AdvancedDataGrid> </mx:Application> </code></pre> <p>[DetailGrid.mxml]</p> <pre><code><?xml version="1.0" encoding="utf-8"?> <mx:AdvancedDataGrid xmlns="*" variableRowHeight="true" xmlns:mx="http://www.adobe.com/2006/mxml"> <mx:Script> <![CDATA[ import mx.collections.HierarchicalData; override public function set data(value:Object):void { dataProvider=new HierarchicalData(value); this.rowCount = value.length+5; // dataProvider = value; } ]]> </mx:Script> <mx:columns> <mx:AdvancedDataGridColumn dataField="ProductId" headerText="Product ID" /> <mx:AdvancedDataGridColumn dataField="ProductName" headerText="Product Name" /> <mx:AdvancedDataGridColumn dataField="UnitPrice" /> <mx:AdvancedDataGridColumn dataField="Discount" /> <mx:AdvancedDataGridColumn dataField="Price" /> </mx:columns> <mx:rendererProviders> <mx:AdvancedDataGridRendererProvider depth="2" columnIndex="1" renderer="InnerDetailGrid" columnSpan="5" /> </mx:rendererProviders> </mx:AdvancedDataGrid> </code></pre> <p>[InnerDetailGrid.mxml]</p> <pre><code><?xml version="1.0" encoding="utf-8"?> <mx:AdvancedDataGrid xmlns="*" xmlns:mx="http://www.adobe.com/2006/mxml"> <mx:Script> <![CDATA[ override public function set data(value:Object):void { dataProvider = value; this.rowCount = value.length+1; } ]]> </mx:Script> <mx:columns> <mx:AdvancedDataGridColumn dataField="count" headerText="count" /> <mx:AdvancedDataGridColumn dataField="place" headerText="place" /> <mx:AdvancedDataGridColumn dataField="Amount" headerText="Amount" /> </mx:columns> </mx:AdvancedDataGrid> </code></pre> <p>Here is the final o/p</p> <p><img src="https://i.stack.imgur.com/gyBQJ.png" alt="enter image description here"></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload