Printing a Pivot Table in a Sub Form

[Johnrg]

I have a form called orders pivot that shows our companies orders summed in a pivot table in the subform.

You can filter criteria in the pivot table as required.

How do I output the pivot table using a command button, as I see it on the screen, before or after filtering, into a one page report.

The pivot table would scale it self down in size to fit to a one page report. Like the "fit to one page" option in Excel. (This is important)

Thanks

JohnG

 

[Johnrg]

Anyone comment on this?

Basically how do I output a pivot table to a report?

JG

 

[Johnrg]

Bump to the top - I am beginning to think that you can't print pivot tables?

help!

JG