DEV Community

APK
APK

Posted on

How to fit the page size of ssrs report to pdf to avoid the report column breaks into multiple pages

1) open your ssrs report

Image description

2) create your dataset and tables

Image description

3) click on the report properties. you just need to click on the white pane as shown in the image to take the report properties

Image description

4)make sure your properties check box is checked . other wise the properties won't show up

Image description

5)report properties will pop up like below

Image description

6) as you can see the size option will show the report size . you need to note the width only here

Image description

7)here the width is around 15.86 i will add one and make it 16.86 which is around 16.9. take a note on this

8)next you need to select page properties by clicking space outer the table as i marked in blue tick

Image description

9)the below property window will pop up

Image description

10)make the interactive size and page size width to 16.9 as i mentioned above and margins to 0.5 in as shown in the image

Image description

11)please note if the given size did not work, then increase the value by 1 and try until your page fits the size

now your report is all set to fit to the adf pages!!!!!!!!!!

Top comments (0)