I am populating advanceDataGrid (Flex 3) from salesforce query. I want to show parent-child relationship in the grid.

The problem is that, when i am iterating the queryresult object in the for loop and dumping in the arraycollection object, it only adds those records into the Array , that has chidren in it.Otherwise , it is exiting the loop.

for example , if first record has a child then, it adds it into the array collection object  and goes to second iteration i.e i=1.When it sees that second parent record doesn't have any child in it then it exist the loop and bind the advance datagrid with only one record.Although , the queryresult has 8 parent rows in it.
When i apply this check around the addition process of records into the arraycollection object :

}

After applying the above if {} check ,it starts adding the rows in it but only those rows that has Children.But it didn't show the children records in the Grid.Now it shows only Parent Records without children .

I need to display those   Records that don't have any Children as well as those that have Children associated to it in the advance datagrid.So that , the rows with children records , user can expand the node to see its children.With rows no folder sign , the user will come to know that this row doesn't have any child rows.

Here is my code :

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

<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute"

themeColor="#E7ECEF" cornerRadius="3">

<salesforce:Connection id="force" />

<mx:Script >

<![CDATA[

 //import statements here

//Declaration

private var objSprint:Object;

private var tempSprint:ArrayCollection=new ArrayCollection();

 //Code here

{

force.login(lr);

force.login(lr);

}

{

force.query("Select id ,Name,RecS__Product_Name__c from RecS__Product_Backlog__c ",

new AsyncResponder(function(result:QueryResult):void

{

ddlBack.addItem({Id:result.records[i].Id,RecS__Product_Name__c :result.records[i].RecS__Product_Name__c,SObjectField:result.records[i]});

}

}));

}

private function populateGrid(result:LoginResult):void{

force.query("Select r.Id, r.Name,r.RecS__Sprint_Name__c, r.RecS__Start_Date__c, r.RecS__Status__c, (Select Id,"+

" Name, "RecS__Feature_Name__c, RecS__Product_Backlog__c,  RecS__Sprint__c, RecS__Start_Date__c  From "+ 

" and RecS__Sprint__c <> null) from RecS__Sprint__c r",new AsyncResponder(function(qrSp:QueryResult):void

{

gdSprint=qrSp.records;

{

lbl.text+= qrSp.records[k].RecS__Features__r.records.length; 

if(qrSp.records[k].RecS__Features__r != null){
tempSprint.addItem({RecS__Sprint_Name__c :qrSp.records[k].RecS__Sprint_Name__c,

objSprint =Object(tempSprint);

}));

}

]]>

paddingTop="10" paddingLeft="10" paddingRight="10" height="554" width="505" x="416" y="44">

<mx:AdvancedDataGrid id="gridSprint" designViewDataType="tree" width="419" height="451">

<mx:dataProvider> 

</mx:dataProvider> 

<mx:AdvancedDataGridColumn headerText="Sprint" fontStyle="normal" fontWeight="bold" dataField="RecS__Sprint_Name__c">

<mx:AdvancedDataGridColumn headerText="St. Date" dataField="RecS__Start_Date__c"/>

<mx:AdvancedDataGridColumn headerText="Id" visible="false" dataField="Id"/>

</mx:AdvancedDataGrid>

</mx:Panel>

</mx:Application>

Please can any one help me ... it is driving me crazy ....