List of Figures

Introduction

Figure I-1: Crystal Reports' report templates

Figure I-2: Crystal Reports' exporting functionality

Figure I-3: Crystal Reports' Report Wizards

Figure I-4: Crystal Reports' Formula Workshop

Figure I-5: Charting capabilities in Crystal Reports

Chapter 1: The World of Crystal Reports

Figure 1-1: A model of a database management system (DBMS)

Figure 1-2: A database record

Figure 1-3: Examples of fields within a table

Figure 1-4: How Crystal Reports works with a database

Figure 1-5: The Report Processing Model

Figure 1-6: A geographic sales report

Figure 1-7: A world sales report

Figure 1-8: A product catalog report

Chapter 2: The Crystal Reports Environment

Figure 2-1: The Crystal Reports Welcome dialog box

Figure 2-2: The Database Expert dialog box

Figure 2-3: Data connection options of the Database Expert

Figure 2-4: Selecting the sample database with the Database Expert

Figure 2-5: The Report Design area

Figure 2-6: The Crystal Reports menu bar

Figure 2-7: The Standard toolbar

Figure 2-8: The Formatting toolbar

Figure 2-9: The Insert Tools toolbar

Figure 2-10: The Expert Tools toolbar

Chapter 3: Designing Your First Report

Figure 3-1: Viewing the data structures of your database

Figure 3-2: The Tables node displays all tables within a database.

Figure 3-3: The Field Explorer pane is on the left side of the Report Design area.

Figure 3-4: Adding database fields from the Field Explorer pane

Figure 3-5: Adding a database field to a report

Figure 3-6: A vertical guideline

Figure 3-7: A report viewed from the Preview tab

Figure 3-8: The Section Expert dialog

Figure 3-9: Adding multiple sections to your report

Figure 3-10: Additional Details sections (added using the Section Expert)

Figure 3-11: Adding multiple sections to your report

Figure 3-12: Dragging a section's border to create white space

Figure 3-13: Accessing a section's options menu

Figure 3-14: Using horizontal guidelines to add white space

Chapter 4: Writing Reports with the Report Wizards

Figure 4-1: The Crystal Reports Gallery

Figure 4-2: The Standard Report Creation Wizard dialog

Figure 4-3: The Data screen (of the Standard Wizard)

Figure 4-4: The Fields screen (of the Standard Wizard)

Figure 4-5: Browsing database field data

Figure 4-6: Crystal Reports' Finding Fields functionality

Figure 4-7: Changing the display order of database fields

Figure 4-8: The Grouping screen (of the Standard Wizard)

Figure 4-9: The Summaries screen (of the Standard Wizard)

Figure 4-10: The Record Selection screen (of the Standard Wizard)

Figure 4-11: The Template screen (of the Standard Wizard)

Figure 4-12: Using the Wave template

Chapter 5: Report Formatting

Figure 5-1: The Print Setup dialog box

Figure 5-2: Adding a text object to your report

Figure 5-3: The Font Color options menu

Figure 5-4: Changing font size with the Standard toolbar

Figure 5-5: The resizing squares of a report object

Figure 5-6: Resizing a report object

Figure 5-7: The Format Editor

Figure 5-8: The Common tab of the Format Editor

Figure 5-9: Using the Can Grow option to resize objects

Figure 5-10: The Date and Time tab within the Custom Style dialog box

Figure 5-11: Formatting date information with the Format Editor

Figure 5-12: The Field Explorer

Part I Exercises

Figure P1-1: The Label screen of the Mailing Labels Report Ceation Wizard

Figure P1-2: Moving all report objects at once

Figure P1-3: Filling in a box using the Format Editor

Figure P1-4: A mailing label report

Figure P1-5: Adding a graphic to a report

Figure P1-6: Adding a first name greeting to your report

Figure P1-7: Defining each record to display as a separate page with the Section Expert

Figure P1-8: A form letter report

Chapter 6: Linking Tables

Figure 6-1: The ERD for the xtreme.mdb database

Figure 6-2: The Database Expert with the Data and Links tabs available

Figure 6-3: Clearing all links within the Database Expert

Figure 6-4: Deleting a single link within the Database Expert

Figure 6-5: Adding links in the Database Expert

Figure 6-6: The Link Options dialog box

Figure 6-7: Adding tables within the Database Expert

Figure 6-8: Deleting report tables within the Database Expert

Chapter 7: Filtering Records

Figure 7-1: An unfiltered report

Figure 7-2: The Choose Field dialog box

Figure 7-3: The Select Expert

Figure 7-4: The Comparision Operator list

Figure 7-5: The Comparison Value field

Figure 7-6: A report with a single filter

Figure 7-7: Creating a compound-record selection statement in the Select Expert

Figure 7-8: Your report with a compound-record selection statement

Figure 7-9: Creating filters using the wildcard character

Chapter 8: Sorting and Grouping Within Your Reports

Figure 8-1: A report with no sorting order

Figure 8-2: Unsorted data within the Product Inventory Report

Figure 8-3: The Record Sort Order dialog box

Figure 8-4: Sorting your report by the Product Type Name field

Figure 8-5: A report with single sorting functionality

Figure 8-6: Defining multiple sorting with the Record Sort Expert

Figure 8-7: A report with multiple sorting functionality

Figure 8-8: Changing the sorting order with the Record Sort Order dialog box

Figure 8-9: Removing sorting fields with the Record Sort Expert

Figure 8-10: The Group Expert

Figure 8-11: Creating a single group

Figure 8-12: The Group Header and Group Footer sections

Figure 8-13: The Change Group Options dialog box

Figure 8-14: The Group Tree

