Data-Driven Subscriptions
If your organization has standard SSRS (SQL Server Reporting Services), you can create 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 you've updated that report since the last time you sent it. For example, you can send yourself a report that shows all of your incomplete tasks every Monday. The report sends every Monday, whether or not you have any incomplete tasks.
- If your organization owns the Enterprise version of SQL Server Reporting Services, you can create Data-Driven Subscriptions.
- Data-Driven Subscriptions provide the ability to write a query that passes multiple lists of emails and parameters on a schedule to the report so that the same report sends to different people with different parameters.
- If you set up a subscription to a MinistryPlatform report and then deployed an update to that report, your subscription won't be deleted and you shouldn't need to set it up again.
- You can write Data-Driven Subscription queries 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 receive 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.
You can use a Data-Driven Subscription 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 log in to MinistryPlatform and run this report whenever someone registers.