Solved

Print a filtered report MS Access

Posted on 2013-05-20
2
501 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now