What would you like to know more about?

Report Subscriptions

Subscribing to a report from MinistryPlatform starts with running the report you want to subscribe to.

  1. Run the Report. Log in to MinistryPlatform and go to the report you would like to run:
    1. Go to Administration > Users.
    2. Run the Tasks Incomplete report.
    3. 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: =
  2. Dissect the URL. Keep those variable values handy, you'll need them in just a few steps!
  3. 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/.
  4. Download the Report.
    1. In your browser window you should see a folder called MPReports.
    2. 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.
    3. Click the arrow next to the report title and select Download. (For version 2016, select MANAGE and then download from the manage screen.)
    4. Save as "Tasks Incomplete Subscription".
  5. Duplicate Stored Procedures.
    1. Open the saved report to find all of the stored procedures that make up the report within the Datasets.
    2. For each Dataset, find the stored procedure and create a new one with subscription name at the end of the new stored procedure name.
    3. Modify the stored procedure if it uses SelectionID to return the data that normally would be selected by a user.
  6. 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.
    1. Link the Datasets with Subscription to this new report.
    2. Link the MPSubscriptions Data Source to the report.
    3. Save the Report.
  7. Subscribe to the New Report.
    1. Click the arrow next to the report title, and select Subscribe.
    2. Fill in subscription information.
  8. 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.