Call SSRS snapshot report dynamically

• risehotsun

  Newbie

  Points: 5

  More actions

  October 2, 2014 at 11:06 am

  #311512

  Hi Guys,

  We are setting up a new reporting environment for our client and as part of the deliverable I need to achieve the following two things, on which I need expert's advise.

  1. Most of our reports are snapshot reports and all the data needed gets populated into transaction DB tables from a batch program. Some of batches run monthly and others on request, we use a scheduling tool to run these batches. For monthly running batches since I know when they run, I have scheduled snapshot report for the respective dates. But the batch that run on request have no fixed schedule so my question to the guru's would be : Is there a way I can invoke or kick off a particular SSRS snapshot Report as soon as the batch completes running. For example if a on-request batch program finishes running today at 6PM , I would like to create a snapshot report as soon as the batch finishes running. Is this achievable ?!

  2. As I mentioned above most of the reports are snapshot reports and client wants Report history of 10yrs ( I know it sounds crazy but that is the reality). We have about 170 reports on the whole which run monthly/daily/yearly. Is there a best practice known in maintaining all the reports and where to store them?

  We are using MS SQL Server Reporting Services 2014.

  Please let me know if anyone has done or have suggestions on this. I thank you in advance for any response/help for my situation.

  Thanks !