Print RS Report without Prompting - Client Side
Hi friends,
I have a little problem. I dont know how to print a Reporting Services Report (2008) from a web Application in the client side and detecting automatically the default printer without prompting. Searching I found the following solutions:
1. Using the Reporting Services XML Web service and C#.
2. Using the ocx RSClientPrint.cab.
The idea is avoid doing innecesary configuration changes in the client´s IE and the IIS Server, and avoiding to install plugins in the client ´s IE. I dont know if there are a better solution.
I expect you can help me and give me an helpfull orientation. Thanks.
January 30th, 2011 3:44am
Hi
So you do you want the user clicks on report it will be automatrically printed to his/her default printer?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
January 30th, 2011 3:58am
Hi Uri Dimant,
No, I want to control the printing using a secondary button. When I fire this secondary button I want to print the RS Report directly (without prompting) in the selected default printer on the client side.
Thanks.
January 31st, 2011 10:01am
Hi,
There is a similar thread, which want to avoid the print dialog. Generally, if you want to print report directly, you need to do some coding. You can
implement custom application to do so:
1. Use the "Render" method from SQL Server Reporting Service web service to render the report to an EMF file.
2. Use the PrintDocument .NET object to print the image file using a specified printer in specified size.
If you have installed SQL Server Reporting Services product sample, you will find a print delivery sample at the following location by default. You can
use the sample code in the custom application:
C:\Program Files\Microsoft SQL Server\100\Samples\Reporting Services\Extension Samples\PrinterDelivery Sample
For more information, please refer to:
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/ac5c4268-7c56-42b3-a35e-0a7fbbe9e685
Thanks,
Albert Ye
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2011 3:22am
Hi Albert Ye,
Reading your reference, it explains I have to use the RSClientPrint ActiveX control to print RS reports. I dont know if there is another solution for printing without prompting because I would not prefer to make
configuration changes in the client´s IE, the IIS Server and avoiding to install plugins in the client ´s IE.
I expect you could help me. Thanks.
February 3rd, 2011 1:40pm
Hi,
To skip the "Print" dialog to print report directly, as I said before, you can implement a custom application to call the "Render" method of SSRS web service and then
use PrintDocument .NET object to print it. This workaround don't need to configure IIS and client's IE. You can deploy the custom application to client instead of IE plugins.
However, to avoid the configuration of IIS and client's IE, a possible workaround I can think is that use the Printer Delivery Extension to print report, but it's
a delivery solution and need complicated coding.
Thanks,
Albert Ye
Free Windows Admin Tool Kit Click here and download it now
February 4th, 2011 8:49am
Albert Ye,
According your response,
to avoid the configuration of IIS and client's IE I have to use the Printer Delivery Extension to print report. I dont know if you have some examples for reading. Or maybe another easier solution exists.
Thanks,
February 5th, 2011 10:56am
Albert Ye,
According your response,
to avoid the configuration of IIS and client's IE I have to use the Printer Delivery Extension to print report. I dont know if you have some examples for reading. Or maybe another easier solution exists.
Thanks,
Free Windows Admin Tool Kit Click here and download it now
February 5th, 2011 10:56am