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

Send SSRS Report via Stored Procedure? Expand / Collapse
Author
Message
Posted Friday, March 22, 2013 9:33 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 8:00 AM
Points: 827, Visits: 1,693
Not really sure whether to put this in the SSRS forum or the T-SQL one - this one seems to be more active, so I'll try here :)

I've searched google for this and nobody seems to have a solid answer. It must be possible, since behind SSRS is the SQL Server ReportServer DB. Does anyone know if it is possible to execute a T-SQL command that will cause a report to get sent as an email to a user?
Post #1434336
Posted Friday, March 22, 2013 10:08 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 8:00 AM
Points: 827, Visits: 1,693
Alrighty, never mind! Bit more searching turned up the following result:

http://www.sqlservercentral.com/articles/Development/2824/

Kinda unfortunate that it is not supported by default from SQL Server 2005 Standard :/
Post #1434364
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse