I want ssrs Report 2008 subcription with Email Delivery when report server in sharepoint integrated mode i deployed ssrs reports in Project web access(PWA) analyticsreports library

Please go through this - http://msdn.microsoft.com/en-us/library/bb283186.aspx

I Already tried to do this but when i create a subscription for report server e-mail delivery i could not find option E-mail under Delivery Extension .is it necessary to configure SMTP for that option .Yashwant Singh Mourya.

Hi, Yes, first you need to configure SSRS for email delievry and then you will get an option. To do this kindly visit http://technet.microsoft.com/en-us/library/ms159155.aspx- Chintak (My Blog)

Thanks Chintak & shahfaisalYashwant Singh Mourya.

We are using the Exchange server, and how do we leverage this for subscription any ideas on this???Yashwant Singh Mourya.

Hi Yashwant Singh Mourya, From your scenario, you are using exchange server as mail server, right? If in that case, you can set your exchange server as SMTP server. The mail server must be an SMTP server or forwarder. Report server e-mail delivery is implemented on Collaboration Data Objects (CDO) and requires a local or remote Simple Mail Transfer Protocol (SMTP) server or SMTP forwarder. Note: SMTP is not supported on all Windows operating systems. If you are using the Itanium-based edition of Windows Server 2008, SMTP is not supported. Please take the following steps to configure Email Settings. 1. Verify that the Report Server Windows service has Send As permissions on your SMTP server. 2. Open the RSReportServer.config file in a text editor through the path: C :\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer. 3. Verify that <UrlRoot> is set to the report server URL address. This value is set when you configure the report server and it should be filled in already. If it is not set, type the report server URL address. 4. In the Delivery section, find <Report Server Email>. 5. In <SMTPServer>, type the name of the SMTP server. This value can be an IP address, a UNC name of a computer on your corporate intranet, or a fully qualified domain name. 6. Verify that <SendUsing> is set to 2. If it is set another value, the report server is not configured to use a remote SMTP service. 7. In <From>, type the name an account that has permission to send e-mail from the SMTP server. 8. Save the file. After you do steps above, you can find E-Mail delivery extension display in the Delivery Extension drop-down list when you create a new subscription in SharePoint. For more details, you can see the following article, How to: Configure a Report Server for E-mail Delivery (Reporting Services Configuration): http://msdn.microsoft.com/en-us/library/ms345234(v=SQL.100).aspx If you have any question, please feel free to ask. Thanks, Eileen