Need to print a report from Stored Procedure

• punithmsc

  Old Hand

  Points: 342

  More actions

  February 2, 2008 at 2:13 am

  #202992

  My requirement is suppose , i have a schedular i use to run this schedular at fixed interval , this will call an SP. This sp will send reports which is designed in SQL Server Reporting Services to printer for printing

  can we do like this? if so can you please send some sample code for this?

  Just i want a code for calling the report and send them to printer.

• belgarion

  SSC-Addicted

  Points: 493

  More actions

  December 15, 2009 at 2:07 pm

  #1092734

  Hi punithmsc,

  If you're on SQL2005 or above there's a SSRS SDK sample to do what you describe by extending rendering to include printing. You then use SSRS subscriptions to scheduled the report.

  While SDK sample is "unsupported" I've used it twice with no issues. Allow about 2 days to install the SDK sample and get familiar with what it does (and what it doesn't as there are a few gotchas). Once done, its all pretty standard SSRS from there on.

  Good Luck.