Post reply

Need to print a report from Stored Procedure

  • 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.

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply