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 October 5th, 2004, 04:52 PM
vikramp vikramp is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2004
Posts: 7 vikramp User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Cool Reporting Services - Export to PDF

Hi all,

I have designed report in SQL Server reporting services.
The report works well and I can call it from ASP.NET application by passing parameters in the URL.

The report looks fine in HTML view. However, when I export it to PDF, the report does not fit on the page.
The width of the page is not enought to hold all the columns.

My report has lot of columns. So I want to print it in Landscape mode. For this, I changed page width to 11
and height to 8.5 in. But still all the columns do not fit on the page.

Not able to figure out what exactly is the problem.
Do I need to change page width/height using DeviceInfo and specify it in the URL along with other
parameters?

Thanks in advance

Vikram

Reply With Quote
  #2  
Old April 19th, 2005, 12:07 PM
Arunabajpayee Arunabajpayee is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2005
Posts: 1 Arunabajpayee User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 m 37 sec
Reputation Power: 0
Reporting Services Report Export to PDF

Did you find the solution to this?

I am having the same issuse and would appreciate any help on this.
Thanks,
aruna


Quote:
Originally Posted by vikramp
Hi all,

I have designed report in SQL Server reporting services.
The report works well and I can call it from ASP.NET application by passing parameters in the URL.

The report looks fine in HTML view. However, when I export it to PDF, the report does not fit on the page.
The width of the page is not enought to hold all the columns.

My report has lot of columns. So I want to print it in Landscape mode. For this, I changed page width to 11
and height to 8.5 in. But still all the columns do not fit on the page.

Not able to figure out what exactly is the problem.
Do I need to change page width/height using DeviceInfo and specify it in the URL along with other
parameters?

Thanks in advance

Vikram

Reply With Quote
  #3  
Old May 25th, 2005, 01:17 PM
branflakes29 branflakes29 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2005
Posts: 1 branflakes29 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 7 m 14 sec
Reputation Power: 0
I've been working with reporting services quite a bit recently and have hit this problem a lot.

My first suggestion is to get rid of the page margins. They are defaulting to 1" on each side. You will find this in the Report Menu under Report Properties.

Another thing to make note of is the rulers on the design page. Even though you may have widened your page to 11", it might still be only using 8.5". If this is the case, your solution lies in the Layout tab of the report properties.

If there are too many columns and you are desperate to keep your report on a regular sized page, you can always decrease the padding in each cell of your report. Currently its 2pt all around the cell.


Hope this helps

Reply With Quote
  #4  
Old July 2nd, 2010, 05:02 PM
vasireddybharat vasireddybharat is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2010
Posts: 1 vasireddybharat User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 m 4 sec
Reputation Power: 0
Report Width should be more than table width

Report Width should be more than table width..try this it should work....


Thanks
Bharath Reddy VasiReddy

Reply With Quote
  #5  
Old July 15th, 2010, 02:47 PM
ajchave ajchave is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2010
Posts: 1 ajchave User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 m 40 sec
Reputation Power: 0
Make sure that you are changing the width and height in the report properties and not in the body section.

Same thing happened to me and was because I was changing only the body properties and not the report.

hope this help

Reply With Quote
  #6  
Old August 22nd, 2013, 04:55 AM
dpalepu dpalepu is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2013
Posts: 1 dpalepu User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 17 m 18 sec
Reputation Power: 0
Quote:
Originally Posted by vasireddybharat
Report Width should be more than table width..try this it should work....


Thanks
Bharath Reddy VasiReddy


Thank you, your reply helpful for me to resolve similar issue .

Regards,
Durga

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > Reporting Services - Export to PDF


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 - 2017, Jelsoft Enterprises Ltd.

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