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.
This tip shows you how to create one Crystal Report with multiple display options.
Many times, transactional tables in databases are big. I mean, huge. I have seen tables with 35,000,000 records. Imagine writing a report with four or more tables and the data resides in monstrous tables. In this tip, I show how you can cheat. There’s no other word for it.