Need to print a report from Stored Procedure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Need to print a report from Stored Procedure

Need to print a report from Stored Procedure

Rate Topic

Display Mode

Topic Options

Author

Message

punithmsc

Posted Saturday, February 02, 2008 2:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 06, 2008 11:52 PM
Points: 2, Visits: 9

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.

Post #450854

belgarion

Posted Tuesday, December 15, 2009 2:07 PM

Valued Member

Group: General Forum Members
Last Login: Sunday, April 21, 2013 6:28 PM
Points: 53, Visits: 198

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.

Post #834751

« Prev Topic | Next Topic »

Permissions