How to fit all columns to the page width in sql reporting services

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi,

I've a report projects where each report has a number of columns and i wan all the columns to print on the same page. Is there a setting that will auto-scale these columns to fit to the page or will I have to edit the font size and widths manually on each report to fit to the page?

Thanks in Advance
Shiv

Posted 13-Aug-10 23:34pm

shivtk

Updated 14-Aug-10 0:22am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2010-08-14T10:09:00

Solution 1

Well you don't have any property in SSRS that would do that for you. You can do either as you said - need to manually scale down the fonts or what we did when we needed something like this was:
Use the PDF format. PDF has this auto-scale down in it. You can internally use the PDF format to print it. This is not what exactly you need or the situation asks for but it provides a way to overcome most of the situations where printed data is used.

Posted 14-Aug-10 10:09am

Sandeep Mewara

Comments

shivtk 16-Aug-10 1:58am

i am not getting that property, manually scaling also did not work out. i am displaying month in horizontally and count in that month corresponding to that month. But up to only 12 months its displaying, i wan all the date which i provide in dataset. hope u r getting my point

Sandeep Mewara 16-Aug-10 2:05am

Looks like you didn't got mine! There is a limit in horizontal direction for a PAGE. You cannot have all in ONE page.
Use PDF rendering and it would scale down. But assuming you have lets say even 20 columns, then it would be hardly readable.

shivtk 16-Aug-10 3:46am

hiMy concern is that we need have more no. of col. in a report
as i am unable to generate col's more than 12

where as my requirement is to punch min of 36 - 48 col. data
which i can further export to XL