Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need to print a report from Stored Procedure Expand / Collapse
Author
Message
Posted Saturday, February 02, 2008 2:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, December 15, 2009 2:07 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 7:01 PM
Points: 57, Visits: 248
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 »

Add to briefcase

Permissions Expand / Collapse