Skip to content

Knowledge Base

White Paper Libary

Building a task that sends a Microsoft Reporting Services Report by email

This example will create a task that automates the running of a Microsoft Reporting Services Report. The task runs regularly based on a schedule, it queries the database of a database system, runs a Reporting Services Report and sends the report via email to a specified user.


This task is made up of 4 steps:

Step NameToolWhat it does
Daily ScheduleEvent: ScheduleDetermines how frequently the task is to run.

Scheduling a Task

Retrieve InformationInput: Database Query (ODBC)Reads the database of a business system to find details to map to parameters in the report.

Querying a database

Run MS Reporting Services ReportFormat: Run Microsoft Reporting ServicesUses data obtained by the query and presents it in the report.

Running a Micosoft Reporting Services Report

Send EmailOutput: Send Email (SMTP)Sends an email containing the report
Sending an email

To read about designing other tasks see:

Task Design