Reporting Services Redirection to Printer

Question

Hi,

I have SQL Server 2008 R2 Standard Edition along with Reporting Services installed on a Windows Server 2008 R2 Standard Edition operating system. How can I set up a report in Reporting Services to be automatically sent to a printer instead of showing up on the browser? 

Thank you! 

Answer 1

hi,

you may use a Delivery Extension like this one: http://msdn.microsoft.com/en-us/library/ms160778(v=sql.90).aspx

I hope it helps.

Janos

---

There are 10 type of people. Those who understand binary and those who do not.
My Blog

Answer 2

Hi Amir,

The Microsoft ActiveX control, RSPrintClient, provides client-side printing for reports viewed in HTML Viewer. It provides a Print dialog box so that a user can initiate a print job, preview a report, specify pages to print, and change the margins.

I suggest you that refer to the following articles about Using the RSClientPrint Control in Custom Applications, please see:
http://technet.microsoft.com/en-us/library/ms159195(v=sql.105).aspx
http://www.codeproject.com/Articles/34146/Using-RsClientPrint-to-Print-Reports-from-ASP-NET

Regards,
Bin Long

---

Bin Long

TechNet Community Support

Answer 3

Thank you Janos and Bin. The information you provided has been helpful to me.