Link to home
Start Free TrialLog in
Avatar of newbie_girl
newbie_girl

asked on

Print report to A3 page with Shrink the columns to fit the page.

We have some reports have many columns (up to 25 columns). The user want to print the report to A3 page size and Shrink the report columns to fit that page.

I was able to:
- Print to A3 page size by: Choosing A3 as page size from Report Property then print. But the columns were in 2 pages.
- Print to A3 page size by: Choosing A3 as page size from Report Property, change the width and height (the page size automatically changed to Custom) and then print. All the columns shirked to one page but to A4 page.
- Change the "Keep together on one page if possible" from the Tablix property then print. But nothing has happened.

Any idea on how to do that would be appreciated
ASKER CERTIFIED SOLUTION
Avatar of DavidMorrison
DavidMorrison
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of newbie_girl
newbie_girl

ASKER

Hi David,

Thank you for your reply.

I have tried your suggestion and it did fit in A3. However, as you mentioned, I had to minimize the font size for the report to less than 5pt (as I had mentioned that I have up to 25 columns) which made it unreadable from the report (before printing).

So, does that mean that there is no “Shrink to fit” functionality, and maybe the best way is to export it (to excel for example) then use the print functionality from there?!

Thanks
Hi Newbie,

Unfortunately if you need it to fit to that size on print that's the rules you need to play by. You can however get around the small size on screen issue by changing the zoom level in the viewer.

As you've said the other way round is to build the report to look good on screen, export to excel and then do a print to fit page from excel, although this is less an a perfect solution

Thanks

Dave