Print Area in Report Builder PDF

[ann-maried51891]

Hi guys,

How can I set the print area on report builder? I'm sending report as a PDF and I'd like to export only the relevant sheets/areas.

Thanks!

[JillsMatthew · Accepted solution]

You must set the print area in your excel file before scheduling it in Report Builder. Also make sure that you hide all non-relevant sheets in your excel.

Set a print area on a worksheet >> https://support.office.com/en-gb/article/Set-a-print-area-on-a-worksheet-27048af8-a321-416d-ba1b-e99...

[ann-maried51891]

Yay! Hiding the unnecessary sheets did the trick.

Thanks for your help!