SSRS 2008 R2 report does not print landscape when is a linked report

Question

SSRS 2008 R2 report does not print landscape when is a linked report

jokesbox_mail

SSC Enthusiast

Points: 196
More actions
December 15, 2011 at 6:35 am

#264866

Hello All;
I've been using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor) for about a year.
I'll try to describe my issue as simple as possible, I have a report that prints on landscape(no issues there) I have the report located on a folder and the page size is 11in, 8.5in. But after creating a linked report and place the link in another folder, the linked report prints as Portrait by default but the original report prints as landscanpe, I'm not able to find a solution for this issue, to me it seems like a bug.
Any help will be appreciated.
Thank you

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

k_nataraj Old Hand Points: 361 More actions · Answer 1

Did you make sure the linked report is in same page size as the main report? Even though its a linked report, you should specify the page size for that rdl file aswell.

regards

Natraj

jokesbox_mail SSC Enthusiast Points: 196 More actions · Answer 2

Hi Natraj;

Thanks for your reply, the way I create the linked report is on SSRS, I go to the folder where the report is located and click the dropdown menu in the report, then I get the menu options to move, delete, subscribe, create linked report, view report history, etc..

I'm not sure where I can setup the page size for the linked report but if you do it that way you cannot see the option for the page size. can you please give me some color to know where can I find it?

Thank you

jokesbox_mail SSC Enthusiast Points: 196 More actions · Answer 3

also I found this article on msdn, but at the end of the page you can read the one comment from Steve Philip where he states that the report properties such as page size and orientation are not carried on to the linked report, but no details to solve this issue.

http://msdn.microsoft.com/en-us/library/ms155998.aspx

jokesbox_mail SSC Enthusiast Points: 196 More actions · Answer 4

I was able to find a solution, is not sharp at all but it worked... The queries below will give you an idea, you will need to change the varible text to the report's name you want to past the properties to, the only issue is that both(original and linked report) will need to have the same name.

please notice that the items type equal 2 are the actual reports and that items type equal 4 are the linked reports

-- TEST Query

declare @name nvarchar(425) = 'MyReport'

select

TARGET.name

,TARGET.path

,TARGET.property

,SOURCE.name

,SOURCE.path

,SOURCE.property

from

[ReportServer].[dbo].[Catalog] as TARGET

inner join

[ReportServer].[dbo].[Catalog] as SOURCE

on

TARGET.name = Source.name

and TARGET.type = SOURCE.type+2

and TARGET.type = 4

and SOURCE.name = @name

-- UPDATE