sql server 2005- reporting - pagesetup

[pratimapaudel]

Hi
I have created reports in SQL SERVER 2005 Reporting service.
But my report is not printing all the columns in one page. It is breaking the columns in two pages.
I have tried to set up the width and height property but i could not fix this problem.
Can anyone help me?
Thanks

[ronverdonk]

Why is this thread posted in the MySQL forum?

I'll move it to the MS SQL forum.

moderator

[deric]

Hi..
I think you just need to set the width of your report page to the width of the paper that you want that report to be printed on. For example, if you're going to use an A4, set the width to the width of an A4 paper (in centimeters, I think).
You have to consider the margins, too.
Then, calculate the total width of your columns to fit on the width of the paper less the left and right margins.
Try that and let me know if that helps you or not...

[pratimapaudel]

Thanks a bunch
It helped.

[deric]

Glad to know it helped..
SQL Server 2005 Reporting Services doesn't automatically adjust column widths to the width of your page.