Post reply

Email same ssrs report to different users but with data specific to that user

  • November 29, 2012 at 8:57 pm

    #393706

    Hi,

    We have a report that is used to grade our sales agents. I am try to create a subscription that will run every evening that will send the agents their individual test scores.

    I need the report filter the data down to the agent's email address (or userid) and then email that specific agent his/her test score.

    Is there a way to create a subscription that could do this?

    I'm trying to avoid the creation of a separate subscription per agent.

  • November 30, 2012 at 2:08 am

    #1564202

    What version of SQL are you running? Enterprise or Standard? If Enterprise look at data driven subscriptions, if Standard then you will need to create a lot of subscriptions for each agent and their specifc data.

  • November 30, 2012 at 4:20 am

    #1564263

    Thanks,

    We're on enterprise so I'll dig into the data driven solution

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

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