This is very common issue we face in SSRS regarding layout of report. I don’t know what to call this, whether a simple issue or strange requirement of client/user.
Let me tell you the problem definition first.
If we have a SSRS report with many columns to be displayed on it, it will expand horizontally. And after exporting these kinds of reports into PDF file format, you will see that pages have been split in multiple pages. But business users want to see one report page in one single PDF page and not in multiple pages.
Why I call this as strange requirement: Well, think of the scenario when someone asks you to put a table in single A4 size paper with lots of columns in it. And these columns should have proper width; contents of them should be visible etc. I am sure that A4 page would look messy. And even if we use the smaller fonts, we can make that a little less messy.
In SSRS Report Layout, go to “Report” menu and select “Report Properties”. You will see dialog box as shown below. Just modify (i.e. increase it to your required level) the size of the “Page Width” and that’s it. (This value is in inches)
Just by increasing the size of “Page Width” does not guarantee that exported page will fit into one page in PDF file. But it’s more like a trial-error method. So you have adjust is again and again till the page stop splitting into multiple pages. That means, you increase the size to 10in and test your SSRS Report by exporting to PDF. And if the page is still split, then increase the size again 🙂
The only disadvantage with this method is, (and which is obvious) contents will be shrink in the exported PDF page. To see the contents in little good version, you better take the print of that paper in bigger paper (e.g. A3) as well as use the “Orientation” to “Landscape” while printing the page, so most of your contents will be properly visible and readable.
Hope this helps.