Reporting

Suppressing values to minimize the number of tables in a Crystal Report

Posted on 02. Feb, 2009
Categories: Reporting

0

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.

Continue Reading

One Report, Multiple Report Output Options in Crystal Reports

Posted on 02. Feb, 2009
Categories: Reporting

0

This tip shows you how to create one Crystal Report with multiple display options.

Continue Reading

Crystal Reporting: A Case Study

Posted on 29. Oct, 2008
Categories: Reporting

0

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.

Continue Reading

Creating Commands in Crystal Reports via Microsoft Excel

Posted on 19. Jan, 2008
Categories: Reporting

0

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.