Karatas, FERHAT
I would love to change the world, but they won't give me the source code!
E-Mail Delivery in Reporting Services
28.10.2006 09:18:35 - Filed under : Asp.net | Windows App.
To distribute or receive a report by e-mail, you define either a standard subscription or a data-driven subscription. You can subscribe to or distribute only one report at a time. You cannot create a subscription that delivers multiple reports in a single e-mail message.
Reporting Services includes an e-mail delivery extension that provides a way to e-mail a report to individual users or groups. The e-mail delivery extension is configured through the Reporting Services Configuration tool and by editing the Reporting Services configuration files.
E-Mail Delivery Options
Report server e-mail delivery can deliver reports in the following ways:
  • Send a notification and a hyperlink to the generated report.
  • Send a notification in the Subject: line of an e-mail message. By default, the Subject: line in the subscription definition includes the following variables that are replaced by report-specific information when the subscription is processed:
    @ReportName specifies the name of the report.
    @ExecutionTime specifies when the report was executed.
    You can combine these variables with static text or modify the text in the Subject: line for each subscription.
  • Send an embedded or attached report. The rendering format and browser determine whether the report is embedded or attached.
    If your browser supports HTML 4.0 and MHTML, and you choose the Web archive rendering format, the report is embedded as part of the message. All other rendering formats (CSV, PDF, and so on) deliver reports as attachments. You can disable this functionality in the RSReportServer configuration file.
    Reporting Services does not check the size of the attachment or message before sending the report. If the attachment or message exceeds the maximum limit allowed by your mail server, the report will not be delivered. Choose one of the other delivery options (such as URL or notification) if for large reports.
To create an e-mail subscription
  • In Report Manager, on the Contents page, navigate to the report you want to subscribe to. Click the report to open it.
  • Click the Subscriptions tab, and then click New Subscription.
  • For the method of delivery, select Report Server E-Mail from the Delivered by list box.
  • In the To text box, type the e-mail address you want the report delivered to. To specify multiple e-mail addresses, separate them with a semicolon (;). You can also type additional e-mail addresses in the Cc, Bcc, and Reply-To text boxes.
  • Select the delivery options as follows:
    • To embed or attach a copy of the report, select Include Report. The format of the report is determined by the rendering format you select below. Do not choose this option if you think the report size will exceed the limit defined for your e-mail system.
    • To include a URL link to the report in the body of the e-mail message, select Include Link.
  • Choose a rendering format from the Render Format list box. This option is available if you select Include Report to embed or attach a copy of the report.
    • To embed the report in the body of the e-mail message, select Web archive.
    • To send the report as an attachment, choose any of the other rendering formats.
  • Select a priority from the Priority list box. In Microsoft Exchange, this setting sets a flag for the importance level of the e-mail message.
  • Specify when you want the report delivered:
    • To specify a delivery schedule, click When the scheduled report run is complete and click Select Schedule. A schedule page opens for you.
    • To deliver the report when a report snapshot is updated with a newer version, click When the report content is refreshed. The schedule used to update a report snapshot determines when your subscription is processed.
  • For parameterized reports, specify parameters to use for the report for this subscription. The parameters that you specify can be different from those used to run the report on demand or in other scheduled operations.

Related Terminology : Reporting services, e-mail delivery options
with 1 comments

dasdsad says ;
12.11.2010 12:25:57

What do you think ?
Security Code 6365
Check S. Code
Home Page