A simple rule of reporting is that adding tables and views increases the amount of time for the report to run. Many first-time report writers believe that you have to add multiple instances of a table in order to derive different totals, such as month-to-date, year-to-date, etc.

You don’t.

Check out the PDF below to see an example of how to maximize the performance of a report with a single instance of a transactional table.