Reporting
Feb. 02, 2009
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.
+ Read
Feb. 02, 2009
This tip shows you how to create one Crystal Report with multiple display options.
+ Read
Oct. 29, 2008
A client of mine recently had an interesting reporting request: Can you build a report detailing any changes in employee status and the personnel actions (excluding rehires and new hires) associated with them? Read this Crystal case study to see how the order of joins on tables is essential.
+ Read
Jan. 19, 2008
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.







