Printing a Filtered Pivot Chart on a Report

[mpspeer]

I have created a database that tracks production by individuals. I have also created a report which includes a pivot chart to give the user a chart view of production.

In the pivot filter of the chart I have associate names, where the user can click all, or individual associates, to see individual production.

The trouble I am having is when the user goes to print the chart, it will only print the chart with the "All" filter view. Even if the pivot chart is filtered to one associate, it will print like "All" was checked.

Is there a way to allow the report/pivot chart to only print the production for the individual who is checked within the pivot filter?

 

[JHB]

In the pivot filter of the chart I have associate names, where the user can click all, or individual associates, to see individual production.

Is there a way to allow the report/pivot chart to only print the production for the individual who is checked within the pivot filter?

Where does the user click the filter?
A report is only for printing, not for interacting with user input/change, if so then you have to create a form.

 

[mpspeer]

Where does the user click the filter?
A report is only for printing, not for interacting with user input/change, if so then you have to create a form.

It looks like we are in different parts of the world, so pardon my delay.

The user clicks the filter on the pivot chart, located on the subform.

Background:
I have a subform where the user inputs a date range and clicks "go", which runs a query that then formulates the pivot chart for the user to view.

I then have a button that says "Print Report", which has the following macros associated with the on click event:

OpenReport
Report Name - NameGoesHere
View - Print Preview
RunMenuCommand
PrintObject

Regardless of which associate the pivot chart is filtered on, it will only print the filter as if "All" were selected.

 

[JHB]

How do you apply the filter you have in the form to the report, by at query with criteria or ...?
Post you database with some sample data, (zip it if you don't have posted 10 post yet).

 

[Quincasborba]

I´m facing the same problem, but it seems our friend 'mpspeer' just gave up to take this topic further. Well, let´s see if someone can help me.

I have a form, with a subform on it. The subform shows a query (chosen in the parent form, through a combobox), that is configured to pivot chart view, with the 'Automatic filter' property on. That is very interesting, so I can set up what I want to be shown or not. But when I press the command button (with VBA code) to print the chart, it prints it with no filters at all. It prints it in its standart filter configuration.

Any tips for printing it in the way it apears in the screen, with dynamic filters as chosen?

Thanks for any help people!
Bye.