Solved

SQL reporting Services portrait/landscape??

Posted on 2004-09-02
9
1,491 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
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.

 
LVL 2

Author Comment

by:itstheride
ID: 11967959
Printing to PDF
0
 
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

785 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