Printing Issues

[xlbo]

Hi,
using SSRS on XP with IE6.

Seem to have some issues with how the report decides to print - the page size options seem to force a landscape / portrait print depending on their ratio but there seems to be no consistency as to where the page cuts off. There also seems to be issues with the "default printer" in that it will print to a full page on 1 printer but only on half a page on another.

Does anyone have any documentation on how SSRS decides to print and show data ?

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[Catadmin]

I don't have documentation, but have you checked the margins and the paper size in your Report Properties to make sure they are consistant from report to report?

I do know you're supposed to be able to "force" a landscape/portrait orientation based on which paper size is listed first. I.E., if you have it listed as 11 and 8.5 instead of 8.5 and 11 (left to right), it's supposed to print along the long edge of the paper instead of the short edge. However, if your object sizes are larger than the paper size, that automatically increases the size of the report. Also, that pesky "can increase/can decrease" property for objects can also screw up the end of page cut off.

Does that help at all?



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[xlbo]

Hi Catadmin - does a bit. I think this is a case of "there are not enough print options". RS seems to try and decide for you how to print.

Solved half the problem by getting rid of the "can increase" property on everything (why it decides to increase when the text isn't longer than the cell I don't know)

Other problem seems to stem from the fact that the report is quite long but we want it to print landscape (as it doesn't fit width ways on portrait). To force it to print landscape, we adjusted the Page Width / Height properties (as you alluded to above) but this then meant that the report displayed on multiple pages instead of 1 :-(

Bit of a catch 22 of our own devising I think

Cheers for backing up the "force portrait / landscape" workaround - here's hoping that the 2005 version of SSRS has some print properties associated with the report - manually placed page breaks would be perfect !!!

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[Catadmin]

here's hoping that the 2005 version of SSRS has some print properties associated with the report - manually placed page breaks would be perfect !!!

No kidding! This whole printing thing has been driving me nuts. It would be nice too if they thought to include custom page sizes for those of us who have things like plotters or scroll feed printers.

Glad I could be of some assistance, though. BTW, try altering your margins slightly to see if it stops the "page break in the middle" issue.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[xlbo]

been playing with margins and page sizes all day - my eyes are gonna start bleeding soon ;-) - we have a compromise that works and a promise that I can have SSRS 2005 as soon as our New Applications guy has checked it over.

Cheers for info - seems like you are in a bit of similar situation - trying to create a suite of reports / mini app but with minimal documentation and lots of bugs !!

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[unclerico]

hey xlbo, just wondering if you had gotten a chance to do the SSRS SP2 update and the accompanying hot fix.

 

[xlbo]

Is that the one that puts the print icon within RS ??

If so then yes - I think we have had all SPs that are available

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question