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