Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 585
  • Last Modified:

Print a filtered report MS Access

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
bezellvi
Asked:
bezellvi
  • 2
2 Solutions
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now