Using subscriptions in report server

• aar.mba

  SSC-Addicted

  Points: 438

  More actions

  December 17, 2013 at 11:44 pm

  #283720

  Hi,

  I'm Aarthi.

  I have a requirement that I need a schedule a report so that it runs for every ten minutes and sending email alerts.

  I have done it. But the problem is, the report has four parameters like DeliveryTicket,from date,to date and order type.

  I need to make it dynamic so that each time of execution it takes the next value of the parameter and send a alert for the same.

  Can anyone help me. I used cursors also but its not working out.

  Regards,

  Aarthi.R

• HanShi

  SSC-Dedicated

  Points: 33511

  More actions

  December 18, 2013 at 1:33 am

  #1674304

  See if you are able to hold the last used report parameters in a table. For the next report read the parameters from the table and determine the new parameters from these values. Store the used report parameters again afterwards.

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **