I need to send some reports only when there is data in the relevant tables.This is totally random and could be at anytime during a given day or any day the week.This involves multiple reports and the user is adamant that she does not have time to initiate the reports herself.Any ideas how this can be accomplished?
Sorry for the late reply. Not with out-of-the-box SSRS - it supports schedule-based or report snapshot based (which are schedule-based) subscriptions only. If you can code the logic to make a decision whether data changed you can try these approaches:
1) Dummy subscription (never fires itself) and your application that fires that subscription with FireEvent SOAP API.
2) Custom delivery extension may serve your needs. You can create time-based (for periodic checks) data-driven (with query to analyze whether data changed) subscription and decide within you extension whether to deliver report.
|||Hi Igor:
I have a similar problem, and would like to fire my Subscription Event from an SSIS package that gets triggered when a particular folder receives data files.
I have a Subscription in my Report Server and a Job in SQL agent. How can I call either of them from SSIS?
TIA
Kar
No comments:
Post a Comment