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.
| ||||||||||||
Book Description
Frequently Bought Together
Editorial Reviews
From the Back Cover
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 Professionals
- Install 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
About the Author
Annette Harper, OCP, ACE, MCNE (Canal Winchester, OH) has worked with Crystal Reports with various enterprise databases for many years.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
13 of 13 people found the following review helpful:
5.0 out of 5 stars
Connecting Crystal 9 to the Oracle DBMS,
By
This review is from: Crystal Reports 9 on Oracle (Paperback)
This book contains everything that I needed to extend my existing Crystal Reports 9 development knowledge into the Oracle DBMS realm. As an experienced CR developer, but one without any previous experience with Oracle as the back-end, this reference provided the necessary overview of the Oracle system along with sufficient supporting detail - to allow me to quickly acquire the skills to competently utilize the Oracle system in general, and some of its more advanced features on particular: Stored Procedures as datasources, REF Cursors, the MINUS Set Operation, Materialized Views ...Having performed several searches of the Crystal Decisions knowledge base for detailed guidance in using Oracle Stored Procedures (and Packages) as a datasource and coming up short of the desired comfort level - in terms of the breadth and depth of coverage, this reference proved invaluable in my last CR consulting engagement. As an added bonus, Annette Harper responded personally to my email requests for clarification in areas that a more sober reading (one performed outside the deadline pressures of an existing consulting engagement) would have allowed. In short, and speaking from the perspective of an experienced CR developer with decent DBMS skills in general, this book made it possible to comfortably and competently transition to using Oracle as the back-end data store.
5 of 5 people found the following review helpful:
5.0 out of 5 stars
Crystal Reports 9 on Oracle,
By A Customer
This review is from: Crystal Reports 9 on Oracle (Paperback)
Crystal Reports 9 on Oracle is an excellent book written by Annette Harper. Every report writer will benefit from the in depth coverage of how to write effective reports by best utilize Oracle 9i database features from new Oracle 9i analytical SQL functions, PL/SQL, materialized views, external tables, flashback queries, etc. to Oracle optimization techniques. The book's expert insight into Crystal Reports 9 optimization tips, Data Dictionary report and Crystal Reports 9 repository will empower Crystal Reports writer to fully utilize Crystal Reports 9 and create faster, better reports.
4 of 4 people found the following review helpful:
5.0 out of 5 stars
One of its kind.,
By Murali (Burbank, ca United States) - See all my reviews
This review is from: Crystal Reports 9 on Oracle (Paperback)
This book by Annette Harper is one of its kind in the market.It explains the various ODBC drivers by a comparitive study which gives us a very good idea as to which driver we should use.The book is very helpful for people who are writing Crystal Reports against Oracle Database.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
This chapter covers the installation and configuration of the components required to use Crystal Reports with Oracle. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
reporting aggregate functions, child cursor, cpu costing, interval datatypes, inline view, generic connectivity, deleted field, data dictionary views, named notation, net service name, soft parses, full table scan, dynamic performance views, definer rights, invoker rights, predicate information, selection formula, optimizer hints, percentile functions, date literals, modifier name, repository tables, optimizer mode, optimal execution plan, query rewrite Key Phrases - Capitalized Phrases (CAPs): (learn more)
Crystal Reports, Database Expert, Executions Loads, Function Formula, Statistics Hash Value, Wire Protocol, Session Stats, Crystal Decisions, Program Machine, Select Expert, Use Indexes, Cost Rows Optimizer, Print State, Back Next, Expression Editor, Perform Query Asynchronously, Test Connect, Crystal Oracle, Formatting Formulas, Formula Fields, Index Legend, Native Dynamic, Oracle Flashback, Program Files, Save To File New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
This chapter covers the installation and configuration of the components required to use Crystal Reports with Oracle. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
reporting aggregate functions, child cursor, cpu costing, interval datatypes, inline view, generic connectivity, deleted field, data dictionary views, named notation, net service name, soft parses, full table scan, dynamic performance views, definer rights, invoker rights, predicate information, selection formula, optimizer hints, percentile functions, date literals, modifier name, repository tables, optimizer mode, optimal execution plan, query rewrite Key Phrases - Capitalized Phrases (CAPs): (learn more)
Crystal Reports, Database Expert, Executions Loads, Function Formula, Statistics Hash Value, Wire Protocol, Session Stats, Crystal Decisions, Program Machine, Select Expert, Use Indexes, Cost Rows Optimizer, Print State, Back Next, Expression Editor, Perform Query Asynchronously, Test Connect, Crystal Oracle, Formatting Formulas, Formula Fields, Index Legend, Native Dynamic, Oracle Flashback, Program Files, Save To File New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Books on Related Topics
(learn more)
|
What Other Items Do Customers Buy After Viewing This Item?
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
