Marie Annette Harper

Crystal Reports 9 on Oracle

• Broschiertes Buch

Produktbeschreibung

Maximize Crystal Reports in the Oracle Environment Create dynamic, effective reports from Oracle databases using Crystal Reports 9 and the extensive information in this practical resource. Learn to use one of the most powerful data analysis tools to draw information from Oracle databases, query and rank data, consolidate results, and develop integrated, interactive reports. Plus, leverage the power of the Oracle database in your reports. You'll find full details on everything from Oracle SQL and PL/SQL functions, procedures, and expressions to the Oracle data dictionary and the new Crystal object repository. Get the insider advice you need to optimize performance, solve difficult reporting problems, and integrate non-Oracle data. Essential Skills for Database ProfessionalsInstall and configure the components required to use Crystal Reports with Oracle List, summarize, and rank data using Oracle SQL Select options Formulate and maintain a data dictionary report Configure, update, and administer the Crystal object repository Use Oracle Flashback to document past database states Improve efficiency with Oracle optimizers and parse reduction Use PL/SQL stored procedures as data sources in Crystal Reports Optimize report performance using SQL Expressions and SQL Commands

Produktdetails

• Database Professionals
• Verlag: McGraw Hill LLC
• Seitenzahl: 390
• Erscheinungstermin: September 2003
• Englisch
• Abmessung: 232mm x 189mm x 24mm
• Gewicht: 678g
• ISBN-13: 9780072230796
• ISBN-10: 0072230797
• Artikelnr.: 12298582

Autorenporträt

Annette Harper, OCP, ACE, MCNE (Canal Winchester, OH) has worked with Crystal Reports with various enterprise databases for many years.

Inhaltsangabe

1: Connectivity, Authentication, and Privileges
2: Oracle Structures
3: Oracle SQL
4: Oracle Advanced SELECT Options
5: PL/SQL
6: Optimizing: The Crystal Reports Side
7: Optimizing: The Oracle Side
8: Optimizing: Reducing Parses
9: Other Tips
10: Data Dictionary Report
11: The Crystal Repository
Appendix A: Common Issues
Appendix B: Functions