The sort order of a report may be different in Access 2010 than when the report is opened in a web browser on a server that is running Access Services in SharePoint Server 2010

Article translations Article translations
Close Close
Article ID: 982783 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

Consider the following scenario:
  • You publish a Microsoft Access 2010 database to a server that is running Access Services in Microsoft SharePoint Server 2010.
  • The database contains the following items:
    • A table with a numeric field.
    • A query that is based on the table and that is sorted by the numeric field.
    • A report that is based on the query.
  • You open the report in your web browser.
In this scenario, the sort order of the report is expected. However, when you open the report in Access 2010, the sort order of the report may be different.

Note This issue may also occur when the report is based on the table.

CAUSE

This issue occurs because Access 2010 does not maintain the sort order of the report.

WORKAROUND

To work around this issue, use the Order By property to obtain the desired sort order.

Properties

Article ID: 982783 - Last Review: September 17, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft SharePoint Server 2010
  • Microsoft Access 2010
Keywords: 
kbtshoot kbexpertiseinter kbsurveynew kbprb KB982783

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com