Objectives

• Create a presentation quality report
• Select their required records
• Create simple calculated fields
• Create totals and subtotals
• Link tables and create a chart
• Export reports to HTML, Word, & Excel
• Manipulate crystal special fields

Audience

• New users of Crystal Reports 8.5

PreRequisites

• Understanding of Microsoft Office

Topics

1. Introduction
   • Course Objectives
   • Database concepts & field types
   • Crystal Environment
2. Creating Simple Reports
   • Using Crystal wizards
   • Entering, editing and moving text and database fields
   • Layout options
   • Field attributes
   • Editing in preview mode
   • Using guidelines
3. Selecting Records
   • Selection rules
   • Using multiple fields
   • Date ranges
   • Using the OR connector
   • Using wildcards
4. Totals and Counts
   • Creating grand total sums, counts and averages
   • Creating subtotals
   • Formatting numeric fields
   • Distinct counts, averages
   • Editing text objects
   • Using the highlighting expert
   • Creating page breaks
   • Creating a summary report
5. Sorting and Grouping
   • Creating sections
   • Formatting sections
   • Changing the sort order
   • Creating groups
   • Using group names
   • Exporting data to a spreadsheet
   • Creating a report from a spreadsheet
6. Formula and Special Fields
   • Formulas using operators
   • Inserting date and page number
   • Selecting using formulas
   • Using Crystal functions
   • Using IF THEN ELSE
   • Nested IF
7. Linking Tables
   • Visual linking expert
   • Creating mailing labels

Related