How do I do an automated export of a report to an excel file & email it

• Resender

  SSCertifiable

  Points: 7443

  More actions

  October 16, 2014 at 6:14 am

  #297518

  So I got a request to do the following

  *Make a view to get all the people the report needs to be mailed to

  *Generate the report for each person (I got the rdl file for the report & it takes the username from the view as input parameter)

  *Export the report to excel

  *Send the report via sql mail to the users

  But I have to admit I haven't the fogiest how to begin

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  October 16, 2014 at 6:51 am

  #1752834

  Take a look at data driven subscriptions:

  Create a Data-Driven Subscription

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Resender

  SSCertifiable

  Points: 7443

  More actions

  October 17, 2014 at 1:26 am

  #1753044

  OK,that works thanks