September 10, 2009 at 8:51 am
How can I setup my Table Report from the layout page to landscape and to fit A3 paper on the view or on the internet explorer when convertting to pdf format
September 11, 2009 at 2:04 am
This was removed by the editor as SPAM
September 27, 2009 at 4:14 pm
FYI in SQL 2005, you get the following tabs after right clicking and opening the Report Properties dialog:
General
Layout
Code
References
Data Output
But no Page Setup.
Under Layout tab you can change the page width, height, and margins, but no presets for paper size.
I wonder what best practises are there to reliably change paper size for SSRS 2005?
November 3, 2009 at 1:17 am
try to find Report Properties -> Layout, make any necessary modifications there.
SSRS 2005 doesn't provide you with Landscape/Portrait selection, if you need to change from portrait to landscape format then just switch the value between Page Width and Page Height.
Hope it helps you.
November 8, 2009 at 8:50 am
Hi, Pitso.
As I know, you can use RAQ Report to solve your problem. Because with it, you can set the properties of report as you like in the dialog box easily. You can select desired page direction and paper size in the drop-down box.
I wish this would be helpful.
Regards,
becklery.
November 9, 2009 at 9:24 am
Note that SQL Server 2005 Reporting Services has a bad defect related to linked reports. If the report is a linked report, the page size properties of the master report are not propogated to the linked reports. They have to be set in the linked report.
See thread 710191 for additional details. http://www.sqlservercentral.com/Forums/FindPost710191.aspx
September 29, 2010 at 7:51 am
Mauve (11/9/2009)
Note that SQL Server 2005 Reporting Services has a bad defect related to linked reports. If the report is a linked report, the page size properties of the master report are not propogated to the linked reports. They have to be set in the linked report.See thread 710191 for additional details. http://www.sqlservercentral.com/Forums/FindPost710191.aspx
An update to the above:
It appears that the Linked Reports page size issue that was initially reported against SQL Server 2005 has NOT been fixed in SQL Server 2008 R2 RTM (10.50.1600). I.e., a Linked Report does not inherit the page size properties of the parent report.
Therefore, you will still have to explicitly set, or programatically copy them from the master report, the page size properties when you create a Linked Report.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply