Need to capture SQL Connected data at intervals
I have several SQL connected reports that have changing/disappearing data that I need to capture as a rolling snapshot before the data changes and disappears.
For example, I have a report that spits out PO lines that have not been released but once they are released they are no longer SQL accessible and they disappear. I know I could write another report to try to collect this based on some sort of date key but it is just not very reliable.
I want to capture the sum and count of incidents associated related to the buyer name at the end of each week in a new spreadsheet. Then the next week it does the same in a new column. I can then chart trends based on the historical data. Any easy way to do this? I am pretty good in SQL but not so much in VB and I am guessing this is the direction I will need to head. Also not interested in third party software.
Also, this data is on Sharepoint which I am just learning. There may be something with revision history based on last refresh?
|