Hello all,Does anyone know how to print the reports automatically in Reporting Services 2005 or 2008.ThanksDeekshit

Hi Deekshit, it'snot a easy. If you want to automate exporting a report to a file or email attachment, just schedule a standard or data-driven subscription will achieve that. But to achieve printing automatically, you need more work in programming. A similar thread about printing automatically Here are two solutions: 1. Using Printer Delivery Extension to deliver a report to a printer. [Quote] Although users cannot specify a printer as a target delivery destination in a subscription, SQL Server Reporting Services includes a sample Printer Delivery extension that shows developers how to author a delivery extension that provides this functionality. By creating a custom delivery extension, a developer can provide subscription users with the ability to route a report directly to a printer on a scheduled basis, with no user intervention required. For more information, see Printer Delivery Extension Sample and Introducing Delivery Extensions. [/Quote] 2. Using the RSClientPrint Control in Custom Applications to accomplish the task. a) Create a new Webpage, and embed the RSClientPrint. b) Using Javascripts and URL access to print the report in Javascript function. c) Let the printing function auto run when page loading. d) Schedule a windows job to open the page. Solution 2 is not a good idea, because you still need to create an application to click the Ok button. When you call the RSClientPrint, it will display a window for confirming. Here are some valuable documents for your reference in SQL Server Books Online: Delivering Reports Through Subscriptions: http://msdn.microsoft.com/en-us/library/ms159762(SQL.90).aspx Printing Reports: http://msdn.microsoft.com/en-us/library/ms155993(sql.90).aspx Using the RSClientPrint Control in Custom Applications: http://msdn.microsoft.com/en-us/library/ms159195(sql.90).aspx Please let me know if this helps. Raymond

Thanks For your Reply Raymond.I will go through it and will let you know

we have used the reporting web service in built merhods to achieve this functionality. we used the SSRS web service to render it to pdf and then used our in built framework to print the reports. Thanks