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:
- Open the Report Properties
- Expend the PageSize
- 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.