How to view data in Microsoft Hierarchical Flexigrid Control?

[pna3]

I need some data to be viewed on the screen thru Microsoft Hierarchical Flexigrid Control.
I am writing the following code:

Set rstRPCAhmReport = Nothing
rstRPCAhmReport.Open "set dateformat dmy select iSerialNumber,cRegion,cRPC,dDateofReporting,cAccountNumber,cCustomerName,iChqTranAmount,iODAmount,vReasonforOD,cFinacleTranNumber,dFinacleTranDate,iTATforTODReporting,cTeam,cLoginID,cUsername,cSOLID,dDGMApproval,cDelayinReporting,iActualTAT,cFinacleMaker,cFinacleChecker from TOD where cRPC='" & frmTODUserLogin.strRPC & "'", conRPCAhmReport, adOpenDynamic, adLockBatchOptimistic

On executing the above code, I only get to view the Microsoft Hierarchical Flexigrid Control with one blank row.

how do i get the records from the Recordset on to each row in the Microsoft Hierarchical Flexigrid Control?

Please help. Very Very Very URGENT!

 

[zemp]

Is your grid bound or unbound? If it is bound, how are you binding it? Are you using a data control or ADO data control? Post the code that you use to bind the recordset to the grid.

Take Care,

zemp

"If the grass looks greener... it's probably because there is more manure."