problems to sort recordes in a report!!!!

  • Thread starter Thread starter geo
  • Start date Start date
G

geo

i have a report which pulls out data from a query with
serveral tables behind. this query is ordered by Column
A, then B and then C. No problems with the sort of this
query. But when displayed on the report, it wouldn't be
sorted by the specified order (although i have OrderByOn
and OrderBy defined)..

any suggestions??????????????/

Thanks.
 
i have a report which pulls out data from a query with
serveral tables behind. this query is ordered by Column
A, then B and then C. No problems with the sort of this
query. But when displayed on the report, it wouldn't be
sorted by the specified order (although i have OrderByOn
and OrderBy defined).
Click to expand...


Using Order By in a report's record source query is a waste
of resources for all but the most trivial reports. The
report's OrderBy property is only sligtly more useful. The
key to your question it that the report's Sorting and
Grouping take precedence over both those other aorting
mechanisms.

To get your report sorted the way you want, try either
adding three (more?) levels to Sorting and Grouping, one
each for numeric fields A, B, and C. Or add one level with
an expression like: =A & "~" & B & "~" & C if the fields
are related text fields such as last, first and middle
names.
 
While in design view of your report, from the tool bar select "sorting and grouping button
input the sort order there. I would also set orderby to NO and NOT define orderby
I have always used the sorting and grouping, and so far it has not failed me.
 
Back
Top