Home > Store

Sams Teach Yourself Crystal Reports 9 in 24 Hours

Register your product to gain access to bonus material or receive a coupon.

Sams Teach Yourself Crystal Reports 9 in 24 Hours


  • Sorry, this book is no longer in print.
Not for Sale


  • Copyright 2003
  • Dimensions: 7-3/8" x 9-1/8"
  • Pages: 528
  • Edition: 1st
  • Book
  • ISBN-10: 0-672-32090-8
  • ISBN-13: 978-0-672-32090-3

Sams Teach Yourself Crystal Reports 9 in 24 Hours guides the reader through understanding data sources, to creating simple reports using the provided report wizards to custom reporting creation, modification and design techniques. Crystal Reports 9 includes unprecedented technological advances and user interface design improvements. Crystal Reports can access data from the most widely used databases and can integrate data from multiple databases within one report.



The examples developed in the book - 956 kb -- code.zip

Sample Content

Online Sample Chapters

Accessing Your Data

Accessing Your Data in Crystal Reports 9

Getting Started with Crystal Reports 9

The Value of Crystal Reports 9

Using the Default Report Wizards in Crystal Reports 9

Table of Contents

(NOTE: Each chapter concludes with a Summary and Workshop.)



Hour 1. The Value of Crystal Reports 9.

Transforming Data into Information with Crystal Reports. Key Benefits of Crystal Reports. Crystal Reports as a Content Creation Application. New Features in Crystal Reports 9.

Hour 2. Getting Started with Crystal Reports 9.

Preparing for the Installation. Installation and Configuration of Crystal Reports. Introduction to the Crystal Reports Designer.

Hour 3. Accessing Your Data.

Understanding the Different Types of Data Sources. Introduction to the Data Explorer. Adding Database Objects to Your Report. Joining Database Objects Together. Using the Database Expert.

Hour 4. Using the Default Report Wizards.

Understanding the Crystal Reports Gallery. Using the Standard Report Creation Wizard. Working with the Report Design Explorers.


Hour 5. Creating and Designing Basic Reports.

Planning a Report. Creating a Report Storyboard. Designing a Crystal Report. Creating a Report.

Hour 6. Selecting and Grouping Data.

Understanding Field Objects. Working with Groups. Understanding Drill-down Reports.

Hour 7. Filtering, Sorting, and Summarizing Data.

Filtering the Data in Your Report. Learning to Sort Records. Creating Effective Summaries..


Hour 8. Fundamentals of Report Formatting.

Positioning and Sizing Report Objects. Modifying Object Properties for Formatting Purposes. Combining and Layering Report Objects. Configuring Report Page and Margin Properties.

Hour 9. Working with Report Sections.

Formatting Report Sections. Modifying Report Section Properties. Using Multiple Report Sections.

Hour 10. Understanding and Implementing Formulas.

Using the Formula Workshop. Workshop Formula Editor. Formula Expert. Formula Extractor.

Hour 11. Visualizing Your Data with Charts and Maps.

Using the Chart Expert. Using the Map Expert. Modifying Chart and Map Properties.

Hour 12. Implementing Parameters for Dynamic Reporting.

Understanding the Value of Parameters. Creating and Implementing Parameters Fields. Using Parameters with Record Selections.


Hour 13. Custom Formatting Techniques.

Making Presentation-Quality Reports. Common Formatting Features. Conditional Formatting—Using Data to Drive the Look of a Report

Hour 14. Using Cross-Tabs for Summarized Reporting.

What Is a Cross-Tab? Benefits of Using Cross-Tabs. Using the Cross-Tab Wizard. Using Top N with Cross-Tabs Reports. Using Advanced Cross-Tab Features.

Hour 15. Using Record Selections and Alerts for Interactive Reporting.

Creating Advanced Record Selection Formulas. Adding Alerting to Your Reports.

Hour 16. Using Subreports.

Understanding Subreports. Understanding Linked Versus Unlinked Subreports. Considering Subreport Execution Time and Performance. Using Variables to Pass Data Between Reports. Emulating Nested Subreports.

Hour 17. Using Formulas and Custom Functions to Implement Complex Business Logic.

Becoming More Productive with Formulas. Choosing a Formula Language: Crystal Versus Basic Syntax. Brackets Have Meaning. Characters Also Have Meaning! New in Crystal Reports Version 9.

Hour 18. Working with the Report Component Repository.

Sharing Report Design Components. Understanding the Repository. Sharing of Report Objects. Understanding the Repository Explorer. Understanding How the Repository Works. Adding Objects to the Repository. Editing Repository Objects. Understanding Deletions in the Repository. Sharing Report Objects with Others.

Hour 19. Designing Effective Report Templates.

Reuse in Reporting. Understanding Report Templates. Using Existing Crystal Reports as Templates. Creating Useful Report Templates. Using Template Field Objects. Using Report Templates to Reduce Report Creation Effort.


Hour 20. Multidimensional Reporting Against OLAP Data.

Introduction to OLAP Concepts and OLAP Reporting. New OLAP Features in Crystal Reports 9. OLAP Report Creation Wizard and OLAP Expert. Advanced OLAP Reporting. Introduction to Crystal Analysis.

Hour 21. Additional Data Sources for Crystal Reports.

COM-based Data Sources. Java-based Data Sources. XML as a Data Source. Solution Kits.

Hour 22. Optimizing SQL Queries in Crystal Reports.

Review of SQL Commands. An Introduction to the SQL Language.


Hour 23. Distributing Crystal Reports.

Reviewing Report Distribution Options.

Hour 24. Crystal Reports in Applications—a Developer's Perspective.

Overview of Developer Tools. Desktop Applications. Creating Simple Web Applications. Building Advanced Web Applications.


Appendix A. Crystal Reports for Visual Studio .NET.

Who Should Read This Appendix? Overview of Microsoft .NET and Crystal Reports for Visual Studio .NET. Crystal Reports for Visual Studio .NET Feature Set. Feature Set Comparison—Crystal Reports for Visual Studio .NET and Crystal Reports 9. Creating Reports in Visual Studio .NET. Additional Resources on Crystal Reports for Visual Studio for .NET.

Appendix B. Common Crystal Reports FAQs and Tips.

Report Design FAQs and Resources. Common Report Distribution Questions. Resources for Additional Support.



Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership