Before you can schedule a report for e-mail delivery, you must configure the e-mail settings in the Report Server using the Reporting Server Configuration Manager.
The example in this procedure uses an availability report that you have already created and saved as a favorite. For more information about creating an availability report, see How to Create an Availability Report in Operations Manager 2007. For more information about saving a report as a favorite, see How to Save a Report in Operations Manager 2007 Favorite Reports).
To configure e-mail settings in the SQL Server 2005 Report Server
On the Windows desktop, click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click Reporting Services Configuration.
In Reporting Services Configuration Manager, in the Report Server Installation Instance Selection dialog box, click Connect.
In the navigation pane, click E-mail Settings.
In the E-mail Settings pane, enter the following:
- An e-mail address for use as the sender
address in the Sender Address text box.
- The address of the SMTP server that will be
used to send the e-mail messages in the SMTP Server
- An e-mail address for use as the sender address in the Sender Address text box.
Click Apply, and then click Exit.
To e-mail scheduled reports
Log on to the computer with an account that is a member of the Operations Manager Report Operators role for the Operations Manager 2007 management group.
In the Operations console, click the Reporting button.
In the Reporting pane, click Favorite Reports.
In the Favorite Reports pane, right-click the Availability report you saved as a favorite, and then click Schedule.
In the Subscribe to a Report Wizard, on the Delivery Settings page, do the following:
- Type a description in the Description
- Click the down arrow in the Delivery
method list, and then click Report Server E-Mail.
- Type an e-mail address of the destination
inbox to receive reports in the To text box. You can also
type e-mail addresses in the Cc, Bcc, and the
Reply To text boxes.
- Click the down arrow in the Render
Format list, and then click the file format you want for the
- Click the down arrow in the Priority
list, and then select the appropriate priority.
- Type a subject for the e-mail in the
Subject text box.
- Click Next.
- Type a description in the Description text box.
On the Subscription Schedule page, do the following:
- Select one of the Generate the report
- Type a start date and start time for the
reports to be generated in The Subscription is
effective beginning list. You can also enter the date
when this subscription will end in The subscription
expires on list, and then click Next.
- Select one of the Generate the report options.
On the Parameters page, specify a span of time for the report in the From and To lists, make any other changes you need for this report, and then click Finish.
Did you find this information useful? Please send your suggestions and comments about the documentation.