Solved

SSRS default printing without margins

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

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

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

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 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