Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)

Chapter 1: The World of Crystal Reports

Table 1-1: Data types recognized by Microsoft Access

Chapter 2: The Crystal Reports Environment

Table 2-1: Create New Connection subfolders

Table 2-2: Crystal Reports' menus

Table 2-3: The buttons of the Standard toolbar

Table 2-4: The buttons on the Formatting toolbar

Table 2-5: The buttons of the Insert Tools toolbar

Table 2-6: The buttons of the Expert Tools toolbar

Chapter 3: Designing Your First Report

Table 3-1: Crystal Reports' reporting fields

Table 3-3: Horizontal guidelines options

Chapter 4: Writing Reports with the Report Wizards

Table 4-1: The Crystal Reports Report Wizards

Table 4-2: Report Wizard information (from within the Report Design area)

Chapter 5: Report Formatting

Table 5-1: The Format Editor's Common tab

Table 5-2: Special fields within Crystal Reports

Chapter 6: Linking Tables

Table 6-1: An Employee table (without the relational model)

Table 6-2: An Employee table (within the relational model)

Table 6-3: A Department table (within the relational model)

Table 6-4: The Customer table information (found within a data dictionary)

Table 6-5: The Orders table information (found within a data dictionary)

Table 6-6: The four join types

Table 6-7: The link types within Crystal Reports

Chapter 7: Filtering Records

Table 7-1: The comparison operators of the Select Expert

Chapter 8: Sorting and Grouping Within Your Reports

Table 8-1: The data type order of a database sort

Chapter 9: Adding Summaries to Your Reports

Table 9-1: The different calculations available within Crystal Reports

Table 9-2: How the different Crystal Reports sections calculate running totals

Chapter 10: Understanding Formulas

Table 10-1: The basic arithmetic operators used within report formulas

Table 10-2: Reserved characters of the Crystal and Basic languages

Table 10-3: Syntax differences between Crystal and Basic

Chapter 11: Dynamic Reporting with Report Parameters

Table 11-1: The Create Parameter Field dialog functionality

Chapter 12: Visualizations with Charts and Maps

Table 12-1: The chart types of Crystal Reports

Table 12-2: The map types of Crystal Reports

Chapter 13: Creating Subreports

Table 13-1: The information to define within the Standard Report Creation Wizard

Table 13-2: The information to define within the Standard Report Creation Wizard

Chapter 14: Distributing Reports

Table 14-1: Crystal's exporting destinations

Part III Exercise

Table P3-1: Additional formulas of the Balance Sheet report

Table P3-2: Adding the formulas to your report

Appendix B: The Xtreme.mdb Data Dictionary

Table B-1: Credit data

Table B-2: Customer data

Table B-3: Employee data

Table B-4: Employee address data

Table B-5: Financial data

Table B-6: Order data

Table B-7: Order detail data

Table B-8: Product data

Table B-9: Product type data

Table B-10: Purchase data

Table B-11: Supplier data

Table B-12: Company data

Appendix C: Crystal Report Functions

Table C-1: Reserved characters of the Crystal Reports and Basic languages

Table C-2: Math functions

Table C-3: Summary functions

Table C-4: Financial functions

Table C-5: String functions

Table C-6: Date and time functions

Table C-7: Date range functions

Table C-8: Array functions

Table C-9: Range functions

Table C-10: Type conversion functions

Table C-11: Programming shortcuts

Table C-12: Evaluation time functions

Table C-13: Print state functions

Table C-14: Document property functions

Table C-15: Alert functions

Table C-16: Miscellaneous functions

Table C-17: Conditional formatting functions