Sending a Report Through E-mail

  • Article

Applies To: Operations Manager 2007 R2, Operations Manager 2007 SP1

You can configure Reporting to automatically send a published report from Operations Manager to another person through e-mail.

Before you can schedule a report for e-mail delivery, you must configure the e-mail settings in the Report Server by using the Reporting Server Configuration Manager.

To configure e-mail settings in the SQL Server 2005 Report Server

  1. Open the Reporting Services Configuration by clicking Start on the Windows taskbar, point to Programs, point to MicrosoftSQLServer 2005, point to ConfigurationTools, and then click ReportingServicesConfiguration.

  2. In Reporting Services Configuration Manager, in the Report Server Installation Instance dialog box, click Connect.

  3. In the navigation pane, click Email Settings.

  4. In the E-mail Settings pane, enter the following:

    • An e-mail address that will be used 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 text box.

  5. Click Apply, and then click Exit.

To e-mail scheduled reports

  1. In the Operations console, click the Reporting button.

  2. In the Reporting pane, click Favorite ReportsReports.

  3. In the Favorite Reports pane, right-click the Availability report, and then click Schedule.

  4. In the Subscribe to a Report Wizard, on the DeliverySettings page, do the following:

    • Type a description in the Description text box.

    • In the Delivery method list, 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.

    • In the Render Format list, click the file format you want for the report.

    • In the Priority list, select the appropriate priority.

    • Type a subject for the e-mail in the Subject text box.

    • Click Next.

  5. On the Subscription Schedule page, do the following:

    • Select one of the Generate the report options.

    • In the The Subscription is effective beginning list, type a start date and a start time for the reports that you want to generate. You can also enter the date when this subscription will end in The subscription expires on list, and then click Next.

  6. On the Parameters page, specify a span of time for the report in the From and To lists, make any other changes that you need for this report, and then click Finish.