export to pdf

  • trying to export ssrs to pdf.

    report is in landscape when exporte to pdf it goes as portrait and hence it goes into more than one page

    is there anyway to get the same way in pdf as of report

  • You should be able to set the page properties in SSRS designer in exact numeric value because when I set the value bigger I can export to PDF without blank pages. So set it in the drop down properties on the SSRS designer.

    Kind regards,
    Gift Peddie

  • Thanks for the reply

    i have page width as 11in and page height as 8.5in in my report.

    i dont have extra space anywhere in the report.

    I am not clear what numbers to be changed? please let me know

  • Open your report in BID designer and on the right side there are many things you can adjust for the page setting and you need to set the interactive height to zero. But I am not sure 11 by 8.5 will work for landscape because that is the standard portrait measurement.

    Kind regards,
    Gift Peddie

  • Jut setting the page as follow:

    Width: 29.7cm

    Height: 21 cm

    This is the standard size for A4 but you will need to set your margin to 0 otherwise adjust the width and height accordingly.

  • Click on Menu -> Report

    Click on Report Properties

    Click on Layout Tab

    Set Page width and Page height accordingly

    Set Left and Right margin

    You will get what you set as simple as that.

    -RP

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply