none
Unable to set paper size in SSRS (it always remain Letter)

    Question

  • I am making a report in SSRS (SQL Server 2012). The main report has many sub reports under it. All main and sub reports have the following properties:

    Orientation: Landscape
    Margins: Custom
    Paper Size: A4

    When I export the report in Word, it always shows Paper Size as "Letter" and I have to change it to "A4" in it. Orientation and Margins are correctly exported. What's the problem with Paper Size? Why doesn't it export correct Paper Size as defined in SSRS which is "A4" and always resort to "Letter"?

    I see another use has same problem but no solution was identified.

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/fce60903-3d0a-4727-abcf-b2e3370bf7d8/ssrs-2008-and-page-size-issue

    EDIT

    I just created a new basic test report with one Tablix in it. It is also showing same behavior i.e. even though I have set Paper Size to A4 when I export the report in Word, it changes to "Letter".

    Thursday, September 04, 2014 11:18 AM

Answers

  • Frank,

    RDL files do not store the name of the paper size (see my previous posting). That's why it can't be passed to Word.

    Thanks.


    Remember to mark as an answer if this post has helped you.

    Hmm...so how do we solve this issue?

    Looks like the only solution is to tell customer to set paper type in Word after export.

    Monday, September 08, 2014 6:17 AM

All replies

  • Hi Frank,

    I viewed XML file for a report. The xml file doesn't store paper size name.

        <PageHeight>8.5in</PageHeight>
        <PageWidth>11in</PageWidth>
        <LeftMargin>0.25in</LeftMargin>
        <RightMargin>0.25in</RightMargin>
        <TopMargin>0.5in</TopMargin>
        <BottomMargin>0.5in</BottomMargin>

    Thanks.


    Remember to mark as an answer if this post has helped you.

    Thursday, September 04, 2014 1:51 PM
  • Hi Frank,

    I viewed XML file for a report. The xml file doesn't store paper size name.

        <PageHeight>8.5in</PageHeight>
        <PageWidth>11in</PageWidth>
        <LeftMargin>0.25in</LeftMargin>
        <RightMargin>0.25in</RightMargin>
        <TopMargin>0.5in</TopMargin>
        <BottomMargin>0.5in</BottomMargin>

    Thanks.


    Remember to mark as an answer if this post has helped you.

    This is my master report file and looks like it has correct values. Because orientation is landscape hence height is smaller than width in my case.

    <PageHeight>8.27in</PageHeight>
    <PageWidth>11.69in</PageWidth>
    <LeftMargin>1in</LeftMargin>
    <RightMargin>0.25in</RightMargin>
    <TopMargin>0.25in</TopMargin>
    <BottomMargin>0.25in</BottomMargin>



    Thursday, September 04, 2014 2:44 PM
  • Frank,

    RDL files do not store the name of the paper size (see my previous posting). That's why it can't be passed to Word.

    Thanks.


    Remember to mark as an answer if this post has helped you.

    Thursday, September 04, 2014 3:46 PM
  • Frank,

    RDL files do not store the name of the paper size (see my previous posting). That's why it can't be passed to Word.

    Thanks.


    Remember to mark as an answer if this post has helped you.

    Hmm...so how do we solve this issue?

    Looks like the only solution is to tell customer to set paper type in Word after export.

    Monday, September 08, 2014 6:17 AM