Search Training

Crystal Reports XI - Level 1

Course Overview

In this course, students will build basic list and group reports that work with almost any database.

Who Should Attend

This course is designed for a person who needs output from a database. In some cases, database programs have limited reporting tools, and/or they may not have access to those tools. Students may or may not have programming and/or SQL experience.

Course Objectives

Upon successful completion of this course, students will be able to:

  • create a report by using data from an existing database.
  • use a report to present specific data in the desired order.
  • create groups to summarize report data.
  • build formulas to calculate and display data.
  • format reports.
  • add and modify elements in a report.
  • create single data series charts.
  • distribute report data.

    Course Outline

    1 - Creating a Report

    • Set Default Report Settings
    • Specify Fields for a New Report
    • Preview a Report
    • Modify Field Display
    • Add a Report Title
    • Position Fields
    • Add Fields from Other Tables

    2 - Displaying Specific Report Data

    • Find Data
    • Sort Data
    • Filter Data by a Single Criterion

    3 - Grouping Report Data

    • Insert a Group
    • Add Summaries
    • Format Summary Information
    • Change Group Options
    • Add a Second-Level Grouping
    • Filter Records by Group
    • Create a Top N Sort Group

    4 - Building Formulas

    • Create a Formula
    • Edit a Formula
    • Combine Fields by Formula
    • Delete a Formula
    • Filter Data by Multiple Criteria
    • Modify a Filter Using an OR Operator
    • Create a Parameter Field
    • Account for Null Fields in a Formula

    5 - Formatting Reports

    • Remove White Space
    • Insert Page Header/Footer Data
    • Add Borders, Boxes, and Lines
    • Change Field Background Color
    • Change the Margins

    6 - Enhancing Reports

    • Add a Watermark
    • Insert Objects Using Object Linking and Embedding
    • Modify Formatting Based on Data Value
    • Suppress Report Sections
    • Insert Hyperlinks
    • Hide Blank Report Sections

    7 - Creating Pie Charts

    • Create a Pie Chart with a Drill-Down
    • Modify Chart Text
    • Format a Chart
    • Present a Chart by Group

    8 - Distributing Data

    • Export to a PDF File
    • Export to a Microsoft Excel File
    • Export to an Access Database File
    • Export a Report Definition
    • Create Mailing Labels

  • Enroll Today

    This is a 2-day class

    Price: $990.00
    Payment Options

    ILT Instructor‑Led Training

    OLL Online LIVE

    GTR  Guaranteed to Run

    Class times are listed Eastern time. This class is available for Private Group Training

    To sort by location or date, click the ‘When’ and ‘Where’ column headings.

    Class dates not listed.
    Please contact us for available
    dates and times.