Automatic print a report via t-sql

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Automatic print a report via t-sql

Author

Topic

lordzoster
Starting Member

29 Posts

Posted - 2009-04-23 : 05:43:25

hallo I need to have a SSRS report automatically printed whenever an insert occurs on a specific table(MSSQL2008).
Hence I'd think I could make use of a trigger that prints out a SSRS report; or something similar.
Could you point me to any resource?
Thanks in advance

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-23 : 05:54:13

If there is a subscription already set up, you can have a trigger publish the subscription at will.
Start by looking at SSRS subscriptions.

E 12°55'05.63"
N 56°04'39.26"