Seperate Email SUbscription for Each Parameter

• Janda Nel

  SSC Eights!

  Points: 882

  More actions

  March 14, 2018 at 1:43 am

  #403175

  Good day

  I have created a ssrs report, which accepts a branch code as a parameter.

  I can create a subscription to email the report for a certain branch to a user.

  Is it possible to send a separate email for each branch (parameter) to a user? The report is too big to send all the branches in one email. It is send in excel format and has over 2 million records.

  I check in the data to specify the branches which is available. They can change and is not fixed.

  IE: If there is records for branch A and B.I want 2 emails to be spend, one for A and one for B.

  is that possible and how do I accomplish that?

  thank you

• Jo Pattyn

  SSC-Dedicated

  Points: 32070

  More actions

  March 14, 2018 at 4:03 am

  #1983110

  Looks like the data-driven subscription functionality
  https://docs.microsoft.com/en-us/sql/reporting-services/subscriptions/data-driven-subscriptions