all groups > sql server reporting services > january 2006 >
You're in the

sql server reporting services

group:

Setting linked reports to print landscape


Setting linked reports to print landscape Carmen
1/6/2006 12:07:04 PM
sql server reporting services:
I have linked reports that are printing portrait even though the "master"
report was set to landscape. I understand this is a problem and found another
post suggesting to use the following code:

Dim rs As New ReportingService.ReportingService

rs.Credentials = System.Net.CredentialCache.DefaultCredentials
rs.Url = "http://localhost/reportserver/reportservice.asmx"

Dim p(5) As ReportingService.Property

p(0) = New ReportingService.Property
p(0).Name = "PageHeight"
p(0).Value = 8.5 * 25.4
p(1) = New ReportingService.Property
p(1).Name = "PageWidth"
p(1).Value = 11 * 25.4
p(2) = New ReportingService.Property
p(2).Name = "TopMargin"
p(2).Value = 0.5 * 25.4
p(3) = New ReportingService.Property
p(3).Name = "BottomMargin"
p(3).Value = 0.5 * 25.4
p(4) = New ReportingService.Property
p(4).Name = "LeftMargin"
p(4).Value = 0.5 * 25.4
p(5) = New ReportingService.Property
p(5).Name = "RightMargin"
p(5).Value = 0.5 * 25.4

rs.SetProperties("/LinkedReport", p)

My question is were would this code go? I'm assuming I wouldn't have to
create an application to replace Report Manager just for this. Is there any
"startup" function that is executed when a report is loaded or printed? Does
anybody know if this will be fixed in future SPs?

I have over 25 linked reports and my only alternative is to create them all
as "masters" which would be major work/headache.

Thanks in advance for any help,

Re: Setting linked reports to print landscape Daniel Reib [MSFT]
1/6/2006 2:49:53 PM
You can use this code in an RS.exe script. Here is information on using
rs.exe

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_script_61gi.asp

--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Re: Setting linked reports to print landscape Carmen
1/10/2006 11:48:06 AM
Thanks, Daniel!

[quoted text, click to view]
AddThis Social Bookmark Button