Table of content

•	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