Print Report on one page - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Print Report on one page

Author

Topic

jamie_pattison
Yak Posting Veteran

65 Posts

Posted - 2008-08-13 : 04:35:45

I have a report that displays perfectly in preview mode and when i run it. When i print it, it seems to be all over the place. How could i limit the report to print to one A4 landscape page?

Thanks

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-08-13 : 07:14:09

Have a look in the page properties for right, left, top and bottom margin.
Subtract these values from total page width and height.
Only the remaining space could be used for your report-items.
Hav a look in each property of your report-items and make sure that they not exceed the limits.

Webfred

Too Old to Rock 'n' Roll, Too Young to Die

jamie_pattison
Yak Posting Veteran

65 Posts

Posted - 2008-08-13 : 09:55:03

Maybe im being thick here but

all margins are set to 2.5cm
page width 29.7cm
page height 21cm
Under Body properties size is set to 29.63492cm, 29.7cm

and still i cant get it to print A4 landscape with all data on sheet (i.e. logo in top right hand corner)??

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-13 : 10:04:02

quote:
Originally posted by jamie_pattison

Maybe im being thick here but

all margins are set to 2.5cm
page width 29.7cm
page height 21cm
Under Body properties size is set to 29.63492cm, 29.7cm

and still i cant get it to print A4 landscape with all data on sheet (i.e. logo in top right hand corner)??

try setting Body properties size to less than 29.7-2.7 i.e may be 26.5 and 21-2.5 almost 18

jamie_pattison
Yak Posting Veteran

65 Posts

Posted - 2008-08-13 : 10:25:38

When i change one of the values from 29 (under body) it automatically goes back to the value i had set first? How come?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-08-13 : 11:14:53

My idea:
Your body (no - not your body - the report-body

) contains element(s) that must be resized (decreased) or moved otherwise the body cannot shrink.

Webfred

Too Old to Rock 'n' Roll, Too Young to Die

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-13 : 11:26:31

quote:
Originally posted by jamie_pattison

When i change one of the values from 29 (under body) it automatically goes back to the value i had set first? How come?

that means you've some elements (tables,rectangle..) that span to over 29 . so first change their dimension before altering body width.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources