Email Subscription - Any Way to Make a Dynamic Report Static?

I have a report that sends out yesterday's data entry summary to those who need it. However, if they want to look at a report more than 1 day old, when they click the link to view it in QuickBase it dynamically adjusts to the current date and displays yesterday's data, no matter the date of the email. I'm currently filtering records to those which have [Date] = Yesterday. Any help on how to make these emails show historical data/past reports would be appreciated, or if that isn't possible any tips on how to archive those reports as they are created.