Send Message with SSRS to user's Email Acount Automatic


  • Goal: 
    Make the user to retrieve an incoming message to their e-mail account containing a report document once in a month. 

    How should I do it? 
    I strongly believe that I need to use SQL server agent tool to make a scheduling. 

    *The report's document is created in SSRS.
    *The document's content and data is filtered by two parameter, their full name and today's date. before you send it to their email account.
    *Data source is SSAS in SSRS.
    *All users is located in a domain.
    *The e-mail adress and full name is located in the data mart.

    Saturday, November 16, 2013 9:45 PM