An organisation development specialistLinked In

Crystal Reports

Duration 2 days 


Course Content

Overview

  • What is Crystal Reports
  • Preview sample reports
  • Preview sample databases
  • The Crystal Report window
  • Using help


Creating Basic Reports

  • Creating a new report
  • Inserting database fields
  • Previewing a report
  • Selecting multiple objects
  • Moving and resizing objects
  • Inserting text objects
  • Formatting objects
  • Saving a report
  • Saved data vs. refresh data
  •  

Sorting, Grouping and Summarizing

  • Sorting records
  • Inserting groups
  • Group Name field
  • Changing group options
  • Creating specified groups
  • Inserting subtotals
  • Inserting grand totals
  • Inserting summary fields
  • Top N group expert

Record Selection

  • Selection records
  • Multiple selection criteria
  • Editing the record selection formula

Creating Formulas

  • Why use formulas
  • Formula components
  • Using the Formula Editor
  • Editing a formula
  • Renaming a formula
  • Deleting a formula
  • String functions
  • Date Functions
  • Formulas using summary fields
  • If-Then-Else formulas
  • Linking
  • What is linking?
  • Join types
  • Self joins
  • PC database links
  • SQL/ODBC database links
  • Using the visual linking expert


Using the Report Expert

  • Creating a report using the Report Expert
  • Edit report using the Report Expert

Section Formatting

  • Report section definitions
  • Using the Section Expert
  • Section format options
  • Summary/Drill-Down Reports


Basic Cross-Tabs

  • What is a Cross-Tab?
  • Using the Cross-Tab Expert
  • Editing a Cross-Tab layout
  • Additional Cross-Tab layout features


Report Distribution

  • Exporting a report to another format
  • Mailing a report
  • Compiling a report


Additional Formatting & File Options

  • Inserting special fields
  • Inserting fields in text objects
  • Moving and copying objects
  • Inserting lines and boxes
  • Inserting pictures
  • Changing file options
More