Main Page

   
Sams Teach Yourself Crystal Reports® 9 in 24 Hours
By Joe Estes, Neil FitzGerald, Kathryn Hunt, Steve Lucas, Ryan Marples
 
Publisher : Sams Publishing
Date Published : September 03, 2002
ISBN : 0-67-232090-8
Pages : 528


Sams Teach Yourself Crystal Reports X in 24 Hours will guide the Crystal Reports users through conceptual topics, such as understanding data sources, to creating simple reports using the provided report wizards to custom reporting creation, modification and design techniques. This book will cover the latest version of Crystal Reports. The newest release includes unprecedented technological advances and user interface design improvements - making for the most significant release enhancement to date.

Developed by Crystal Decisions, Crystal Reports can access data from the most widely used databases and can integrate data from multiple databases within one report. Crystal Reports has been endorsed as the standard program for reporting with over 250 third party vendors. These vendors include Microsoft, SAP, PeopleSoft, Baan, IBM's Lotus, and many others.

   
•  Table of Contents
•  Index
Sams Teach Yourself Crystal Reports® 9 in 24 Hours
By Joe Estes, Neil FitzGerald, Kathryn Hunt, Steve Lucas, Ryan Marples
 
Publisher : Sams Publishing
Date Published : September 03, 2002
ISBN : 0-67-232090-8
Pages : 528
Copyright
    Foreword
      Information Drives the Internet
   
    About the Lead Author
      About the Contributing Authors
      About the Technical Editor
   
    Acknowledgments
    We Want to Hear from You!
    Introduction
      What's in This Book?
      Equipment Used for This Book
   
    Part I.  Introduction to Crystal Reports 9.0
      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
      Summary
      Workshop
   
      Hour 2.  Getting Started with Crystal Reports 9
      Preparing for the Installation
      Installation and Configuration of Crystal Reports
      Introduction to the Crystal Reports Designer
      Summary
      Workshop
   
      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
      Summary
      Workshop
   
      Hour 4.  Using the Default Report Wizards
      Understanding the Crystal Reports Gallery
      Using the Standard Report Creation Wizard
      Working with the Report Design Explorers
      Summary
      Workshop
   
   
    Part II.  Fundamentals of the Crystal Reports Design Environment
      Hour 5.  Creating and Designing Basic Reports
      Planning a Report
      Creating a Report Storyboard
      Designing a Crystal Report
      Creating a Report
      Summary
      Workshop
   
      Hour 6.  Selecting and Grouping Data
      Understanding Field Objects
      Working with Groups
      Understanding Drill-down Reports
      Summary
      Q&A
      Workshop
   
      Hour 7.  Filtering, Sorting, and Summarizing Data
      Filtering the Data in Your Report
      Learning to Sort Records
      Creating Effective Summaries
      Summary
      Workshop
   
   
    Part III.  Formatting Reports
      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
      Summary
      Workshop
   
      Hour 9.  Working with Report Sections
      Formatting Report Sections
      Modifying Report Section Properties
      Using Multiple Report Sections
      Summary
      Workshop
   
      Hour 10.  Understanding and Implementing Formulas
      Using the Formula Workshop
      Workshop Formula Editor
      Formula Expert
      Formula Extractor
      Summary
      Q&A
      Workshop
   
      Hour 11.  Visualizing Your Data with Charts and Maps
      Using the Chart Expert
      Using the Map Expert
      Modifying Chart and Map Properties
      Summary
      Q&A
      Workshop
   
      Hour 12.  Implementing Parameters for Dynamic Reporting
      Understanding the Value of Parameters
      Creating and Implementing Parameters Fields
      Using Parameters with Record Selections
      Summary
      Workshop
   
   
    Part IV.  Enhancing Crystal Reports
      Hour 13.  Custom Formatting Techniques
      Making Presentation-Quality Reports
      Common Formatting Features
      Conditional Formatting—Using Data to Drive the Look of a Report
      Summary
      Workshop
   
      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
      Summary
      Workshop
   
      Hour 15.  Using Record Selections and Alerts for Interactive Reporting
      Creating Advanced Record Selection Formulas
      Adding Alerting to Your Reports
      Summary
      Workshop
   
      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
      Summary
      Q&A
      Workshop
   
      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
      Summary
      Workshop
   
      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
      Summary
      Workshop
   
      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
      Summary
      Workshop
   
   
    Part V.  Advanced Report Design Concepts
      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
      Summary
      Q&A
      Workshop
   
      Hour 21.  Additional Data Sources for Crystal Reports
      COM-based Data Sources
      Java-based Data Sources
      XML as a Data Source
      Solution Kits
      Summary
      Workshop
   
      Hour 22.  Optimizing SQL Queries in Crystal Reports
      Review of SQL Commands
      An Introduction to the SQL Language
      Summary
      Workshop
   
   
    Part VI.  Sharing and Distributing Crystal Reports
      Hour 23.  Distributing Crystal Reports
      Reviewing Report Distribution Options
      Summary
      Q&A
      Workshop
   
      Hour 24.  Crystal Reports in Applications—a Developer's Perspective
      Overview of Developer Tools
      Desktop Applications
      Creating Simple Web Applications
      Building Advanced Web Applications
      Summary
      Workshop
   
   
    Part VII.  Supplemental Crystal Reports Technologies
      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
   
   
    Index