Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 212749 - Last Review: June 29, 2004 - Revision: 2.0
ACC2000: Can't Use Client-Side Filtering in an ADP Report with Grouping
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).
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.
To successfully create a report that implements both grouping and filtering, use the
ServerFilter property instead of the
Filter property.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce Problem
- Open the sample Access project NorthwindCS.adp.
- In the Database window, click Tables under Objects, and then click the Categories table.
- On the Insert menu, click AutoReport.
- After the report is generated, open it in Design View.
- On the View menu, click Sorting and Grouping.
- In the Sorting and Grouping dialog box, click the arrow in the Field/Expression column, and then click CategoryId in the list.
- Set the GroupHeader property to Yes.
- Close the Sorting and Grouping dialog box.
- Add the following to the Filter property of the report:
[CategoryName] = 'Seafood'
- Set the FilterOn property of the report to Yes.
- Save the report as Categories.
- On the View menu, click Print Preview.
- Note that the report is blank.
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.
APPLIES TO
- Microsoft Access 2000 Standard Edition
- Microsoft Data Access Components 2.1
| kberrmsg kbbug kbpending KB212749 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate