Post reply

Using subscriptions in report server

  • 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

  • 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’! **

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

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