Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Controlling page width

已答复 Controlling page width

  • Monday, February 04, 2013 5:03 PM
     
     
    Sign In to Vote
    0

    Ihave a report, with for portrait, 8.5x11, left and right margins are .25

    The BODY width is 7.75

    When I export to pdf, the extreme right is cut off (ie, the extreme right had character or digit)

    Which is odd because 7.75 + .25 + .25 = 8.25 (which is less than 8.5); I should be fine.

    Any suggestions?

    Marion in Hudson Valley

     

All Replies

  • Tuesday, February 05, 2013 5:42 AM
    Moderator
     
     Proposed Answer
    Sign In to Vote
    0

    Hello,

    The report body can grow or shrink to accommodate the report items contained within it. If the report items grow, the body will grows past the right edge of the physical page, and then a page break is inserted horizontally.
    To solve this issue, please specify the “CanGrow” property of report items to “False”.

    For more information, please see:Understanding Pagination in Reporting Services

    Regards,
    Fanny Liu

    Fanny Liu
    TechNet Community Support

     
  • Thursday, February 07, 2013 7:03 PM
     
     
    Sign In to Vote
    0
    Thanks Fanny, but that solution does not work because several textboxes include value which have wordwrap.  And, if set the "CanGrow" property to "False", then the vertical height does not grow to accommodate the contents

    Marion in Hudson Valley

     
  • Thursday, February 07, 2013 7:15 PM
     
     Answered
    Sign In to Vote
    0

    ok - I fixed it.

    I had several sub-reports.

    One of the sub-reports was wider than the rectangle that i had placed it in, and was forcing the whole report to expand.

    Marion in Hudson Valley

    • Marked As Answer by mtpaper Thursday, February 07, 2013 7:16 PM
    •