Solved

SQL reporting Services portrait/landscape??

Posted on 2004-09-02
9
1,488 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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
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.

747 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

9 Experts available now in Live!

Get 1:1 Help Now