I have Nav 2009 R2, Jet Essentials 2013, I have a report which I want to email via pdf each day, but I only want the Pivot table to be emailed, when I first tried this it gave me everything from the Report worksheet & the Pivot Worksheet which was about 37 pages, can I prevent it from outputting the report worksheet?
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment If you are outputting as a PDF via the scheduler, it will remove any hidden sheets/columns/rows when it converts it to a PDF.
Any sheet you don't want to show up, make sure you have Auto+Hide+Hidesheet in cell A1. That should resolve the problem you are running into. -
Jet Reports Historic Posts Thanks @JET-btr that is what I wanted & it worked, so simple when you know how!
Please sign in to leave a comment.