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
BedrockMission!

Learn More

View all

Sign in to view all badges

Print Area in Report Builder PDF

Avatar

Avatar
Validate 1
Level 1
ann-maried51891
Level 1

Likes

2 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
ann-maried51891
Level 1

Likes

2 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
ann-maried51891
Level 1

27-09-2016

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!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
Level 4
JillsMatthew
Level 4

Likes

28 likes

Total Posts

68 posts

Correct Reply

23 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 10
Level 4
JillsMatthew
Level 4

Likes

28 likes

Total Posts

68 posts

Correct Reply

23 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile
JillsMatthew
Level 4

29-09-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-e99...

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
ann-maried51891
Level 1

Likes

2 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
ann-maried51891
Level 1

Likes

2 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
ann-maried51891
Level 1

30-09-2016

Yay! Hiding the unnecessary sheets did the trick.

Thanks for your help!