Figure 8-15: Adding multiple groups to your report

Figure 8-16: A report with multiple groups

Chapter 9: Adding Summaries to Your Reports

Figure 9-1: The Insert Summary dialog box

Figure 9-2: Adding subtotals to your reports

Figure 9-3: Adding a grand total

Figure 9-4: The Create Running Total Field dialog box

Figure 9-5: Defining a running total

Figure 9-6: A report with a running total

Figure 9-7: Creating a summary report within Crystal Reports

Figure 9-8: The drill-down functionality

Figure 9-9: Modifying the Report Options dialog box for the drill-down functionality

Figure 9-10: Drill-down functionality with the headers information displayed

Part II Exercise

Figure P2-1: Defining a cross-tab report

Figure P2-2: Defining a filter for the Product Type Name field

Figure P2-3: Defining a filter for the Product Class field

Figure P2-4: The start of a cross-tab inventory report

Figure P2-5: Formatting the cross-tab report

Figure P2-6: Defining a color for a report object

Figure P2-7: The Highlighting Expert

Figure P2-8: Defining the Highlighting Expert

Figure P2-9: The finished Inventory Cross-Tab report

Chapter 10: Understanding Formulas

Figure 10-1: The Formula Workshop

Figure 10-2: Creating a new formula from the Formula Workshop

Figure 10-3: Naming a formula field

Figure 10-4: The Formula Editor

Figure 10-5: Creating a string formula

Figure 10-6: Grouping a report by a formula field

Figure 10-7: Expanding the Functions window

Figure 10-8: Adding a conditional formula to your report

Figure 10-9: A formula syntax error

Figure 10-10: Adding the ToText function to a formula

Figure 10-11: The results of your new Quarter formula

Chapter 11: Dynamic Reporting with Report Parameters

Figure 11-1: The Create Parameter Field dialog box

Figure 11-2: Creating a parameter field

Figure 11-3: The Enter Parameter Values dialog box

Figure 11-4: A parameter field within your report

Figure 11-5: Defining a date parameter field

Figure 11-6: The date parameter field will not filter records until it is part of a selection formula.

Figure 11-7: Defining a parameter value within a selection statement

Figure 11-8: No records found for your parameter

Figure 11-9: Record selection using a parameter field

Figure 11-10: The Edit Parameter Field dialog box

Figure 11-11: The results of editing a parameter field

Figure 11-12: Changing a date parameter to allow for date ranges

Figure 11-13: Entering date range values

Figure 11-14: A report with a date range parameter

Chapter 12: Visualizations with Charts and Maps

Figure 12-1: The Chart Expert

Figure 12-2: Dynamically selecting a date range for your report records

Figure 12-3: The start of Customer Sales by Region report

Figure 12-4: Selecting the side by side bar chart with 3D visual effect

Figure 12-5: The Data tab

Figure 12-6: Modifying your chart within the Chart Expert Text tab

Figure 12-7: The Font dialog box

Figure 12-8: A report that utilizes a chart

Figure 12-9: The drill-down tab of a chart

Figure 12-10: The Map Expert

Figure 12-11: The Map Expert Type tab

Figure 12-12: A report that utilizes a map

Figure 12-13: The drill-down tab of a map

Chapter 13: Creating Subreports

Figure 13-1: Graphical representation of a report that uses a subreport

Figure 13-2: The Insert Subreport dialog box

Figure 13-3: Modifying the Customer Sales by Region report

Figure 13-4: Creating a new report as your subreport

Figure 13-5: The TopFiveProducts.rpt as a subreport of the CustSalesRegion.rpt

Figure 13-6: A primary report using an unlinked subreport

Figure 13-7: Creating a linked subreport

Figure 13-8: Linking a subreport to a primary report

Figure 13-9: Adding a linked on-demand subreport

Figure 13-10: The primary report with a link to the on-demand subreport

Figure 13-11: The on-demand subreport

Chapter 14: Distributing Reports

Figure 14-1: The Export dialog box

Figure 14-2: The Excel Format Options dialog box

Figure 14-3: The Exporting Records dialog box

Figure 14-4: The Customer Sales by Region report, exported into an Excel spreadsheet

Figure 14-5: The exported file containing all report charts

Figure 14-6: A report definition file

Figure 14-7: The Crystal Reports Distributor from ChristianSteven Software, Ltd.

Chapter 15: Exploring Crystal Reports' SQL Commands

Figure 15-1: The Add Command node

Figure 15-2: The Add Command To Report dialog box

Figure 15-3: Creating a SELECT statement

Figure 15-4: The SQL command in the Selected Tables list box

Figure 15-5: The SQL query you created returns all fields in the Product table (as shown in the Field Explorer).

Figure 15-6: Renaming a SQL command

Figure 15-7: Adding a WHERE clause to your SELECT statement

Figure 15-8: Adding an ORDER BY clause to your SELECT statement

Figure 15-9: Joining multiple tables within your SQL command

Part III Exercise

Figure P3-1: Defining groups within your Balance Sheet report

Figure P3-2: Creating a Balance Sheet report with the Standard Report Creation Wizard

Figure P3-3: Defining a report parameter

Figure P3-4: Entering a report date range for your report

Figure P3-5: Formatting the Balance Sheet report

Figure P3-6: Adding formulated totals to the Balance Sheet report

Figure P3-7: The final version of the Consolidated Balance Sheet report

Appendix A: The Xtreme.mdb ER Model

Figure A-1: The Xtreme.mdb database entity-relationship model

Appendix C: Crystal Report Functions

Figure C-1: The structure of a function

Appendix E: Accounting Reference

Figure E-1: The accounting equation

Figure E-2: T Accounts