Hello,

I am creating a report with VS, I provide it with a query that is
sorted. When the report is previewed it is in the wrong sort order.
Example: first column is Month-YYYY and is a colapsable column and
underneath it is all the dates belonging to the Month-YYYY. The report
previewer displays the data as
July-2005
..... < date detail>
June-2005
May-2005
Oct-2005
it should be:
May-2005
June-2005
Jul-2005
Oct-2005

It seems the report builder is not grouping the data base on the result
set, but rather re-sorting.

Any solutions to this problem?

Thanks in advance!

Hi,

You should take a deeper look in to the definition of your report.
It has some where default sort. Your result is sorted on month name (J, J,
M, O) instead of month number (5,6, 7, 10).

Thanks,
Vladimir Chtepa

"devdewboy" <devdewboy (AT) hotmail (DOT) com> wrote