fitting a report into a single page

hello guys,

i am making a report which views atleast 20 columns..and on the default font size it is being rendered which is in 11 it is impossible to print it in a single page..

i am just wondering if it is possible if during the exporting to pdf, is it possible to fit it in a single page by shrinking its contents into a size that will fit the page..

any help will be highly appreciated..

thanks in advance!

Yes. Simply define your page large enough to contain all of the columns. Then export to PDF and print using 'fit to page' option. Warning, the print may be VERY small, but it will scale and be readable on a high quality printer. Remember to increase the length of your page in ratio with the width.|||

ok ill try that one..so that means there is no way you can do it in the reporting services..it is manually done in the acrobat during printing phase isn't it?

anyway thanks for the reply..it really helps!