Automate Report -> Excel -> OutLook?

Hi ,

A report must be run every monday thru friday and in the process, I want it automatically generate an e-mail that has the report attached to it. Also the subject and body must contain the sysdate and grand total of the report. The recipients are default, but it should be possible to alter them. This is possible I was told by using a subscription with a schedule.

If I create a subscription, all I can choose for delivery is Windows File Share.

Then I can select either Excel or Browser format, but not Outlook. How do I accomplish sending the report (attached as Excel) via Outlook?

Thanks in advance, Jos

PS: If I want to save my subscription I get the error:

The SQL Agent service is not running. This operation requires the SQL Agent service. (rsSchedulerNotResponding) Get Online Help


Figures the SQL Agent service is not running, but not running on my computer or on the report server or on the database server?

Hi,

Reporting Services provides an e-mail delivery extension that allows users to subscribe to reports that are subsequently delivered to electronic mailboxes. The Report Server E-mail delivery extension must be configured before you can use it. Configuring a report server for e-mail delivery requires the following:

A Simple Mail Transfer Protocol (SMTP) server or gateway. An account that has permission to send e-mail from the SMTP server. Depending on security policies in your organization, you might need to request permission in advance to send e-mail from a corporate SMTP server. Check with your system or network administrator for more information. The Report Server service must have Send As permissions on the SMTP server.

To configure report server e-mail, you can use the Reporting Services Configuration tool or you can edit the configuration files. The Reporting Services Configuration tool provides the minimal settings that the report server requires. If you want to use a local SMTP service or specify advanced settings, modify the configuration files instead.

The Outlook is a client application to view an email.

A subscription job uses the SQL Agent Service to run in schedule. So, you should need to startup the SQL Server Agent service before subscribing a report.

For more information, please see:

How to: Configure a Report Server for E-mail Delivery (Reporting Services Configuration):

How to: Configure a Report Server for E-mail Delivery (Reporting Services Configuration)



If you have any more questions, please feel free to ask.

Hi,

do u want to try data driven subscription?
This might be one of the solution for your case

__________________
Shaalini.S
Be the Best of Whatever you are...

Hi,

however, you can also use SSIS and SSRS combination to achieve this.
Lete me know if you need further help about this but i would suggest that look for the data driven subscription

Thanks

__________________
Shaalini.S
Be the Best of Whatever you are...

Hi,

Reporting Services provides an e-mail delivery extension that allows users to subscribe to reports that are subsequently delivered to electronic mailboxes. The Report Server E-mail delivery extension must be configured before you can use it. Configuring a report server for e-mail delivery requires the following:

A Simple Mail Transfer Protocol (SMTP) server or gateway.
An account that has permission to send e-mail from the SMTP server. Depending on security policies in your organization, you might need to request permission in advance to send e-mail from a corporate SMTP server. Check with your system or network administrator for more information.
The Report Server service must have Send As permissions on the SMTP server.

To configure report server e-mail, you can use the Reporting Services Configuration tool or you can edit the configuration files. The Reporting Services Configuration tool provides the minimal settings that the report server requires. If you want to use a local SMTP service or specify advanced settings, modify the configuration files instead.


The Outlook is a client application to view an email.

A subscription job uses the SQL Agent Service to run in schedule. So, you should need to startup the SQL Server Agent service before subscribing a report.

For more information, please see:

How to: Configure a Report Server for E-mail Delivery (Reporting Services Configuration):

How to: Configure a Report Server for E-mail Delivery (Reporting Services Configuration)

__________________
A.Rajesh Khanna

Hi ,

Thanks a lot, I will pass the info to our network team. I am just a programmer, not qualified to install software.