Sort a Grid while using CollapseLevel


Sort a Grid while using CollapseLevel
I'm using a Grid with data that I need sorted.  I can use the SQL statement to sort the data how I need it.  But I would also like to use CollapseLevel.  When I do that my data gets scrambled.  Have any of you found a work around for this?
I´m sorry to tell that there are no good news. The Grid object hasn´t any Ordering functionallity nowadays, and the only way to get that is to execute the SQL statement again. As Grid object needs the format to be designed each time new data is entered, you will have to do it each time the sorting is done.
Ibai Peñ
Read More: The other 2 answers