Solved

SSRS default printing without margins

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

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…
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 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