Best way to contact me *

    About this Course

    This two-day course covers the more complex and powerful features of Crystal Reports. The course focuses on the student’s ability to perform tasks using the most productive techniques allowing you to pull data from all times of data sources. The course discusses very technical issues and includes several fast-paced, comprehensive exercises.

    Audience Profile

    Experienced administrators, developers and end-users who are experienced with Crystal Reports.

    At Course Completion


    1. Refresher Exercise

    Review of Planning a Report

    Creating a 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

    2. Power Formatting

    Using Multiple Sections in Reports

    Using the Section Expert to Work with



    3. Using the Running Totals Feature

    Understanding Running Totals

    Creating Running Totals for a List of


    Conditional Running Totals

    4. Prompting with Parameters

    Parameter Fields Overview

    Parameter Field Considerations

    Creating a Parameter Field

    Using a Parameter to Select Records

    Using a Parameter Field

    Using the Parameter Panel

    Creating a Dynamic Value List

    Importing a Pick List

    Adding Parameter Values to Text


    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 Parameters

    Sorting with a Parameter

    Group Sorting with a Parameter

    Using a Parameter to set N in a Top N or

    Bottom N report

    Displaying Parameter Fields

    Cascading Parameter Fields

    5. 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

    Variable Scope

    Separating Statements in Complex


    Working with Arrays

    Understanding the Formula Evaluation

    Time Debugger

    6. Using Subreporting as a Workaround


    Understanding Subreports

    Unlinked versus Linked Subreports

    Creating an Unlinked Subreport

    Linking a Subreport

    Database Links versus Subreports in

    One-to Many Situations

    Formatting the Subreport

    Passing Data from the main Report into a Subreport

    Creating on-demand Subreports

    Creating Hyperlinks

    Using Subreports to Link “Unlinkable”


    7. Creating Powerful Groups

    Creating Custom Groups

    Customizing Group Sort Order

    Using Group Selection to Filter the

    Records in the Report

    Grouping on a Formula Field

    Grouping Hierarchically

    8. Working with Cross-Tab Reports

    Understanding How Cross-Tabs Affect Your Data

    Creating a Cross-Tab Report

    Crating a Cross-Tab with Multiple Rows or Columns

    Applying a Formatting Style to the


    Customizing the Cross-Tab Format

    Changing the Summary Operation

    Charting Cross Tabs

    Customizing Cross-Tab Group Names


    9. Report Alerts

    What are Report Alerts?

    Creating Report Alerts

    Basing Report Formulas or Conditional

    Formatting on Report Alerts

    Creative Usage for Report Alerts

    Appendix A – Report Templates

    What is a Report Template?

    Standard Report Creation Wizard and


    The Template Expert

    Applying a Template and the consequences

    Template Considerations

    Creating Your Own Templates

    Appendix B: The Northwind 2008 Database

     Appendix C: Installation and System Requirements

    Installing the Application

    Minimum Installation Requirements

    Appendix D: Setup Instructions for Crystal

    Reports 2013

     Crystal Reports 2013 Application

    Installation Instructions

    Installing Required Class Files

    Appendix E: Function and Operation



    A comfort level of understanding in regards to relational databases.


    Online Event


    Live Online Training

    Get the same training you expect in the classroom without leaving your office or home. These are NOT recorded classes. They are LIVE sessions with an expert instructor. We use the latest in video conferencing technologies and audio so you can confidently participate in any class just like being right there in person. We guarantee the effectiveness of our online training delivery approach that we will give you your money back if you are not totally satisfied.  Ask us for a demo.

    Online class requirements:

    • Moderate to fast Internet
    • A phone or computer headset is required in order to hear the instructor/moderator). You can use Computer Audio (VoIP) or you can dial in from a regular phone.  For convenience, we recommend a hands-free headset or phone.
    • Training software must be installed on your computer (trial versions are acceptable)
    • RECOMMENDED: Dual Monitors or computers. For optimal online learning experience, we recommend participants have dual monitors or two computers. Your online classroom credentials allow you to join multiple times from multiple computers. Participants should use one monitor or computer to view the instructor’s shared screen and another monitor or computer to work with the software.

    What happens when you enroll in an online class

    When you register for an online class, you will receive a welcome email followed by login access to the Citrix GoToTraining virtual classroom. A workbook (printed copy or eBook) will be sent to you prior to the start of class.

    Online Training Advantages

    Convenience: You don’t have to travel and can attend from your home, office or anywhere with an internet connection. Our online classes are conducted using GoToTraining, a more robust version of the popular GoToMeeting screen sharing and conferencing platform. To accommodate multiple time zones, courses are typically scheduled from 10am – 5pm Eastern with a one-hour lunch break at 12:30 – 1:30 pm Eastern and a 10-minute break in the morning and afternoon. When conducting custom online course for your group, class times can be modified to accommodate your timezone.

    Interactive Learning: Our online training is fully interactive. You can speak and chat with the instructor and classmates at any time. Various interactive techniques are used in every class. Our small class sizes (typically 4 – 8 students), allow our instructors to focus on individual performance and issues and to work closely with you to meet your unique needs. Classes are designed to be a hands-on learning experience, providing opportunities for you to try your new skills while the instructor is available for review, questions, and feedback. You have the option to give the instructor permission to view your computer to provide one-on-one assistance when needed.

    GSA Schedule: 47QTCA19D008F