Perplexing SSRS export issue with paper size

  • Hi All,

    I have an SSRS report that's originally deployed in "Letter" paper size.

    In the client app, using ReportViewer, I'm setting the paper size to "A4" or leaving it as "Letter" depending on preference.

    When the preference is "A4" the report renders fine and in the "Page Setup" it shows the right paper size of "A4".

    When I export the report to either PDF or Word, it exports with the "Letter" paper size.

    Does the export rendering extensions only export with the paper size that the RDL was deployed with?

    Because if I deploy the RDL as "A4" then it will export to Word as "A4" then again the PDF is still "Letter".

    Confused.

    SSRS 2008 R2

    ReportViewer 11.0

    Coded in VB.Net on VS2012

    ---------------------------------------------------------------
    Mike Hahn - MCSomething someday:-)
    Right way to ask for help!!
    http://www.sqlservercentral.com/articles/Best+Practices/61537/
    I post so I can see my avatar :hehe:
    I want a personal webpage 😎
    I want to win the lotto 😀
    I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

  • Nevermind I found what I needed. Page Setup is for printing only :crazy:.

    http://technet.microsoft.com/en-us/library/dd283105.aspx#Pagination

    Page Sizing

    When the report is rendered, the Word page height and width are set by the following RDL properties: paper size height and width, left and right page margins, and the top and bottom page margins.

    ---------------------------------------------------------------
    Mike Hahn - MCSomething someday:-)
    Right way to ask for help!!
    http://www.sqlservercentral.com/articles/Best+Practices/61537/
    I post so I can see my avatar :hehe:
    I want a personal webpage 😎
    I want to win the lotto 😀
    I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

Viewing 2 posts - 1 through 1 (of 1 total)

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