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.

    Problem:

    How should I do it?

    I strongly believe that I need to use SQL server agent tool to make a scheduling.

    Information:

    *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.

  • You can achieve this through using subscriptions.

    Wherever the report is located (Report Server/Sharepoint etc) go to the properties and click on Manage Subscriptions. Then click Add Subscription and configure from there.


    I'm on LinkedIn

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply