report looping for n values

• sql_novice_2007

  Hall of Fame

  Points: 3307

  More actions

  September 25, 2013 at 8:56 am

  #277488

  Hi,

  I have report that takes state as parameter and executes the stored proc and generate the report data.Since I need to run this report for all the 50 states in USA I created a subscription for each state and generating report for each state.

  But is there any way I can loop the report for all 50 diff states instead of creating a subscription for each state?

  Thanks.

• sql_novice_2007

  Hall of Fame

  Points: 3307

  More actions

  September 25, 2013 at 11:02 am

  #1653276

  I am able to implement with this data driven subscriptions.

  Thanks.