Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Using subscriptions in report server Expand / Collapse
Posted Tuesday, December 17, 2013 11:44 PM


Group: General Forum Members
Last Login: Today @ 6:42 AM
Points: 22, Visits: 31

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.

Post #1523951
Posted Wednesday, December 18, 2013 1:33 AM



Group: General Forum Members
Last Login: Yesterday @ 7:59 AM
Points: 2,078, Visits: 2,410
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’! **
Post #1523987
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse