For our purpose, we need to be able to run a report for given point in time and provide a constant value without having to keep a copy some where.
For example, for monthend close, we should be able to run the monthend close report at any given time without persisting the data and have the same result. Let's say that we close the book on 29 of each month at 8:00 am. Therefore, anyone can run a report for 29/2/2015 and have the same result.
Have anyone encounter this problem and how do they resolve it ?