Crystal Report Tutorial

Crystal Reports Tutorial Topics Covered

 

The most comprehensive Crystal Reports tutorial available.

---

The Crystal Reports Environment
1. Starting Crystal Reports
2. The Menu Bar
3. Using Toolbars
4. The Design View

Creating Data Connections
1. Creating a New Blank Report
2. The Database Expert
3. Access/Excel (DAO)
4. ACT!
5. ADO.NET (XML)
6. Btrieve
7. COM Connectivity
8. Database Files
9. Exchange Message Tracking Logs
10. Field Definitions Only
11. File System Data
12. JDBC (JNDI)
13. Legacy Exchange
14. Mailbox Admin
15. Microsoft CRM
16. MS IIS/Proxy Log Files
17. NT Archived Event Log
18. NT Current Event Log
19. ODBC (RDO)
20. OLAP
21. OLE DB (ADO)
22. Outlook
23. Public Folder ACL
24. Public Folder Admin
25. Public Folder Replica
26. Salesforce.com
27. Universes
28. Web/IIS Log Files
29. xBase
30. XML and Web Services
31. Repository
32. Making Additional Data Connections and Selecting Tables
33. Making a “Favorite” Connection

Creating Basic Reports
1. Adding Data Fields to a Report
2. Browsing Field Data
3. Selecting, Moving, and Resizing Fields
4. Using the “Size” and “Align” Commands
5. Creating Text Objects
6. Saving a Report
7. Previewing a Report
8. Refreshing the Report Data

Linking Tables in a Report
1. Basic Table Structures and Terms
2. Linking Multiple Tables
3. Table Joins
4. Enforcing Table Joins and Changing Link Types

Basic Formatting Techniques
1. Formatting Report Objects
2. The Format Editor
3. Drawing Lines
4. Drawing Boxes
5. Format Painter
6. Formatting Part of a Text Object
7. The Template Expert
8. Inserting Pictures

Record Selection
1. The Select Expert
2. Setting Multiple Filters
3. Editing the Selection Formula

Sorting and Grouping Records
1. The Record Sort Expert
2. The Group Expert
3. Managing Groups
4. Summarizing Groups
5. Hierarchical Groupings
6. The Group Sort Expert

Printing Reports
1. Inserting Special Fields
2. Page Setup
3. Print Setup
4. Printing Reports

 

Using Formulas
1. Crystal Reports Formula Syntax
2. The Formula Workshop- Formula Editor Window
3. Creating Formula Fields
4. Crystal Syntax
5. Basic Syntax
6. Finding Function and Operator Assistance

Advanced Formatting
1. The Highlighting Expert
2. The Section Expert
3. Conditionally Formatting a Section
4. Conditionally Formatting a Field
5. Manipulating Multiple Sections

Summary Reports
1. Summarizing Report Data
2. Using the DrillDownGroupLevel Feature

Charting
1. The Chart Expert
2. Editing Charts
3. Setting General Chart Options
4. Changing Chart Titles
5. Formatting Selected Chart Items
6. Formatting a Data Series
7. Formatting Chart Gridlines
8. Formatting a Chart Grid
9. Setting Chart Axes Options
10 . Adding Chart Trendlines
11 . Modifying a 3D Chart View
12. Using Chart Templates
13. Auto-Arranging Charts

Advanced Reporting Tools
1. Using Running Totals
2. Creating Parameter Fields
3. Parameterized Record Selection
4. Entering Parameter Values
5. Creating Subreports
6. Report Alerts
7. Report Alert Functions

Advanced Formula Creation
1. Evaluation Time Functions
2. Declaring Variables
3. Using and Displaying Variables
4. Using Array Values
5. Using “If… Then… Else…” Statements
6. Using the “Select/Case” Statement
7. Using “For” Loops
8. Using “Do… While” Loops
9. The IIF Function

Advanced Reporting
1. Creating a Report Template
2. Exporting Report Results
3. Exporting as HTML
4. Setting Default Options
5. Setting Report Options

Using Report Wizards
1. Using the Report Wizards
2. Report Wizard Types
3. Creating a Cross-Tab Report

Advanced Database Concepts
1. Viewing the SQL Code
2. Using Table Aliases
3. Verifying the Database
4. Setting the Datasource Location
5. Mapping Fields