Table of content
- Table of Contents
- Table of Contents
- Back Cover
- Mastering Crystal Reports 9
- Introduction
- The Evolution of Crystal Reports
- Whats New in Crystal Reports 9?
- Downloading Materials
- How to Contact the Authors
- Part 1: Report Writing Fundamentals
- Chapter 1: Building Your First Report
- Setting Up the Right Report
- Choosing a Data Source
- Adding Fields
- Grouping and Sorting Information
- Summarizing Data
- The Report Design Area
- Putting On the Finishing Touches
- The Business Questions Answered
- Summary
- Chapter 2: Modifying a Report
- Locating and Using an Existing Report
- Working with Database Fields
- Managing Groups
- Sorting Data
- Basic Summarization Techniques
- Getting Help
- Summary
- Chapter 3: Formatting Fields and Objects
- Report Summary Information
- Formatting Report Objects
- Creating Hyperlinks
- Working with OLE
- Summary
- Part 2: Putting Report Elements to Work
- Chapter 4: Adding Business Logic with the Formula Workshop
- Setting the Foundation
- Using Formulas in Crystal Reports
- The Formula Workshop
- Coding Formulas
- Coding and Using Functions
- Crystal Built-in Constants
- SQL Expression Fields
- Troubleshooting Formulas
- Summary
- Chapter 5: Working with the Crystal Repository
- Using the Crystal Repository
- The Structure of the Repository
- Summary
- Chapter 6: Summarizing Information
- Grouping Data
- Creating and Using Subreports
- Summary
- Chapter 7: Selectively Refining a Report Using Data Values
- Selection Formulas
- Filtering Data Using Parameters
- Suppressing Data
- Bringing the Message to Life
- Summary
- Chapter 8: Customizing Sections
- Section Areas
- Hiding Sections
- The Section Expert
- Controlling Spacing in a Section
- Summary
- Part 3: Advanced Reporting
- Chapter 9: Working with Multiple Tables
- Essential Database Concepts
- Crystal Database Interactions
- Beyond a Single Table
- Table Relationships
- Types of Joins
- Beyond Two Tables
- Summary
- Chapter 10: Data Sources and the Database Expert
- Crystal Connectivity
- ODBC Data Sources
- OLE DB Data Sources
- Native Connections
- Crystal Queries