Advanced Crystal Reports 2016

Advanced Crystal Reports 2016

In addition, some courses are available as live, online classes for individuals.

CRYSTAL REPORTS 2016 TRAINING OBJECTIVES

All students will learn to:

• Work with SQL
• Use more advance functions
• Work with geographic mapping

CRYSTAL REPORTS 2016 TRAINING PREREQUISITES

All attendees must be familiar with the basic Crystal Reports 2016 skills, as taught in  Bascom  Bridge Introduction to Crystal Reports 2016 and Intermediate Crystal Reports 2016 classes.

CRYSTAL REPORTS 2016 TRAINING MATERIALS

All students receive comprehensive courseware covering all subjects in the course.

SOFTWARE NEEDED FOR EACH PC:

• Windows 7 or later, with the latest service pack updates and at least 3 GB of RAM
• Crystal Reports 2016, with the latest updates installed
• Web browser
• Adobe Reader for viewing PDF documents
• Optional: Microsoft Excel and Access, version 2007 or later
• For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

CRYSTAL REPORTS 2016 TRAINING OUTLINE

• Introduction
• Crystal Reports Review
  • Review of Basic Report Building
• Working with SQL
  • The SELECT Statement
  • The WHERE Clause
    • Filtering with a WHERE Clause
  • The ORDER BY Clause
  • Joins
    • Joining Tables Together
  • SQL Commands
  • SQL Expressions
• Advanced Functions
  • Evaluation Time Functions
  • Working with Variables
  • For Loops
  • While Do Loops
    • Working with Variables and Loops
• Geographic Mapping
  • Geographic Maps
    • Map Basics
    • Adding a Geographic Chart
• Conclusion