By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,380 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

sql server 2005- reporting - pagesetup

P: 24
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?
Mar 30 '08 #1
Share this Question
Share on Google+
4 Replies

Expert 2.5K+
P: 4,258
Why is this thread posted in the MySQL forum?

I'll move it to the MS SQL forum.

Mar 30 '08 #2

P: 92
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...
Mar 31 '08 #3

P: 24
Thanks a bunch
It helped.
Apr 1 '08 #4

P: 92
Glad to know it helped..
SQL Server 2005 Reporting Services doesn't automatically adjust column widths to the width of your page.
Apr 4 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.