Abdul-
Further comments: The data you're displaying will, of necessity, be sorted by OrderID to honor the grouping criteria. If there is related detail data, it will by default be sorted by the Primary Key of the table in which it resides. As noted below, if you want some other sequence, you have to define it. I would be there's a descending key defined on the table containing the data that you don't want sorted.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Tuesday, November 01, 2011 8:36 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Report Sort Problem
Abdul-
Not possible. In the absence of any sorting criteria, the sequence in which the rows get returned is undefined. Somehow the report engine has decided that sorting descending is the most efficient way to fetch the data. If you want some other sequence, you have to override it with sorting criteria.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Abdul Shakeel
Sent: Tuesday, November 01, 2011 8:28 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Report Sort Problem
Dear john
Yes I do have grouping on OrderID, but I dont want any sort order in my report, I want that as the data enter on my form it should be reflected as it is on the report
Thanks & Regards,
--
Abdul Shakeel
________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, November 1, 2011 12:21 PM
Subject: RE: [MS_AccessPros] Report Sort Problem
Abdul-
Do you have any Grouping defined in the report? Would you prefer that the data
sort ascending? The Access report engine builds its own query to try to most
efficiently fetch the data required, and it may apply a sort. If you want the
data sorted some other way, you have to specify it.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Abdul Shakeel
Sent: Tuesday, November 01, 2011 7:43 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Report Sort Problem
Dear All,
I have made a report based on a query, the report have not any sort order
neither the query but, when I preview the report, its detail section is sort
descending, how I remove this sort order.
Thanks & Regards,
--
Abdul Shakeel
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar