Report Subscriptions
Subscribing to a report from MinistryPlatform starts with running the report you want to subscribe to.
- Run the Report. Log in to MinistryPlatform and go to the report you would like to run:
- Go to Administration > Users.
- Run the Tasks Incomplete report.
- In the address bar, your link should look something like this but with different values:
https://my.domain.tld/ReportServer/Pages/ReportViewer.aspx?%2fMPReports%2fTasks%20Incomplete&rs:Command=Render&DomainID=12345A0B-9R67-4SN9-441W-1645873215DR&UserID=95668457-5578-3364-FGEA-0G3X1E1L9546&PageID=401state: =
- Dissect the URL. Keep those variable values handy, you'll need them in just a few steps!
- Log in to SQL Server Reporting Services (SSRS).Note: You should be able to get there by modifying the previous link slightly. Instead of https://my.domain.tld/ReportServer/, change the link to https://my.domain.tld/Reports/.
- Download the Report.
- In your browser window you should see a folder called MPReports.
- Click it, and find the report Tasks Incomplete. There is a search field in the upper right to narrow your selection as there are a lot of reports.
- Click the arrow next to the report title and select Download. (For version 2016, select MANAGE and then download from the manage screen.)
- Save as "Tasks Incomplete Subscription".
- Duplicate Stored Procedures.
- Open the saved report to find all of the stored procedures that make up the report within the Datasets.
- For each Dataset, find the stored procedure and create a new one with subscription name at the end of the new stored procedure name.
- Modify the stored procedure if it uses SelectionID to return the data that normally would be selected by a user.
- Modify Saved Report. The following steps assume you are using Report Builder installed on the server. Additional steps may be required if you are working on the file elsewhere.
- Link the Datasets with Subscription to this new report.
- Link the MPSubscriptions Data Source to the report.
- Save the Report.
- Subscribe to the New Report.
- Click the arrow next to the report title, and select Subscribe.
- Fill in subscription information.
- To finish, click OK.
You should now have an active (one time or recurring) SQL Subscription.
As an additional resource, see Microsoft Developer Network: Create and Manage Subscriptions.