Hi all,

I have created one report project. Is it possible to send generated PDF or EXCEL report by email ?

And also can we schedule this process?

Thanks in advance

Regards,

SG

Try the below link:

http://beyondrelational.com/modules/2/blogs/101/posts/13460/ssrs-60-steps-to-implement-a-data-driven-subscription.aspx

Yes you can set subscriptions

see

http://www.databasejournal.com/features/mssql/data-driven-subscription-in-ssrs-2008-r2.html

Try the below link:

http://beyondrelational.com/modules/2/blogs/101/posts/13460/ssrs-60-steps-to-implement-a-data-driven-subscription.aspx

• Proposed as answer by Vicky_LiuMicrosoft contingent staff, Moderator 10 hours 7 minutes ago
• Marked as answer by Vicky_LiuMicrosoft contingent staff, Moderator 2 hours 9 minutes ago

Hi SG,

SQL Server 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 Manager and by editing the Reporting Services configuration files.

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.

Before create an subscription, you need to Configure a Report Server for E-Mail Delivery (SSRS Configuration Manager):
E-Mail Delivery in Reporting Services

As Latheesh NK and Visakh16 have provide link with detail information about how to create an Data-Driven subscription. you can reference to article below about how to create an standard Subscription:
see Create, Modify, and Delete Standard Subscriptions (Reporting Services in Native Mode).

Not all edition are supported to create an subscriptions:
Features Supported by the Editions of SQL Server 2012

If you still have any problem, please feel free to ask.

Regards
Vic

Hi,. 

Yes.. Thank you all 

Regards,

SG