Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

dynamic one time schedule in Reporting Services 2005

Hi there.
My case scenario is to email a report triggered by a new post in a database.
How can this best be done?
I'm looking into:
1. Triggering the report from a the webservice that adds the post.
2. Triggering the report from a database trigger in SQL server

My problem is that i don't know how to implement either..
I use C# btw

Any ideas people?
[403 byte] By [megatron] at [2007-11-11 8:01:36]
# 1 Re: dynamic one time schedule in Reporting Services 2005
I figured it out and it looks like it works.
I used the ReportingService2005 FireEvent() method to trigger a predefined subscription. Remember to give event rights to the user.
Now i just have to fix my smtp server to send the **** mail..

See u next time
megatron at 2007-11-11 21:48:07 >