Course Code: 626

Crystal Reports XI Designer 2 Workshop

Class Dates:
2 Days
Class Time:


  • Course Overview
  • This two-day workshop is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover professional design, techniques, subreporting and advanced formulas. This course incorporates a number of hands on exercises that reinforce the learning process.
  • Audience
  • Designed for the experienced Crystal Reports user, this course covers the more complex and powerful features of the program. The class discusses very technical issues and includes several fast-paced, comprehensive exercises. Our instructors have years of experience helping students to get the most out of their training; however, it is not always possible in a high level workshop to assist students with basic tasks.


  • In order to maximize the benefit you receive from the Crystal Reports Designer 2 Workshop, you should come into the training with a certain skill level. We assume all students who sign up for this workshop have a comfortable level of understanding in regards to relational databases.

    Students should also be able to perform the following tasks in Crystal Reports:
    • Create a new report, insert fields, save the report, and refresh the data.
    • Add multiple tables to the report using the Data Explorer.
    • Use the select expert to pull only the data needed from the database.
    • Insert groups and summarize fields within the group.
    • Perform formatting tasks.
    • Create, save, and use formulas in the report.
    Successful completion of either the Designer 1 Workshop or the Pre-qualification Exercise is strongly recommended. Please contact VTEC at 207-775-0244 for more information.
  • Recommended Courses:

  • Crystal Reports XI Designer 1 Workshop

Course Details

  • Refresher Exercise
  • Review of Planning a Report
  • Creating the Report
  • Placing Fields on the Report
  • Creating the Formulas
  • Advanced Grouping
  • Selecting Certain Records
  • Helpful Hints for Formatting the Report
  • Adding and Working with Text Objects
  • Hiding and Suppressing Sections
  • Guidelines
  • Power Formatting with Multiple Sections
  • Using Multiple Sections in Reports
  • Using the Section Expert to Work with Sections
  • Conditionally Formatting Multiple Sections
  • Advanced Drill Down Group Level
  • Using the Running Totals Feature
  • Understanding Running Totals
  • Creating Running Totals for a List of Numbers
  • Conditional Running Totals
  • Prompting with Parameters
  • Parameter Field Considerations
  • Creating a Parameter Field
  • Using a Parameter to Select Records
  • Using a Parameter Field
  • Creating a Dynamic Value List for Parameter Values
  • Importing a Pick List
  • Adding Parameter Values to Text Objects
  • Allowing Multiple Values in Parameters
  • Using Multiple Parameter Fields in Reports
  • Specifying and Limiting a Range for a Parameter
  • Using Parameters in Conditional Formatting
  • Using an Edit Mask to Limit String
  • Using Advanced Formula Features
  • Understanding How Crystal Reports Processes the Data
  • What Is a Pass?
  • Using Evaluation Time Functions
  • Working with Variables
  • Declaring a Variable
  • Assigning a Value to a Variable
  • Using a Variable in a Formula
  • Variable Scope
  • Separating Statements in Complex Formulas
  • Working with Arrays
  • Using Sub reporting as a Workaround Solution
  • Understanding Sub reports
  • Unlinked versus Linked Subreports
  • Creating an Unlinked Sub report
  • Linking a Subreport
  • Database Links versus Subreports in One-to-Many Situations
  • Creating On-Demand Subreports
  • Creating Hyperlinks
  • Using Subreports to Link "Unlinkable" Data
  • Creating Powerful Groups
  • Using the Group Expert
  • Using a Field Name to Customize the Group Name
  • Using a Formula to Customize the Group Name Field
  • Creating Custom Groups
  • Grouping on a Formula Field
  • Using Group Selection to Filter the Records in the Report
  • Grouping Hierarchically
  • Create Customized Grouping
  • Brain Teaser - Using Group Selection
  • Working with Cross-Tab Reports
  • Understanding How Cross-Tabs Affect Your Data
  • Creating a Cross-Tab Report
  • Creating a Cross- Tab with Multiple Rows or Columns
  • Applying a Formatting Style to the Cross-Tab
  • Customizing the Cross-Tab Format
  • Changing Background Colors
  • Formatting Individual Cells
  • Changing the Summary Operation
  • Suppressing Rows, Columns or Totals
  • Repeating Row Heading for Multi-Page Cross-Tabs
  • Using Alias Names for Column and Row Headings
  • Charting Cross-Tabs
  • Report Alerts
  • What are Report Alerts
  • Creating Report Alerts
  • Report Templates
  • What is a Report template
  • Standard Report Creation Wizard and Templates
  • The Template Expert
  • Applying a Template and the consequences
  • Template Considerations
  • Creating Your Own Templates
  • Inserting Template Fields
  • Formatting Template Fields
  • Giving Template Fields a Value