Our Contract with You, The Reader -- List of Chapters -- Table of Contents -- Acknowledgements -- About the Authors -- How to Download the Files -- Chapter 1: Introducing Crystal Reports -- Crystal Reports versions -- Installing Crystal Reports -- What's changed in version 9? -- What's missing? -- What's new? -- Upcoming chapters -- Summary -- Chapter 2: Touring Crystal Reports -- Report Experts -- Data page -- Links page -- Fields page -- Grouping page -- Summaries page -- Group Sorting page -- Chart page -- Record Selection page -- Template page -- Blank Reports -- The Crystal Reports desktop -- Menus -- Toolbars -- Status bar -- Design page -- Preview page -- Report Sections -- Section Expert -- Formatting report objects -- Common page -- Border page -- Font page -- Paragraph page -- Hyperlink page -- Resizing and moving objects -- Using the mouse -- Using the keyboard -- The Object Size and Position window -- Guidelines -- Setting options -- Application options -- Report options -- The report-processing model -- Pre-pass 1 -- Pass 1 -- Pre-pass 2 -- Pass 2 -- Pass 3 -- Summary -- Chapter 3: Creating Your First Report -- Designing the report -- Sketching the report -- The report data -- Your first report, step-by-step -- Selecting the data source -- Adding data fields to the report -- Adding a calculated field -- Grouping and group totals -- Formatting the report -- Adding the page header -- Charting made easy -- Summary -- Chapter 4: Accessing Data -- Using the Database Expert -- Creating a new connection -- Selecting database objects -- Linking Tables -- Field definition files -- Creating a field definition file -- Using a field definition file -- Working with Images -- Images in the database -- Adding a watermark -- Limiting records selected -- The Select Expert -- Miscellaneous data functions -- Set Database Location -- LogOn or Off Server.

Show SQL Query -- Perform Grouping on Server -- Report Bursting Indexes -- Summary -- Chapter 5: Intermediate Reporting -- Understanding the Crystal Repository -- Adding objects to the repository -- Using repository objects in a report -- Updating objects in the repository -- Sorting -- Groups -- Drill-down -- Hierarchical groups -- Summaries -- Subtotals and grand totals -- Running totals -- Cross-tabs -- Charts -- Basic charting -- Advanced charting -- Maps -- The Data tab -- The Type tab -- The Text tab -- Summary -- Chapter 6: Advanced Reporting -- Report parameters -- Multiple value parameters -- Default values -- Report alerts -- OLE objects -- Embedded fields -- Hierarchical reports -- Summary -- Chapter 7: Subreports -- Inserting a subreport -- Unlinked subreports -- Linked subreports -- On-demand subreports -- Updating subreports -- Summary -- Chapter 8: Using Formulas -- The Formula Editor -- The General toolbar -- The Workshop toolbar -- The Custom Function toolbar -- The Workshop Tree -- The Editor toolbar -- Understanding formulas -- Comments -- Data Types -- Variables -- Fields -- Operators -- Functions -- Custom Functions -- The Forumla Extractor -- The Formula Expert -- Summary -- Chapter 9: The RDC: Introduction, Printing, and Databases -- Understanding the Report Designer Component -- Getting started with RDC programming -- Registering the runtime component -- Working with collections -- The Application object -- The Report object -- The Database object -- Working with tables -- Passing stored procedure parameters -- The DatabaseTable object -- The ConnectionProperties object -- Getting connection property information -- Working with fields -- Linking tables -- Connecting to data - some examples -- Logging on and off a server database -- Connecting to ADO -- Connecting to XML -- Connecting to file based data.

You connected to your data, now what? -- Summary -- Chapter 10: The RDC: Manipulating Data -- Sorting -- Working with Groups -- Summary Fields -- Running Totals -- SQL Expressions -- Formula Fields -- Parameter Fields -- Report alerts -- Summary -- Chapter 11: The RDC: Formatting the Report -- Working with Areas -- Condition Formulas -- Working with Sections -- The ReportObject object -- TextObject object -- Field elements -- LineObject object -- BoxObject object -- FieldObject object -- Picture fields -- Special variable fields -- Summary fields -- BlobFieldObject object -- Crosstabs -- GraphObject object -- The FieldDefinitions Collection -- MapObject object -- OLEObject -- OLAPGridObject object -- The ObjectSummaryFieldDefinitions collection -- Unbound fields -- Subreports -- Summary -- Chapter 12: Previewing the Report at Runtime -- Registering the control -- Creating a preview form -- Methods of the Viewer Control -- Showing the report -- Retrieving information -- Events -- Report objects events -- Drill events -- Toolbar objects events -- Miscellaneous events -- Summary -- Chapter 13: The Report Designer Control -- Registering the Control -- Creating a design form -- Working with the designer -- Providing Help -- Using the Designer Control -- Summary -- Chapter 14: Exporting Reports -- Programmatic exports -- Exporting to files -- Adobe Acrobat (PDF) -- Microsoft Word -- Microsoft Excel -- Rich Text Format (RTF) -- HTML -- XML -- Comma Separated Values (CSV) -- Tab-Separated Text -- Text -- Report Definition -- Exporting to an application -- Exporting to MAPI -- Exporting to ODBC -- Summary -- Chapter 15: Integrating COM Components -- Formulas revisited -- Events -- Report events -- Section events -- Separate image files -- Report variables -- Summary -- Chapter 16: Web Reporting -- Report design revisited -- Embedded hyperlinks.

Cascading style sheets -- Navigation -- Report Parts -- Working with ASP -- Page rendering objects -- Customizing the Viewer -- The Report Application Server -- Customizing the RAS -- The RAS SDK -- Summary -- Chapter 17: Crystal Reports .NET -- Windows-based applications -- Web-based applications -- The Crystal Reports .NET designer -- Connecting to ADO .NET -- XML web services -- Publishing a web service -- Consuming a web service -- The CrystalDecisions namespaces -- Summary -- Chapter 18: Licensing and Distribution -- Distribution -- RDC distribution -- Web reporting -- .NET distribution -- Licensing -- The License Manager -- Summary -- Chapter 19: Crystal Reports Tools -- Documentation files -- The Crystal Decisions web site -- Hot fixes and service packs -- Utilities -- Support forums -- Summary -- Index.