Solved

SQL reporting Services portrait/landscape??

Posted on 2004-09-02
9
1,490 Views
Last Modified: 2012-06-27
Anybody figure out how to get report to render in landscape? I have a report with a only a chart on it and would like to render it in landscape. Can't figure it out.

Thanks.
0
Comment
Question by:itstheride
  • 5
  • 4
9 Comments
 
LVL 15

Expert Comment

by:jdlambert1
ID: 11967900
um, you mean print to landscape? That's in your print options. Web pages don't have portrait/landscape settings.
0
 
LVL 15

Expert Comment

by:jdlambert1
ID: 11967943
If you mean the layout for Excel rendering, that's supposed to be automatic. First it tries portrait, then landscape, depending on the width of your columns, or height-to-width ratio.
0
 
LVL 2

Author Comment

by:itstheride
ID: 11967952
I understand that. If i set the report page size to 11x8.5 and layout the report so that it uses that page size and then print the report tellimng the printer to print landscape the report still comes out choppped off on the edges.
0
 
LVL 2

Author Comment

by:itstheride
ID: 11967959
Printing to PDF
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 15

Expert Comment

by:jdlambert1
ID: 11968024
Okay, this may sound crazy, and I can't test it right now, but have you tried setting the report page size to 8.5x11 and then telling the printer to print landscape. Back in the cobwebs of my brain, it seems like that worked...
0
 
LVL 2

Author Comment

by:itstheride
ID: 11968043
It does sound crazy but I will try it. Thanks.
0
 
LVL 2

Author Comment

by:itstheride
ID: 12006111
I tried the last suggestion with no luck.
0
 
LVL 15

Accepted Solution

by:
jdlambert1 earned 125 total points
ID: 12006180
Sorry that didn't help. It's been awhile since you posted, and no one else has contributed yet, so you might want to post a "pointer" question to try to help folks find this question. Or call Microsoft. :(
Reporting Services is new enough that there aren't as many experts (or as high a level of expertise) as there is for SQL Server...
0
 
LVL 2

Author Comment

by:itstheride
ID: 12006249
Sounds like a good idea. I had a feeling when I originally posted that there would not be many responses. It's new and it will take time for people to become "experts". Thanks for your time, I really appreciate it.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

929 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

12 Experts available now in Live!

Get 1:1 Help Now