Back to training page

Crystal Reports Advanced

This three day advanced course on Crystal Reports builds upon the foundation developed in Crystal Reports Basic and allows you to take your reports and skills to the next level.  You will learn how to perform complex report writing features and write more complex formulas including using variables in formulas, perform running totals (both automatic and manual) and use Sql Expressions.  This course is designed to provide you with the information necessary to create and format more advanced reports; group records for analytical purposes; link views and to generate useful reports for your users.

Understand when and how to use SQL Expressions

By the end of this course, you will be able to:

• Set file and report options.
• Understand how to use Advanced Crystal Formulas
• Group Data Hierarchically
• Understand and Use Variables.
• Understanding Report Processing and Evaluation Time
• Using IIF Function
• Using Select Case Statements
• Using Choose Function
• Using Switch
• Using For Loops
• Running Totals
• Manual Running Totals
• Produce accurate aging using UDF and Formulas
• Understand when and how to use SQL Expressions