Automatically print SSRS report?

Question

Is there a way to automatically print a report from SQL Server Reporting Services (2005)?

EDIT:

We needed to print the SSRS report on a network printer programmatically. In particular, we wanted to remove this from the stored procedure. We are currently using the asabanshee method and it works. However, we would like something more manageable, without dependence on Adobe Acrobat and xp_cmdshell. We consider this method proposed by Paul G.

Answer 1

You should be able to do this programmatically using the built-in web service to make a report. Sample code for SSRS 2000 is here , but it should be close to what you need in 2005, and I think:

Answer 2

This question was sent by an employee for me. My comments and permission:

Background: I essentially wanted to hide SSRS reports to network printers in our corporation through their UNC. I have a real-time quality monitoring application (for an industrial production facility) powered by SQL Server. When serious defects were discovered, I wanted to send a report to QA printers for defect analysis. It also complements our pager / email alert system to stop problems as they arise.

Solution: I wrote a SQL stored procedure to control quality failures. When they are found, the stored procedure calls the .Net console application using xp_cmdshell, passing the product identifier, UNC path, report name, path to the Adobe Reader file (on SQL Server), and several other parameters. Please note: the console application is located on the same server as SQL Server. The console application accepts the parameters and transfers them to SSRS with the output PDF format. A PDF is created and saved locally, then console applications launch the command line using the Adobe Reader hidden mode (/ t). The file path and UNC path are passed as parameters, and voila is used to automatically print SSRS files. An optional parameter tells the console application whether to delete the locally saved PDF.

Answer 3

If you use Microsoft Business Intelligence Editor to create your SSRS, you can write code to start the print job.