I am not what is the best way to design this report. I will provide you with my intentions and please provide me with some ideas.
I am building a report in Crystal reports that will need to store data (counts) daily. Example Monday Tuesdsay Wednesday etc.
The counts are being pulled from queries that will capture day within a 24 hr period. I am using Oracle and Aqua Data studio for the database.
Here is the issue. Lets say I run it Monday and the data populates the fields in the report. But when I go on Tuesday to run the report, it will erase the data. How can I make it run queries and not erase the data as the days go by?
I was thinking.. Can I store the daily values in a table and then call them from my report? But then how would I clear the data to reuse the table every week. I am looking to make this easier than what I am currently using in Excel.