Intermediate Crystal Reports (CRY2011.2)

This course offers a comprehensive introduction to Crystal Reports, a powerful tool for creating effective and dynamic business reports. Perfect for people looking to enhance their reporting capabilities, it covers everything from basic report creation to advanced techniques, ensuring participants are well-equipped to handle various reporting scenarios.

We begin the course with a review of Crystal Reports, where you'll learn the essentials of creating a report. Participants will engage with practical exercises to understand the core functionalities and interfaces of Crystal Reports.

The next section dives into using parameters. Here, you'll learn how to create parameters and add parameter fields to your reports. We'll explore making parameters optional and using a list of parameter values. You'll also get hands-on experience with creating dynamic and cascading value lists, ensuring you understand how to manage multivalue and range parameters effectively.

Following this, we focus on using subreports, starting with unlinked subreports and progressing to linked subreports. You'll learn the differences between them and practice creating both types to enhance your reporting skills.

We'll then cover adding charts to your reports. This section teaches you how to incorporate various chart types to visually represent data, making your reports more insightful and easier to interpret.

Next, you'll learn how to create cross-tabulation reports. This includes creating cross-tab subreports, which allow for robust data analysis and presentation.

The advanced techniques section provides you with tools to enhance your reports further. Topics include adding special fields, using If and select case statements, conditional formatting, and alternating row formatting. These techniques will allow you to customize and improve the readability of your reports.

Finally, the course concludes with an exploration of report alerts, teaching you how to set up and use alerts within your reports. This feature is particularly useful for monitoring and responding to specific data points or trends.

By the end of this course, you'll possess a thorough understanding of Crystal Reports, enabling you to create detailed, dynamic reports. You'll be adept at utilizing parameters, subreports, and advanced formatting techniques to make your business reporting both efficient and insightful. Whether you're training a team or enhancing your individual skills, this course will prepare you to handle complex reporting tasks with confidence.

1. Crystal Reports Review
   1. Creating a Report
2. Using Parameters
   1. Creating Parameters
      1. Adding a Parameter Field
   2. Optional Parameters
      1. Making a Parameter Optional
   3. Using a List of Parameter Values
      1. Creating a Parameter Value List
   4. Dynamic List of Values
      1. Creating a Dynamic Value List
   5. Cascading List of Values
      1. Creating a Cascading Value List
   6. Multivalue Parameters
      1. Creating a Dynamic Value List
   7. Range Parameter
      1. Creating a Dynamic Value List
3. Using Subreports
   1. Unlinked Subreports
      1. Creating an Unlinked Subreport
   2. Linked Subreports
      1. Adding a Linked Subreport
4. Charts
   1. Adding a Chart to a Report
      1. Adding a Chart
5. Cross-Tabulation Reports
   1. Creating a Cross-Tab Report
      1. Creating a Cross-Tab Subreport
6. Advanced Techniques
   1. Special Fields
      1. Adding Special Fields to a Report
   2. Using the If Statement
      1. Using the If Statement
   3. Using the Select Case Statement
      1. Using the Select Case Statement
   4. Conditional Formatting
      1. Using Conditional Formatting
   5. Alternating Row Formatting
      1. Formatting Rows by Alternating the Colors
7. Report Alerts
   1. Using Report Alerts

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: