Next course begins May 13th

Crystal Reports Essentials

This course designed for beginners will teach participants how to create reports using Crystal Reports. The main aim of the course is to give participants a solid understanding of using the Crystal Reports and its features. Participants will learn how to create basic reports, utilise formulas and conditional formatting and how to improve their reports further. On completion of this course participants will be able to confidently build, design and customise their own reports. 

What you'll learn

On this course participants will learn how to create engaging and dynamic reports. Participants will be taught the basics of creating simple reports and adding functionality to them. 

Course Content

Exploring Crystal Reports

  • Introducing Cystal Reports
  • Use Crystal Reports Help
  • Customize Report Settings
  • Create a Report
  • Modify a Report
  • Display Specific Report Data
  • Work with Report Sections
  • Create a Formula
  • Edit a Formula
  • Filter Data by Using a Formula
  • Work with Advanced Formulas and Functions
  • Handle Null Values
  • Create a Parameter Field
  • Use a Range Parameter in a Report
  • Create a Prompt

Reporting Data

  • Group Report Data
  • Modify a Group Report
  • Group by Using Parameters
  • Create a Parameterized Top N Report
  • Enhancing a Report
  • Format a Report
  • Insert Objects in a Report
  • Suppress Report Sections
  • Use Report Templates
  • Create a Report Based on Excel Data
  • Modify a Report Generated from Excel Data
  • Update Data in a Report Based on Excel Data
  • Export Data
  • Create Mailing Labels

Running Totals

  • Create a Running Total Field
  • Modify a Running Total Field
  • Create a Manual Running Total
  • Create a Cross-Tab Report
  • Format a Cross-Tab Report
  • Create Groups in Cross-Tab Reports
  • Insert a Subreport
  • Edit a Subreport
  • Share Variables
  • Create a Drill-Down
  • Create Headings for Drill-Down Data
  • Create a Report Using SQL Queries
  • Summarize Report Data
  • Create Joins Using SQL
  • Create Subqueries
  • Create an SQL Expression Field

Loops and Arrays

  • Work with Loops
  • Work with Arrays
  • Create Charts
  • Create a Chart with Drill-Down
  • Create a Top N Chart
  • Create a Cross-Tab Chart
  • Create Charts for Grouped Data
  • Format a Chart
  • Create a Chart Template
  • Organize Data Based on a Hierarchy
  • Create a Dynamic Image
  • Create a Report Alert
  • Create a Geographic Map

Upcoming Dates

LocationDatePrice
KigaliMay 13th, 2024₦250,000
LagosJune 10th, 2024₦250,000
LagosJuly 8th, 2024₦250,000
LagosAugust 5th, 2024₦250,000

Delivery Methods

Classroom Training

Unlock your potential with our classroom training courses. Our portfolio of business intelligence training courses are delivered by BI experts across Africa.

Online Training

Our online trainings (live instructor-led) are delivered by certified instructors and are designed to replicate a classroom experience which enables full interactions.

Onsite Training

Our onsite training team allows us to bring our skills and expertise to you. Onsite courses are developed in conjunction with you, ensuring your expectations are exceeded.

1-to-1 Training

With our one-to-one training you’ll not only receive the undivided attention of the trainer, but one-to-one training allows you to tailor the training to your specific needs.

From ₦250,000
RF600,000

Certification

Refreshments

Training multiple people?

Empower your teams with business intelligence training courses delivered by subject matter experts.

Apply for Crystal Reports Essentials

Which date are you interested in?

Apply for Crystal Reports Essentials

Which date are you interested in?