Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Print Area in Report Builder PDF

ann-maried51891
Level 1
Level 1

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!

1 Accepted Solution
JillsMatthew
Correct answer by
Level 4
Level 4

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

View solution in original post

2 Replies
JillsMatthew
Correct answer by
Level 4
Level 4

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

View solution in original post

ann-maried51891
Level 1
Level 1

Yay! Hiding the unnecessary sheets did the trick.

Thanks for your help!