I have a problem with a report in vdb7 where the report shows the rowsets in a different order than the querry.

I want the report to show the grouped rowsets in descending order within the groups. The querry is by design in such an order but the report shuffles this order so that the order within each group seem to be arbitrary.

If I omit the grouping the rowsets are shown in the correct order in the report.

I have even tried this with a simble database with fields (nr1 and nr2) numeric, ascending index order on nr1 and values (1 1) (1 2) (1 3) (1 4) (2 1) (2 2) (2 3) (2 4) (3 1) (3 2) (3 3)

the report grouped on nr1 gives a result with the following order

1 2
3
4
1
2 1
2
3
4
3 3
4
1
2

What can be done to get the values of nr2 in ascending or decending order.