Databases

Crystal Reports Advanced

The course covers advanced Crystal Reports features needed to make professional reports. Learn how to use parameter fields, advanced functions, conditional formatting in the Formula Editor, create charts and use subreports.

Dates & Times

CourseDate & TimeLocationCost
Crystal Reports AdvancedJanuary 25 & January 26 - 8:30 - 4:30LathamRegister
Crystal Reports AdvancedMarch 19 & March 20 - 8:30 - 4:30LathamRegister
Crystal Reports AdvancedApril 30 & May 1 - 8:30 - 4:30LathamRegister

Course Outline

Corporate and NYS discounts do not apply for this course.

The course is appropriate for those familiar with the basics of Crystal who want to expand their knowledge of the program.

Includes:
Comprehensive reference manual with participant guide and exercises
Access to participant data files
Follow-up support by email or phone for an unlimited period

Lesson 1: Advanced Formulas

  • Number, string and date formulas
  • If-then-else formulas
  • Variables in formulas
  • Loops
  • Running total fields

Lesson 2: Advanced Formatting

  • Conditional formatting formulas
  • Report alerts

Lesson 3: Using Sections and Areas

  • The section expert
  • Creating summary and drill-down reports
  • Using multiple sections

Lesson 4: Creating Charts and Maps

  • Creating charts
  • Creating geographic maps

Lesson 5: Using Subreports

  • Unlinked subreports
  • Linked subreports
  • Passing data between main reports and subreports

Lesson 6: Interactive Reporting with Parameter fields

  • Creating parameter fields
  • Using parameters in data selection
  • Creating pick lists

Lesson 7: Reporting from SQL Databases

  • Viewing the SQL query
  • Crystal Reports SQL commands