Crystal Reports Training Overview
Accelebrate's Advanced Crystal Reports course teaches attendees the SQL query writing, function writing, and geographic mapping skills they need to successfully build highly customized reports.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Work with SQL
- Use more advance functions
- Work with geographic mapping
Prerequisites
All attendees must be familiar with the basic Crystal Reports skills, as taught in Accelebrate's Introduction to Crystal Reports and Intermediate Crystal Reports classes.
Outline
Expand All | Collapse All
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
- 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
Training Materials
All students receive comprehensive courseware covering all subjects in the course.
Software Requirements
- A recent version of Windows (Windows 10 recommended), with the latest service pack updates and at least 8 GB of RAM
- Crystal Reports with the latest updates installed
- Web browser
- Adobe Acrobat Reader for viewing PDF documents
- Optional: Microsoft Excel and Access, version 2007 or later
