Because Crystal Reports works with a large number of databases, you encounter some good, and some bad database designs. Let’s share our mistakes so we don’t keep repeating them.

• Atomic principle of database design (2004)
• Deleted data disposition (2004)
• Include deleted data (2004)
• Limit changes to database values (2004)
   
• Normalize repeating fields (2004)
• Principles: Atomic (2004)
• Principles: Singularity 2004)
• Repeating fields (2004)
• Rounding (2005)
   
• Singularity principle of database design (2004)
• Time-based data and UTC fields (2004)
• Time formats (2006)
• Update a database with a report (2004)
• Use UTC time fields for your time-based data (2004)

See these database books.