I have an rdlc report  which gets executed from aspx page using reportviewer control in asp.net 2.0 . Now users want this report to be mailed to them in EXCEL/PDF format by changing the period parameter values (like every forth night period from and period to will change) . I can do this using console application  for changing parameter value . However I am not aware how to catch the response , export the executed rdlc to excel or PDF and add it as attachment to mail etc .

Has anyone done this type of work before? Please spare your valuable time to send solution or links of any useful article .

 I know subscription is possible in reporting server 2000/2005 . However , We don't have seperate reporting server and hence limited to web server

Bhat 

Hi,

From your description, it seems that you want to subscribe the PDF/EXCEL report from the reporting service via email, right?

Reporting service has built in subscription features. Since you mentioned that you don’t have separate reporting server because of the limited to web server. Then, I think you should call the global method to export the report, retrieve the report via web service and re-assemble bytes into file, save it on disk. And import the System.Web.Mail namespace to use the mail APIs in ASP.NET.

You may try the following articles which show the details.

http://channel9.msdn.com/ShowPost.aspx?PostID=87032

http://www.aspnettutorials.com/tutorials/email/email-attach-aspnet2-csharp.aspx

Thanks.