SSRS (Page setup to landscape and Size fitting A3 printout)

  • 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

  • This was removed by the editor as SPAM

  • 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?

  • 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.

  • 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.

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

  • 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


    [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]

  • 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.


    [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]

Viewing 7 posts - 1 through 6 (of 6 total)

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