Hi,

I have a report/dashboard with a pivot table of detail on it (in this case a list of machines) - I want the user to be able to print their own list off once they have viewed the dashboard. The intention being that the dashboard shows them what's wrong and the list gives them a tool to go away and work with.

So i have put a button (code below) to open the pivot table as a .pdf BUT if the list is really long the code just forces the pivot into one page. How can i edit it to keep a 100% view and if the table runs longer than 1 A4 page, to just flow onto another? All help appreciated! Thanks

Please Login or Register  to view this content.