Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old July 21st, 2004, 07:16 AM
lazymale lazymale is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Posts: 4 lazymale User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Red face Reporting Services - Export PDF in Landscape??

hi people.

Can someone out these tell me how to export a report made in MS SQL Reporting Serives into LANDSCAPE. Is there anyway to set this in the report/layout properties OR is Microsoft team still figuring this out now???

When i export to PDF the default layout is POTRAIT and nothing seems to happen when i change the orientation to LANDSCAPE in Acrobat Reader 6.0 page setup.

Any ideas???

Lazy Male

Reply With Quote
  #2  
Old July 22nd, 2004, 12:27 AM
lazymale lazymale is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Posts: 4 lazymale User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Talking Yes it works!

Well, I solved the problem myself. Thought I should post it in case you guys keep wondering.

All you goto do is alternate the report width and height in Report Properties. If you want it on A4 sheet, then give width=29cm and height=21cm. Thats how you would have the width and length if u hold an A4 sheet horizontally right??

Btw, dont forget to keep the body, header and footer width 1 inch less that report layout width OK? You dont want blank pages in between, do you?

So its as simple as that. Try it out.

Sorry Bill... guess your guys are doing their jobs right. Cool.

Lazy Male


Reply With Quote
  #3  
Old August 8th, 2008, 02:56 AM
learner_chic learner_chic is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2008
Posts: 1 learner_chic User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 m 53 sec
Reputation Power: 0
Talking

thanks lazymale, 4 years later n your post came in handy

Reply With Quote
  #4  
Old February 13th, 2009, 09:02 AM
cathyang9 cathyang9 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2009
Posts: 1 cathyang9 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 m 32 sec
Reputation Power: 0
Can't Change Boby Width

Thank you lazymale, your post was very helpful. I had a small problem. I set the page size of my report to 11in by 8.5in. But for Body, I can't seem to change its width. It has a default value, for example 10.23684in. I tried to change it, but as soon as I complete changing it, it changes back to its default value, and I still have extra blank pages when I export the report to PDF landscape. Please help!

Thanks.

Reply With Quote
  #5  
Old July 25th, 2013, 04:23 AM
nl03228 nl03228 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2013
Posts: 1 nl03228 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 m 26 sec
Reputation Power: 0
also in 2013...your post was/is still helpfull :-)

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > Reporting Services - Export PDF in Landscape??


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

© 2003-2014 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap