none
SSRS 2008 R2 Reports export to PDF to fit one page wide and avoid the column spreading on multiple pages.

    Question

  • Hi

    I have developed a report with SSRS 2008 R2, when I export the report to PDF the report columns are getting spread over multiple pages also the report header text is getting spread over multiple pages. I need to display the header text and columns on one page wide. Can anyone suggest how to fix this? Am I missing some properties to be set?

    Your help is highly appreciated.

    Thanks and Regards,

    Satish

    Thursday, June 09, 2011 6:17 AM

Answers

  • Hi Satish,

    According to your description, the report header and columns are getting spread over multiple, right?

    If in this case, the table width in report exceeds the width of page, besides Rakesh professional suggestion, please try to use the following steps to alter the page width larger than table width, and see if it works for you,

    1. Select Report on the menu bar.
    2. Select Report Properties.
    3. Alter page width in Width tab.

    Set page width to be more than the table width, for example, if you have given the table width as "140 in", you may have to set the page width to be more than "140 in".

    If you have any question, please feel free to ask.

    Thanks,
    Eileen

    • Marked as answer by Eileen Zhao Monday, June 20, 2011 1:46 AM
    Friday, June 10, 2011 8:12 AM

All replies