Subscribe to a Report
Steps to create a SQL subscription report.
You should now have an active (one-time or recurring) SQL subscription.
As an additional resource, see Microsoft Developer Network: Create and Manage Subscriptions.
Subscription Information
A list of common subscription fields you'll encounter in the Platform and what they mean.
Subscription Fields
- Delivered By
- The default is email. Alternatively, you can export to a Windows file share.
- To
- The destination email address of the person receiving the message.
- CC
- Any carbon copied recipients. These recipients can see they were copied.
- BCC
- Any blind carbon copied recipients. These recipients can't see they were copied.
- Reply-To
- The email you want to receive any reply messages.
- Subject
- The title of the email.
- Include Report
- Select whether to attach the report to the email and what format.
- Include link
- Select whether to include the link to the report in the message. You must have Windows rights to get to the reports server through MinistryPlatform.
- Priority
- The importance of the message (low, normal, high).
- Comment
- The body of the message.
- Select Schedule
- Select when and how often (one-time or recurring) you want to run the subscription.
URL Elements
For most reports in MinistryPlatform, you need the following elements from the URL of the report you want to subscribe to. Those elements are:
- DomainID
- An alphanumeric string representing your MinistryPlatform installation.
- UserID
- An alphanumeric string that tells you who is running the report. If the report is contextually sensitive to the person that runs it, the report reflects that particular person. If you need to display a different person from the one displayed in the executed report, copy that person's GUID from and use it for this field.
- PageID
- The number representing the specific page you requested the report from.
- SelectionID
- Optional. The number indicating the selection of records to pass the report.
Report-specific Fields
The following values differ depending on the report:
- Completed
- What type of tasks to look for.
- Tasks to include
- Which tasks to include.
- Tasks starting after
- Use this field if you want to specify a firm start date.