Solved

SSRS default printing without margins

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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

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…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

808 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