I am trying to display a report in the grid having set Colapse level = 2. The query that is fetching the records is bringing the data correctly with the group total shown as 'TOTAL' titled row in the last row of every group. But when it fills the grid then 'TOTAL' titled row is not coming at its expected position. Either it is coming in the mid of the rows or, as first row. Seldom it comes as last row of the group. If i remove the setted Collapse Level, then the grid results are fine.
Thnx in advance,