Solved

SSRS default printing without margins

Posted on 2013-12-12
3
887 Views
Last Modified: 2013-12-18
I've designed a number of reports which, during development, were not meant to be printed out on paper.  But people are printing them out to bring to meetings with them and they are spanning multiple pages or being cut off so I am adapting them to be print-ready.  I've modified the data and tables to fit 6.5" by 9" with 1" margins but my report is being cut off.  I've tried nesting it all in a rectangle sized 6.5" by 9" and aligned it in the center of the report but no luck.  It prints perfectly if I go into the printer settings to set the margins to 1" but people don't want to have to manually set this.  They should be able to go to Actions > Print and have it come out perfectly fitted to a letter-sized paper.  I've removed the header and footer and moved the data in the body of the report but nothing I've done so far has helped solved the issue.  Any help would be greatly appreciated!

report alignment problems
0
Comment
Question by:HSI_guelph
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
Tony303 earned 500 total points
Comment Utility
Hi,

I usually set my page size to be the same as the interactive page size.

See how that pans out..

T
0
 

Assisted Solution

by:HSI_guelph
HSI_guelph earned 0 total points
Comment Utility
I have tried that setting them both to 6.5in by 9in with 1in margins and to 8.5in by 11in with 0in margins.  It's still aligning it to the left even though in design it is centered.
0
 

Author Closing Comment

by:HSI_guelph
Comment Utility
I'm not sure what I did but it's working now.  I was playing with height/widths in Report and Body properties so something must have finally clicked.  Thanks for reply!
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

762 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now