How to print Report in Landscape view?
-
Hello,
I am having a hard time printing a SQL Report in the Landscape view.
At present the company has a report in MS Word and the second page of the Word document is a Landscape page and when you print the report it automatically prints it in the Landscape view.
Now I am trying to convert this report into SQL Report. I have designed the report in the Landscape view ( Dimensions 11 X 8) but when I print the report it stills print it in portrait view and Not landscape.
Any Ideas?
-
I just figured out that If I give a page size of 29cm width then I am able to print that out in Landscape view, but the issue comes when I have this report as a subreport, then It only prints as Portrait as the page size of the main report is only 7cm.
-
That is correct. Unfortunately in SSRS sub-reports inherit the page orientation of the parent report.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Here is a link to a Connect item requesting functionality similar to this. You should go and vote for this item. Microsoft definitely takes Connect entries seriously.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
We had a similar situation with linked reports. Linked reports do not inherit the page width and height of the parent report.
Our page settings are done properly, but if you view the report as a linked report, it switches back to portrait.
We contacted Microsoft in a support call and they confirmed that this was the issue. And that they would hopefully get it fixed soon.
-
Yes, linked reports have a problem. See the following two threads on methods to get around the problem and correct it.
http://www.sqlservercentral.com/Forums/FindPost661300.aspx
http://www.sqlservercentral.com/Forums/FindPost661381.aspx
We now set the page size properties when we create and/or refresh the linked reports as we create the linked reports via .Net C# program.
However, I've also successfully used the Reporting Services Utility (RS.exe) to set the page size properties. See http://msdn.microsoft.com/en-us/library/ms152874(SQL.90).aspx for the technical details of RS scripts.
[font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font] -
i have a solution to this
go to the database for reporting services
and open the dbo.Catalog table and update the PropertyField attribute for the linked report record with the original PropertyField content of the base report record
for example
the original value for the linked report are
<Properties/>
but the new value should be
<Properties><Language>en-US</Language><HasUserProfileQueryDependencies>False</HasUserProfileQueryDependencies><HasUserProfileReportDependencies>False</HasUserProfileReportDependencies><PageHeight>215.9</PageHeight><PageWidth>279.4</PageWidth><TopMargin>12.7</TopMargin><BottomMargin>2.54</BottomMargin><LeftMargin>12.7</LeftMargin><RightMargin>0.254</RightMargin></Properties>
i get this value from the original record of the base report in the same table.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply