We run a job tracking service as part of the company software. Reports are generated by SQL Server (Standard) Reporting Services usually daily but often as and when needed before meetings etc.
As the jobs progress their status changes and the details of the reports change. Due to the legacy of the front end application and the database we do not store as many milestones as needed for managers to look back at historical reports.
Managers quite often ask “Can we see where XYZ was last week?” or things like “Let’s have a look how Project1 was performing last June?” but running the reports on the Project1 database backup all show 100% complete as it is now finished.
What is the best way to enable historical reporting at a daily level with SQL Server Standard?
Ideally we’d like to keep 3 months of 5 different reports stored daily if possible?