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

Print Area in Report Builder PDF

  • September 27, 2016
  • 2 replies
  • 1357 views

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.
    Best answer by JillsMatthew

    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

    J
    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

    ann-maried51891
    ann-maried51891Author
    September 30, 2016

    Yay! Hiding the unnecessary sheets did the trick.

    Thanks for your help!

      Terms & ConditionsAccessibility statement

      Loading footer...