Was very excited after installing SP2 to see the printer icon. It was too
much for the Managers in my company to export to PDF then print. Too much
work they said.
But once I clicked on the icon, my heart raced with excitement. Now I can
stop listening to them about how much work is involved in printing. Then I
clicked on print preview...
...my heart sunk. All that hard work in designing the report to print
lanscape on legal with specific margins is useless. All that has to be reset
in the print dialog.
Is there a way that the print dialog can grab the necessary info to properly
format before printing? Otherwise, I am back to exporting to PDF before
printing. The managers will never go for formatting their reports before
printing.
I can print landscape. Have you set your RDL properties correctly for
printing landscape?
<PageHeight>8.5in</PageHeight>
<PageWidth>11in</PageWidth>
or
<PageHeight>8.5in</PageHeight>
<PageWidth>14in</PageWidth>
--------------------
| Thread-Topic: Client Printing
| thread-index: AcVKc7LIqXRMjOMGRK2TTT9dg9/ycQ==
[quoted text clipped - 35 lines]
| printing. The managers will never go for formatting their reports before
| printing.
Cindy Lee - 26 Apr 2005 20:03 GMT
I can print landscape great, but have to check it every time, when the print
window comes up. There's no way to set it from RS is there?
> I can print landscape. Have you set your RDL properties correctly for
> printing landscape?
[quoted text clipped - 47 lines]
> | printing. The managers will never go for formatting their reports before
> | printing.
Bruce L-C [MVP] - 26 Apr 2005 21:45 GMT
I did not have to set it to landscape. If you have your page width set to 11
and page height to 8.5 then it knows it is landscape (at least in my test it
did). Go to report properties, layout to set this.

Signature
Bruce Loehle-Conger
MVP SQL Server Reporting Services
> I can print landscape great, but have to check it every time, when the print
> window comes up. There's no way to set it from RS is there?
[quoted text clipped - 54 lines]
> > | printing. The managers will never go for formatting their reports before
> > | printing.
Brian Welcker [MSFT] - 26 Apr 2005 21:57 GMT
OK, I think I understand the issue that people are having. SP2 has a new
behavior that extracts the page size and margin information at publish time
so that it can be used by the print control. Reports that were published
before SP2 do not contain these properties so they will default to 8.5" x
11" (portrait) with .5" margins. You can either set these properties by
republishing the report definition thruogh the UI or SetReportDefintion. You
can also call the SetProperties API to set them as well. I am working on a
script to post to my blog that you can use to fix this.

Signature
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
>I can print landscape. Have you set your RDL properties correctly for
> printing landscape?
[quoted text clipped - 51 lines]
> | printing. The managers will never go for formatting their reports before
> | printing.
Kevin Weir - 27 Apr 2005 04:22 GMT
Brain would you mind posting URL to your BLOG. Much appreciated
Kevin
.
> OK, I think I understand the issue that people are having. SP2 has a new
> behavior that extracts the page size and margin information at publish time
[quoted text clipped - 60 lines]
> > | printing. The managers will never go for formatting their reports before
> > | printing.
Brian Welcker [MSFT] - 27 Apr 2005 07:08 GMT
Here you go: http://blogs.msdn.com/bwelcker/.

Signature
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
> Brain would you mind posting URL to your BLOG. Much appreciated
>
[quoted text clipped - 73 lines]
>> > before
>> > | printing.
David - 29 Apr 2005 19:42 GMT
Yes
> I can print landscape. Have you set your RDL properties correctly for
> printing landscape?
[quoted text clipped - 47 lines]
> | printing. The managers will never go for formatting their reports before
> | printing.
Brian Welcker [MSFT] - 29 Apr 2005 21:57 GMT
Have you republished your report to the server since installing SP2?

Signature
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
> Yes
>
[quoted text clipped - 55 lines]
>> before
>> | printing.