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.
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...
Yay! Hiding the unnecessary sheets did the trick.
Thanks for your help!