Crystal reports 9 on Oracle

Explore connectivity options, then delve into optimization methods that can be implemented in the Crystal environment, including the use of SQL Expressions and SQL Commands. Coverage includes an execution plan, optimization of indexes, and reduction of parsing, and Oracle-specific features such as external tables, Heterogeneous Connectivity, and Oracle Flashback. Common difficulties when using Oracle are described, and solutions provided.

Contents

• Connectivity, Authentication, and Privileges
• Oracle Structures
• Oracle SQL
• Oracle Advanced SELECT Options
• PL/SQL
• Optimizing: The Crystal Reports Side
• Optimizing: The Oracle Side
• Optimizing: Reducing Parses
• Other Tips
• Data Dictionary Report
• The Crystal Repository
• Appendix A: Common Issues
• Appendix B: Functions
• Index