Send SSRS Report via Stored Procedure?

• kramaswamy

  SSCoach

  Points: 18181

  More actions

  March 22, 2013 at 9:33 am

  #272478

  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?

• kramaswamy

  SSCoach

  Points: 18181

  More actions

  March 22, 2013 at 10:08 am

  #1599853

  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 :/