Solved

SSRS default printing without margins

Posted on 2013-12-12
3
938 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
[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 12

Accepted Solution

by:
Tony303 earned 500 total points
ID: 39715359
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
ID: 39716949
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
ID: 39726210
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

730 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