Solved

SQL reporting Services portrait/landscape??

Posted on 2004-09-02
9
1,498 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
[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
  • 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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

615 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