I am developing a report with almost 25 columns table and the width of the report is 20pt. But I am changing the visibility of a few columns in run-time so that the resultant width will fit in one page (11pt)(I checked all the margins and resultant width of table. Sum of all the widths are with in the pagesize only). Everything is working fine when i check the report in browser, but when i try to Export to PDF there are alternate white pages, which are corresponding to the hidden columns width i guess.
How to achieve PDF Export without white pages? Also, is there any way to shrink the report to a single page?
I am using SSRS 2005
View Complete Post