Print Area in Report Builder PDF | Community
Skip to main content
ann-maried51891
New Participant
September 27, 2016
Solved

Print Area in Report Builder PDF

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
JillsMatthewAccepted solution
Level 4
September 29, 2016

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-e99ae2182a7e

2 replies

ann-maried51891
New Participant
September 30, 2016

Yay! Hiding the unnecessary sheets did the trick.

Thanks for your help!

Translate
JillsMatthewAccepted solution
Level 4
September 29, 2016

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-e99ae2182a7e

Translate