Marlon:

Using one View to extract data for another View to read can be automated but maybe you just need to cleanup your data or how you are accessing it to speed up the process.

Which module are you using for this report? Version?
How far back does the history go?
How many records per year?