Advanced Crystal Reports (CRY2011.3)

This course offers a comprehensive guide to Crystal Reports, a powerful business intelligence application widely used for designing and generating reports from a wide range of data sources. Designed for companies aiming to enhance their employees' reporting skills, it caters to both groups and individuals intending to upskill. You'll gain not only foundational knowledge but also advanced skills that can improve data presentation and decision-making processes within your organization.

We begin with a Crystal Reports Review session, focusing on the basics of report building. This foundational lesson ensures that you or your team are familiar with the core functionalities, setting a solid groundwork for more complex tasks.

Next, we focus on Working with SQL. This part of the course starts with the SELECT Statement, where we'll explore working with SELECT statements in various scenarios. Then, you'll learn about the WHERE Clause to understand how to filter data effectively. The lesson on the ORDER BY Clause will show you how to sort data, while the Joins section covers how to join tables together for more comprehensive reports. You’ll also learn to use basic SQL commands and expressions for manipulating and querying your data.

The next part of the course covers Advanced Functions. Here, you'll explore evaluation time functions, learn advanced techniques for working with variables, and understand the mechanics of loops, including the For Loops and While Do Loops. This section enhances your ability to create more efficient and dynamic reports.

Finally, you’ll tackle Geographic Mapping. This lesson introduces geographic maps, guiding you through the basics of mapping and the steps involved in adding a geographic chart to your reports. This skill is particularly beneficial for visualizing data in a spatial context, aiding in geographic analysis and better decision-making.

By the end of this course, you or your team will be proficient in using Crystal Reports for creating detailed, dynamic reports. You’ll have the skills to handle various SQL statements, employ advanced functions, and integrate geographic mapping into your reports. This knowledge not only enhances report quality but also supports better data-driven decisions across your organization.

1. Crystal Reports Review
   1. Review of Basic Report Building
2. Working with SQL
   1. The SELECT Statement
      1. Working with SELECT Statements
   2. The WHERE Clause
      1. Filtering with a WHERE Clause
   3. The ORDER BY Clause
      1. Using ORDER BY Clauses
   4. Joins
      1. Joining Tables Together
   5. SQL Commands
      1. Using a SQL Command
   6. SQL Expressions
      1. Using a SQL Expression
3. Advanced Functions
   1. Evaluation Time Functions
   2. Working with Variables
   3. For Loops
   4. While Do Loops
      1. Working with Variables and Loops
4. Geographic Mapping
   1. Geographic Maps
      1. Map Basics
      2. Adding a Geographic Chart

Each student receives a comprehensive set of materials, including course notes and all class examples.

Experience in the following is required for this Crystal Reports class: