HELP!!! Printer Delivery Extension not Printing Landscape

Hello All,

I'm using SQL Server 2005 Reporting Services, and I'm trying to have subscriptions print. To try this, I built, installed, and configured the printer delivery extension sample provided by Microsoft.

Everything appeared to be working fine. That is, I can schedule a report to print automatically using the printer delivery extension. However, the problem is that the reports always print portrait.

We have a number of reports--some are portrait and some are landscape. So, obviously, I need the landscape reports to print lanscape.

I've even tried "hard-coding" the page width and page height parameters in the printer delivery extension to try to force it to print landscape, but it still always prints portrait.

Would any one know how to have reports that are delivered to a printer actually print in the way they are created (i.e., print landscape if the report is set up as a landscape report)?

Do I have to use the IMAGE format? Could I use PDF? If so, how?

Thanks!

Hi,

there is a likewise issue if you use linked reports in RS - the linked report does not contain the original page settings.

It probably could be that you would have to set the page settings programmatically like described by Brian Welcker for the linked reports:
http://www.fits-consulting.de/blog/PermaLink,guid,e3f1cf4a-f9d6-44d8-86e5-84a59531f87c.aspx

hth...

cheers,
Markus

|||

Thanks for the info. Markus. Unfortunately, setting the page settings programmatically didn't help. All reports and linked reports always print portrait, not landscape.

Therefore, would any one have any ideas on how to use the printer delivery extension and make scheduled reports be delivered automatically to a printer and acutally print in landscape?

Please see me original post and let me know if more info. is needed to answer my questions.

Thanks!

HELP! Printer Delivery Extension AND Forms Authentication

Hi,
I need some help with making the Printer Delivery Extension play nicely with
RS equipped with Forms Authentication/Custom Security. We have been using the
forms authentication for some time but just recently decided to implement the
Printer Delivery Extension.
The Problem:
With Forms Authentication, the Printer Delivery Extension CANNOT SEE NETWORK
PRINTERS.
I am sure this has something to do with permissions but what I am unsure
about is how to go about resolving this issue.
Basically when we try to use a network printer and then try to specify that
network printer for a subscription using the Printer Delivery Extension, the
Extension calls the IsValidPrinter() method which loops through the
PrinterSettings.InstalledPrinters collection looking for the printer I
specified. ONLY the local printers are displaying in that collection, no
network printers. I know this because I attached to the process and debugged
it inspecting the contents of that collection. So I know for sure NONE of the
network printers are in there.
Any help would be greatly appreciated!
Thanks,
Nick @. INDATAAre you using 2000 or 2005 version?
--
Markus Pöhler
netpoint-edv gmbh
Germany
"Nick P @. INDATA" wrote:
> Hi,
> I need some help with making the Printer Delivery Extension play nicely with
> RS equipped with Forms Authentication/Custom Security. We have been using the
> forms authentication for some time but just recently decided to implement the
> Printer Delivery Extension.
> The Problem:
> With Forms Authentication, the Printer Delivery Extension CANNOT SEE NETWORK
> PRINTERS.
> I am sure this has something to do with permissions but what I am unsure
> about is how to go about resolving this issue.
> Basically when we try to use a network printer and then try to specify that
> network printer for a subscription using the Printer Delivery Extension, the
> Extension calls the IsValidPrinter() method which loops through the
> PrinterSettings.InstalledPrinters collection looking for the printer I
> specified. ONLY the local printers are displaying in that collection, no
> network printers. I know this because I attached to the process and debugged
> it inspecting the contents of that collection. So I know for sure NONE of the
> network printers are in there.
> Any help would be greatly appreciated!
> Thanks,
> Nick @. INDATA|||SQL Server 2000, RS SP2
"MarkusPoehler" wrote:
> Are you using 2000 or 2005 version?
> --
> Markus Pöhler
> netpoint-edv gmbh
> Germany
>
> "Nick P @. INDATA" wrote:
> > Hi,
> >
> > I need some help with making the Printer Delivery Extension play nicely with
> > RS equipped with Forms Authentication/Custom Security. We have been using the
> > forms authentication for some time but just recently decided to implement the
> > Printer Delivery Extension.
> >
> > The Problem:
> > With Forms Authentication, the Printer Delivery Extension CANNOT SEE NETWORK
> > PRINTERS.
> >
> > I am sure this has something to do with permissions but what I am unsure
> > about is how to go about resolving this issue.
> >
> > Basically when we try to use a network printer and then try to specify that
> > network printer for a subscription using the Printer Delivery Extension, the
> > Extension calls the IsValidPrinter() method which loops through the
> > PrinterSettings.InstalledPrinters collection looking for the printer I
> > specified. ONLY the local printers are displaying in that collection, no
> > network printers. I know this because I attached to the process and debugged
> > it inspecting the contents of that collection. So I know for sure NONE of the
> > network printers are in there.
> >
> > Any help would be greatly appreciated!
> >
> > Thanks,
> >
> > Nick @. INDATA|||Can someone please help?
"Nick P @. INDATA" wrote:
> Hi,
> I need some help with making the Printer Delivery Extension play nicely with
> RS equipped with Forms Authentication/Custom Security. We have been using the
> forms authentication for some time but just recently decided to implement the
> Printer Delivery Extension.
> The Problem:
> With Forms Authentication, the Printer Delivery Extension CANNOT SEE NETWORK
> PRINTERS.
> I am sure this has something to do with permissions but what I am unsure
> about is how to go about resolving this issue.
> Basically when we try to use a network printer and then try to specify that
> network printer for a subscription using the Printer Delivery Extension, the
> Extension calls the IsValidPrinter() method which loops through the
> PrinterSettings.InstalledPrinters collection looking for the printer I
> specified. ONLY the local printers are displaying in that collection, no
> network printers. I know this because I attached to the process and debugged
> it inspecting the contents of that collection. So I know for sure NONE of the
> network printers are in there.
> Any help would be greatly appreciated!
> Thanks,
> Nick @. INDATA