Grid Collapse Level Order

[costas_ioannou2]

Hi,

I have a Grid with a collapse Level =1; This however messes up the order of the other columns in the query. Is there a way to fix this? For example the first column is customer name and the second is Date. However the date is not in order when I use a collapse level = 1.

Thanks

Edited by: Costas Ioannou on Jun 16, 2009 2:07 PM

[Former Member]

HI,

The grid will be sorted by the collapse level.

if you would like to use more collapse levels (collapse by Customer Code, Date, etc). you should have to write different queries.

Otherwise use order by Customer Name, date in your query when you executing.

Regards,

J.

[costas_ioannou2]

Hi thanks for responding. My point is that when you use collapse levels then the grid ignores any order by statements.