Monday, March 26, 2012

On-Demand E-Mail Delivery

Hi,
Is there a way to deliver reports via email without any subscriptions?
Because, most of the time the reports users will send will only be sent once
and if i create a subscription for each of these i'll end up with hunders of
necessary subscriptions.
Any comments and ideas are welcome. Thanks in advance.
Best regards,
VolkanI solved the problem. In case someone faces a similar situation, i'll write
down my solution for future reference. It's not exactly how i wanted it to be
but at least it works.
01. Create a TimedSubscription and store its subscription ID. (Schedule
value doesn't matter, we'll delete it anyway after email is sent)
02. Call FireEvent method of the ReportingService class with EventData
parameter set to subscription ID.
03. Get subscription list and check if the event is triggered by checking
the LastExecuted property of the subscription object.
04. If the subscription is executed call DeleteSubscription
Maybe there's a better way out there but until i find it i'll stick with
this even tough it has some drawbacks.
Regards.

No comments:

Post a Comment