Hello, Optima Training has detected that you are using an outdated version of Internet Explorer. If possible we strongly urge you to update your browser or switch over to Chrome or Firefox so you can enjoy the full user experience of our website and avail of all the features!
Close This Message'

Crystal Reports – Level 1

This Crystal Reports – Level 1 In House company training course is a 2 Day programme designed for those who need specific output from a database.
Crystal Reports: Level 1 is the primary recommended course where job responsibilities require you to obtain output from databases.


*Please email or call for a quote.

Product Code:
2 Days
Cost Includes:
Training course materials and after-training support
Contact Name:
Sinead Landers
X €
Make an Enquiry
Attendee(s), if more than one seperate with a comma
Course Content
Intended Audience
Method Of Delivery

Course Contents:

Creating a Report

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

Displaying Specific Report Data

  • Find Data
  • Sort Data
  • Filter Data by Single Criteria

Grouping Report Data

  • Insert a Group
  • Add Summaries
  • Format Summary Information
  • Change Group Options
  • Add an Additional Group
  • Filter by Group
  • Create a Top N Sort Group

Building Formulas

  • Write a Formula
  • Edit a Formula
  • Group by Formula
  • Delete a Formula
  • Delete a Formula
  • Build a Filter by Multiple Criteria
  • Modify a Filter with Multiple Criteria to Create an OR Condition
  • Create a Parameter Field
  • Write a Formula that incorporates Null Fields

Formatting Reports

  • Remove White Space
  • Insert Page Header / Footer Data
  • Add Borders & Lines
  • Change the Background Colour
  • Change the Margins

Enhancing Reports

  • Create a Section to Contain a Watermark
  • Insert Objects Using Object Linking and Embedding
  • Modify Format Based on Data Value
  • Conditionally Suppress Data
  • Insert Hyperlinks
  • Hide Blank Report Sections

Creating and Modifying Pie Charts

  • Create a Pie Chart h a Drill-down
  • Modify Chart Text
  • Format a Chart
  • Present a Chart by Group

Distributing Data

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

This Crystal Reports – Level 1 training programme may be beneficial to those staff who are required to obtain information from a database and build basic list and group reports that work with almost any database.

Before taking this course, students should be familiar with the basic functions of their computer’s operating system such as creating folders, opening programs, and working with Windows. Learners should have basic Windows application skills, such as copying and pasting objects, formatting text, saving files, etc. Learners should have a basic understanding of database concepts.


This is designed to be a practical hands on course with each trainees following the presentation and having access to a PC / Laptop.

There are no reviews yet.

Be the first to review “Crystal Reports – Level 1”