Your Knowledge Base is moving on 3/25/24! Our new Help Center provides all the articles you know and love (plus so much more) in a one-stop shop. Ask your SPoC for details!

Data Driven Subscriptions

 

If your organization has standard SSRS (SQL Server Reporting Services), you have the capability of creating a standard subscription. With this type of subscription, a static list of people can receive the same report on a set schedule, whether or not that report has been updated since the last time it was sent. For instance, you can send yourself a report that shows all of your incomplete tasks every Monday. The report will be sent every Monday, whether or not you have any incomplete tasks. 

Data Driven Subscription Basics
  • If your organization owns the Enterprise version of SQL Server Reporting Services, you have the capability to create Data Driven Subscriptions. 
  • Data Driven Subscriptions provide the ability to write a query that will pass multiple lists of emails and parameters on a schedule to the report so that the same report is sent to different people with different parameters. 
  • If you set up a subscription to a MinistryPlatform report and then an update is deployed to that report, your subscription will not be deleted and you shouldn't need to set it up again.
  • Data Driven Subscription queries can be written to accompany existing reports or new reports.
Example Scenario

A user can subscribe to a report called "Incomplete tasks" to have their version of that report delivered to their inbox every Monday. The user gets that report whether information has changed or not.  and whether they have incomplete tasks or not.

A more advanced user can write a query, then put it into a Data Driven Subscription to get back a list of active staff members with one or more incomplete tasks every Monday and send each of those staff members a personalized version of the Incomplete Tasks report.

A Data Driven Subscription can be used to send a report to a Missions Team leader of each new person's custom form responses when the new person registers. This prevents the Mission Trip Leader from having to login to MinistryPlatform and run this report whenever someone registers.

 

Existing projects were provided with no warranty or support. Any changes or fixes will be subject to availability and billed at the prevailing hourly rates.