Skip to main content
ann-maried51891
ann-maried51891
Sep 27, 2016 11:56 AM UTC
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
    Sep 29, 2016 1:05 PM UTC

    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

    View in thread

    2 replies

    JillsMatthewAccepted solution
    Level 4
    Sep 29, 2016 1:05 PM UTC

    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
    ann-maried51891
    ann-maried51891Author
    Sep 30, 2016 10:25 AM UTC

    Yay! Hiding the unnecessary sheets did the trick.

    Thanks for your help!

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...