By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,175 Members | 1,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,175 IT Pros & Developers. It's quick & easy.

sorting difference query-report

P: n/a
I have this weird sorting problem. I have a report that is based on a
query. The query is sorted on field A, and if I run it seperately it
is decently sorted on that field. However, if I call the report, it is
sorted on field B. I am not using the "Order by"-property of the
report; in fact, if I say "Field A" in it, the report is STILL sorted
on field B.

Any suggestions?
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Have a look at Sorting and Grouping. This is located under the View menu or
click the icon to the right of the hammer and spanner icon on the toolbar.

Stewart

"Jur Schagen" <ju********@hotmail.com> wrote in message
news:84**************************@posting.google.c om...
I have this weird sorting problem. I have a report that is based on a
query. The query is sorted on field A, and if I run it seperately it
is decently sorted on that field. However, if I call the report, it is
sorted on field B. I am not using the "Order by"-property of the
report; in fact, if I say "Field A" in it, the report is STILL sorted
on field B.

Any suggestions?

Nov 12 '05 #2

P: n/a
Stewart Allen wrote:
Have a look at Sorting and Grouping. This is located under the View menu or
click the icon to the right of the hammer and spanner icon on the toolbar.

Stewart

And be aware that for a report a new (temporary) query is created.
Sorting the source query wastes time.
--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.