Level 3 Crystal Reports – Harnessing the Power

---

Overview

Our Level 3 Crystal Reports class is designed to provide you with the cutting edge principles needed to move beyond your current report design limitations. In this course you will learn the advanced principles related to your data, formulas and performance.

The materials learned in this course will allow Crystal designers to fine tune their Crystal Reports development skills.

---

Audience

This course is designed for report designers who have either completed iiR's Level I and II training or are competent in the essential principles of Crystal Reports.

---

Duration

2 days

---

Syllabus

Architecture

• Understanding the core components
• Understanding multi-pass reporting
• The variety of calculation tools in Crystal, and how to choose which ones to use for various tasks

Creating Complex Formulas

• Use multi-pass reporting
• Use evaluation time functions
• Use a dynamic array
• Use Print State functions
• Use loop control structures
• Use loop control structures with arrays

Subreports

• Creating an unlinked subreport
• Creating a linked subreport
• Creating an On-demand subreport
• Updating subreports within multiple reports
• Using shared variables to share values between subreports and the main report
• When and how to avoid using subreports
• Linking "unlinkable" data with subreports

Working with Databases and Data Sources

• Applying database options
• Adjusting to database changes
• Fully Understanding the Database Expert
• Identifying the Effects of Link Types
• Setting Up and Configuring Data Sources
• Updating Reports for Database Changes
• Processing Data on the Server
• Introduction to using SQL Commands to replace Crystal linking

Validating the Report Data

Detecting and Fixing Problems

Custom Functions

• Purpose of custom functions
• Creating custom functions
• Use custom functions

Advanced Parameters

• Customizing lists of values for User Choices
• Displaying values on report when parameters are multiple-value or ranges
• Dynamic and cascading lists of values
• Creating lists of values from reports other than the report holding the parameter

Running Totals

• When and how they add power to calculation options

Cross Tabs

• Purpose of cross tabs
• Designing a cross tab

Applying Conditional Reporting

• Determine trends in data
• Format data conditionally

Students are encouraged to bring real-world examples of their report challenges, for analysis by the instructor and the class.