Send SSRS Report via 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) » Send SSRS Report via Stored Procedure?

Send SSRS Report via Stored Procedure?

Rate Topic

Display Mode

Topic Options

Author

Message

kramaswamy

Posted Friday, March 22, 2013 9:33 AM

Right there with Babe

Group: General Forum Members
Last Login: Friday, May 17, 2013 1:53 PM
Points: 785, Visits: 1,534

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

kramaswamy

Posted Friday, March 22, 2013 10:08 AM

Right there with Babe

Group: General Forum Members
Last Login: Friday, May 17, 2013 1:53 PM
Points: 785, Visits: 1,534

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 »

Permissions