Monday, September 10, 2018

SSRS : How to fit PDF export on one page in reporting services avoid column splitting to multiple pages

In SSRS when exporting all the columns and records to PDF, if it is larger column volumes then it is getting splitted to 2nd page or multiple pages.

To fix this follow the below steps.

1. Go to Report Properties ->Interactive Size 
2. Make sure width and Height is more than the report Body width and height size.
3. change the report Properties-> Margins to .5 in

Run the Report. Now all the columns will fit to the one page.