Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

ACC2000: Can't Use Client-Side Filtering in an ADP Report with Grouping

View products that this article applies to.

This article was previously published under Q212749
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

↑ Back to the top


When you open a report in a Microsoft Access project that uses both grouping and client-side filtering (the Filter property), the report returns no data, or you may receive the following error messages
The bookmark was invalid.
followed by:
IRowsOffset would position you past either end of the rowset, regardless of cRows value specified; cRowsObtained is 0.

↑ Back to the top


To successfully create a report that implements both grouping and filtering, use the ServerFilter property instead of the Filter property.

↑ Back to the top


Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

More information

Steps to Reproduce Problem

  1. Open the sample Access project NorthwindCS.adp.
  2. In the Database window, click Tables under Objects, and then click the Categories table.
  3. On the Insert menu, click AutoReport.
  4. After the report is generated, open it in Design View.
  5. On the View menu, click Sorting and Grouping.
  6. In the Sorting and Grouping dialog box, click the arrow in the Field/Expression column, and then click CategoryId in the list.
  7. Set the GroupHeader property to Yes.
  8. Close the Sorting and Grouping dialog box.
  9. Add the following to the Filter property of the report:
    [CategoryName] = 'Seafood'
  10. Set the FilterOn property of the report to Yes.
  11. Save the report as Categories.
  12. On the View menu, click Print Preview.
  13. Note that the report is blank.

↑ Back to the top


For more information about server filters, click Microsoft Access Help on the Help menu, type serverfilter property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top

Keywords: KB212749, kbpending, kbbug, kberrmsg

↑ Back to the top

Article Info
Article ID : 212749
Revision : 2
Created on : 6/29/2004
Published on : 6/29/2004
Exists online : False
Views : 315