Solved

Print a filtered report MS Access

Posted on 2013-05-20
2
524 Views
Last Modified: 2013-08-07
I have an MS Access report that has PivotCharts on it. The report opens in report view so I can filter the charts. I added a Macro button to print the report, but when I click it, the filters are removed. How do I make this button print the filtered data?
0
Comment
Question by:bezellvi
  • 2
2 Comments
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 500 total points
ID: 39182676
What I typically do is base the Pivot on a "query"

Then create a system to filter (set the Where Condition) of the query.

This is the same as filtering the Pivot, but it should persist when it is printed.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 39182732
Something like this:

Here I have simply demonstrated with a query, since I am unsure how you inserted your pivot chart.

But the principle is the same:...
Set the query criteria, then open the query.
Set the query criteria, then open the report on which it is based.
Database111.mdb
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question