Do you need the reports to be real time, or can there be a delay in the information being shown to the users?

You could look at Snapshots if you have the right edition of SQL which will get around the issue.