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,
Which version are you working with?
It only happens with a specific query?
I never saw that before, usually the order of the columns is the order in the SQL query passed to the DataTable, independently of the Collapse level.
Maybe you can share with as your query.
If you are using 2005 SP01 version you can easily test it with the ScreenPainter.