Solved

SQL reporting Services portrait/landscape??

Posted on 2004-09-02
9
1,493 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
Back Up Your Microsoft Windows Server®

Back up 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.

 
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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…
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

740 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