Export reports from SSRS to EXCEL for Email Attachments - SQL Server 2005

milani_lucie
milani_lucie used Ask the Experts™
on
Hi,

Can you please let me know how to:
Export reports from SSRS to EXCELfor Email Attachments in SQL Server 2005 ?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
If you are wanting to set this up on a shedule that will automatically send an email with an excel attachment, then you can do this by setting up a subscription.
http://www.sqlshare.com/ReportingServicesEmailSubscriptions_731.aspx
 
Is that what you need, or are you just trying to export from within Report Manager (or Sharepoint) manually to attach to an email?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial