Solved

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

Posted on 2011-09-06
3
2,808 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:newbie_girl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
DavidMorrison earned 50 total points
ID: 36494468
Hi, what you need to do is in the report properties set the page size to the physical dimensions of A3 paper in centimetres (you'll have to look up / measure what this is as I have no idea).

Then set the margins properties, which is also found in in the report properties, to say 1cm on all four.

Now all you need to do is go to the body element and in the properties set its size to the report page sizes minus the margins.

so for example if you set the report page width to 20cm and the left and right margins to 1cm each then the body width must be set to 18cm or less

then simply size your columns to fit into the body you have laid out and RS should take care of the rest


Thanks

Dave
0
 

Author Comment

by:newbie_girl
ID: 36499952
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
0
 
LVL 5

Expert Comment

by:DavidMorrison
ID: 36501351
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
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question