If reports are designed to show the information for the last week, can subscribed reports automatically update to show the next week each time the report is generated.
So on Monday Feb 1 it will pull all opened cases from Mon Jan 25 to Sun Jan 31. . . . and then on Feb 8, it’ll pull all opened cases from Mon Feb 1 to Sun Feb 7. . . etc. etc.