Course duration
- 1 day
Course Benefits
- Review basic report building.
- Learn about working with SQL.
- Learn about more advance functions.
- Learn about geographic mapping.
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private classes are delivered for groups at your offices or a location of your choice.
Learn at your own pace with 24/7 access to an On-Demand course.
Course Outline
- Crystal Reports Review
- Review of Basic Report Building
- Working with SQL
- The SELECT Statement
- Working with SELECT Statements
- The WHERE Clause
- Filtering with a WHERE Clause
- The ORDER BY Clause
- Using ORDER BY Clauses
- Joins
- Joining Tables Together
- SQL Commands
- Using a SQL Command
- SQL Expressions
- Using a SQL Expression
- The SELECT Statement
- 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
- Geographic Maps
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this Crystal Reports class:
- Intermediate Crystal Reports experience.
Courses that can help you meet these prerequisites:
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.