B
Bill Murphy
I have a tabbed form, and each tab contains a subform with either a pivot
chart or a pivot table. The user can click on a tab, then modify the view
of the chart or table, including changing the filter, pivoting the view,
selecting a different chart type, etc. I would like to allow the user to
print the current view of the chart or table as a report. I added a command
button to each tab with code to open a report using the same query that the
tab's subform is based upon. However, the report output does not present
the same filtered view that the user sees in the form.
Is there a way to base the report on the exact modified and filtered view of
the chart or pivot table that the user sees on the form?
Bill
chart or a pivot table. The user can click on a tab, then modify the view
of the chart or table, including changing the filter, pivoting the view,
selecting a different chart type, etc. I would like to allow the user to
print the current view of the chart or table as a report. I added a command
button to each tab with code to open a report using the same query that the
tab's subform is based upon. However, the report output does not present
the same filtered view that the user sees in the form.
Is there a way to base the report on the exact modified and filtered view of
the chart or pivot table that the user sees on the form?
Bill