SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
pitso.maceke
pitso.maceke
SSC Journeyman
SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)

Group: General Forum Members
Points: 93 Visits: 213
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
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSCrazy Eights
SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)SSCrazy Eights (9K reputation)

Group: General Forum Members
Points: 9039 Visits: 7283
In your design screen, right click outside the report construction space and select Report properties.
The first set of options is Page Setup. make the relevent changes here and then test.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Mansfield
Mansfield
SSC-Addicted
SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)

Group: General Forum Members
Points: 426 Visits: 394
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?
tomysmile
tomysmile
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 6
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.
becklery
becklery
Old Hand
Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)Old Hand (303 reputation)

Group: General Forum Members
Points: 303 Visits: 187
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
Mauve
Mauve
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1762 Visits: 2054
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


(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.
Mauve
Mauve
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1762 Visits: 2054
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.


(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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search