Saturday, March 19, 2011

Change SSRS Report Layout to keep the Column Headers Together

I created a SSRS report with 8 columns. When exporting the report in PDF format, the column headers were separated into two pages with default PORTRAIT layout.




To keep all the column headers together in one page, either I need to change the font size and squeeze them to fit into the 8.5 inches width or change the report layout to be Landscape.  Since it does not look good to squeeze them, I want to change the report to be Landscape layout.

To do it, here are the steps:

  1. Open the Report Properties
  2. Expend the PageSize
  3. Set the Width to 11in and Height to 8.5in and save it.


Now when exporting the report to PDF file, all the Column Headers are together in one page.



  1. They have claimed for this unexpected report.As they have worked hard to make this at one but because of some default problem it hasn't possible yet.So they are very upset for this.

    Cheap Computer Cases

  2. Thank you very much for sharing this information. I like this side. Its really a great article. So please give me some important information about this side.
    Computer Parts Store