Hi, I am nrewibe in ssrs 2008 reports. I created a tablix report by using report builder 3.0. In my report has 20 columns. When export to pdf , some columns are going to next page. I want to fit all columns in same page. How can i solve it.? Thanks Dileep

Dileep, Please check if your report is following these standards: 1) Go to properties and select Report width= 8.5in and height=11in . (Portrait format) Margins: 0.1,0.1,0.1,0.1in Go to properties and select Body width= 8in and height=10.5in But, if your reports are not able to fit into this, 2) Go to properties and select Report width=11in and height=8.5in (Landscape format) Margins: 0.1,0.1,0.1,0.1in Go to properties and select Body width= 10.5in and height= 8in Note: (Body Width + Left margin + Right margin) <= (Page width) Regards, Manoj --------------------------------------- *Happy to help

Hi Manoj, Thanks it working. But one problem is one additional blank page is showing.

Dileep, Is it at the end of the PDF?Regards, Manoj *Happy to help

Hi Manoj, Yes .if my report has one page. It show one additinal balnk page after fisrt page. Thanks Dileep

Dileep, Did you check both height and width of report? It should be within the standards mentioned above. The height of the report can be the issue based on your post!Regards, Manoj *Happy to help

Hi Manoj Yes ,

Dileep, Ok, did you any page break enabled for your report? Also, check for TIFF while exporting how's the behavior?Regards, Manoj *Happy to help

Hi Manoj, Page break is diabled. My Report height & width are 8.5 and 11.5 in. body Width and hieight are 6.6 and 2.5 in . thanks Dileep

Dileep, Change the width to 11in and not 11.5 in The combination should be (11in, 8.5in) or (8.5in, 11in) Regards, Manoj *Happy to help

Hi Manoj, soory, its height already : 11in.

Hi Dileep, If we are using a matrix in the report, we can try to add a column break in the matrix to control the number of columns. For more information, please refer to the article below: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/ea9d795b-8d17-41d2-a1d7-a4069ebb4539/ By the way, there is a blog about Logical and Physical Pagination Rules, please see: http://blogs.msdn.com/b/bwelcker/archive/2005/08/19/454043.aspx If you have any more questions, please feel free to let me know. Thanks, Bin LongPlease remember to mark the replies as answers if they help and unmark them if they provide no help.