Here is the problem, I have some reports that get store in the history of SSRS every day that works fine, now let's say that my backend system is down during the time the history schedule runs then my report is not generated and don't store in History becuase
the data sources throw an error becuase they could not connect to my backend, that's ok too. Now by backend connections is restore and online there is any way that I can run my report and do a manual snapshot, then change the time and place
the report snaphot at the right time in the history tables.
for example: my backend is in a remote location and some times the connection is lost even for a couple of dates, can I refill the SSRS when the backend is online? I mean run the report with right parameters so I get as it suppose to be 1 or 2 dates
ago and then do the manual snapshot then move the report to the right place in History?
I have been thinking in a couple of options
1.- A store procedure that I can pass the report name and the datetime when I run the report and the datetime when I want the report to be place in history, then the store procesure will move my latest report to the right place in History, it that posible?
could you please tell me or pointme in the right direction?
2.- same as before but using the WebServices and a .Net Application.
I don't know if just changing the
View Complete Post