Access report quirk

[a a r o n . k e m p f]

wow, if Jet isn't reliable and consistent for you- then move to SQL
Server

_ESPECIALLY_ for reports

-Aaron

 

[fredg]

I have an access report that for some reason does not obey the sort order in
either an attached query or in the properties sort order override box. What
are the possible reasons for this behavior?

"Does not obey" doesn't tell us much.
What does your report data look like?
How should it look?
What is the data datatype?
Are you aware that the report sort order should be set in the report's
Sorting and Grouping dialog, not in the query?
Click on View + Sorting and Grouping

 

[John Spencer (MVP)]

Sort order for reports is determined using the View: Sorting And Grouping
dialog from the menubar. The sorting in a query is ignored by the report.

As for the order by property for a report, I have to admit I've never tried to
use it.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Ken Sheridan]

Like in a form, to implement the OrderBy property its necessary to set the
OrderByOn property to True, which can be done in the report's Open event
procedure. I've occasionally used it with simple reports to enable the user
to control the sort order, but generally the sorting and grouping mechanism
is a better bet.

Ken Sheridan
Stafford, England

 

[Neil Gould]

I have an access report that for some reason does not obey the sort order in
either an attached query or in the properties sort order override box. What
are the possible reasons for this behavior?

 

[John W. Vinson]

I have an access report that for some reason does not obey the sort order in
either an attached query or in the properties sort order override box. What
are the possible reasons for this behavior?

That's by design. A Report has a Sorting and Grouping property, which controls
the sort order of the display; it ignores the sort order of the query.

 

[Trek]

Extremely lame answer, to deploy expensive licenses of SQL server only
because of just not working sorting in a report, that can be easily changed.
You don't have much experience with various projects, so it is only excuse
for you.

"a a r o n . k e m p f @ g m a i l . c o m" <[email protected]> píse v
diskusním príspevku
wow, if Jet isn't reliable and consistent for you- then move to SQL
Server

_ESPECIALLY_ for reports

-Aaron

 

[Tony Toews [MVP]]

Extremely lame answer, to deploy expensive licenses of SQL server only
because of just not working sorting in a report, that can be easily changed.
You don't have much experience with various projects, so it is only excuse
for you.

Very nice answer. Thank you!!!

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/