HI, I want to send an SSRS report manually not a scheduled one like on button or link click. How to do that? Is there any features in BIDS like that?

There is no option in BIDS to send a SSRS report manually thru mails. Export the report and use your outlook client or Suresh http://skamie.wordpress.com

Hi, Suresh is right. However, there have some possible workarounds. We can configured a subscription(but don't start it), and use SQL Server Reporting Services(SSRS) web service to fire it. The method to fire an event is FireEvent. Below are two similar threads for your reference: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/b6596c3f-446b-4dea-9501-f3af13435b86 http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/a475cbbb-73bb-4b96-ab43-aa94dff11855 If there is anything unclear, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT