Main: 01633 256482 info@nilc.co.uk

SAP Crystal Reports

✓  Create powerful and richly formatted reports

✓  Reports delivered in dozens of formats from all data sources 

✓  Accessible reports available online and offline

Learn from home - we offer this course as a live instructor-led virtual session to enable you to continue learning with minimal disruption. 

Award Winning

High quality training courses

NILC 5 Stars - Trustpilot Reviews

"Excellent"

Price Promise

We'll match like-for-like prices*

Course Information

Crystal Reports is the primary recommended course you should take if your job responsibilities require you to obtain output from databases. In this course, you will start off building basic list and group reports that work with almost any database. 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. They may or may not have programming and/or SQL experience.

You will also learn how to create more sophisticated reports like sub-reports, cross-tabs, drill-downs and parameter reports. You’ll also learn how to increase the speed and efficiency of your reports by using server side SQL queries.

Creating A Report

  • Crystal Reports Window
  • Field Types
  • Specify Fields For a New Report
  • Previewing the Report
  • Modifying Field Display
  • Positioning Fields
  • Adding Fields From Additional Tables

Finding, Sorting and Filtering Data

  • Finding Data in an Existing Report
  • Sorting Data
  • Filtering Data

Grouping Report Data

  • Inserting a Group by
  • Adding Group Summaries
  • Formatting Summary Data
  • Changing an Existing Group
  • Adding a Second Group
  • Filtering Groups
  • Creating a Top N Sort

Using Formulas

  • Creating Formulas
  • Editing an Existing Formula
  • Combining Fields by Formula
  • Filtering Data Using Multiple Criteria
  • Modifying a Filter To Include an OR Operator
  • Creating a Parameter Field
  • Using a Formula To Account for Null Values

Formatting Reports

  • Removing White Spaces
  • Page Headers and Footers
  • Adding Borders, Boxes and Lines
  • Changing the Field Background Colour
  • Altering the Margins

Enhancing Reports

  • Adding Watermarks
  • Object Linking and Embedding
  • Using the Highlight Expert
  • Suppressing Report Sections
  • Inserting Hyperlinks
  • Hiding Blank Sections

Creating Pie Charts

  • Create a Pie Chart Drill-down
  • Modifying Chart text
  • Formatting a Chart
  • Charting by Group

Exporting Data

  • Exporting To PDF
  • Exporting To Excel
  • Exporting To Access
  • Exporting a Report Definition
  • Creating Labels

Creating A Running Total

  • Creating a Running Total Field
  • Modifying a Running Total
  • Suppressing the Running Total
  • Resetting the Running Total

Creating Cross-Tab Reports

  • Planning a Cross-tab Report
  • Creating a Cross-tab Report
  • Creating a Specified Group Order
  • Filtering a Cross-tab by Group
  • Changing The Cross-tab Format
  • Conditionally Formatting Rows and Columns
  • Keeping Groups Together

Adding Subreports

  • Inserting a Subreport
  • Linking a Subreport to a Primary Report
  • Editing a Subreport
  • Formatting a Subreport Object
  • Creating an On-demand Subreport

Creating Drill-downs

  • Creating Drill-downs
  • Creating Separate Headings for Drill-down Data

Creating Prompts

  • Creating a Static Prompt with Dates
  • Creating a Dynamic Prompt

Writing Basic SQL Statements

  • Creating a Report Using SQL Queries
  • Summarising Reports Using SQL Aggregate Functions
  • Creating Joins Using SQL
  • Specifying the Join Type

Advanced Charting

  • Creating a Bar Chart
  • Modifying a Chart
  • Formatting a Chart
  • Creating a Chart Template
  • Creating a Top N Chart

There is no formal assessment for this course.

This course includes:

  • Training from an experienced Crystal Reports trainer
  • Computer equipment (if required)
  • Course Materials 
  • Certificate
  • Refreshments

Course Key Points


Duration: 2 days

Accredited: No

Exam(s): N/A

Practice Exams: N/A

Type: Available as Classroom, Virtual Live and In-house

Dates and Prices for Crystal Reports

We currently have no public classroom courses scheduled, but would be more than happy to run this course for you. Please contact us using the form below and we will get back to you with some dates and prices.

3 + 15 =

Can't find the course dates or location you're looking for?

Learn from home with our instructor led Virtual courses

Looking to book 4 or more delegates onto a single course?

Please note all published prices are exclusive of VAT for consumers who pay no VAT or can recover VAT. The current rate of VAT is 20% for consumers that are required to pay VAT. All public course bookings are subject to availability and minimum course numbers.

Other Related Courses

Our registered office and postal address is 50 Commercial Road, Newport, Gwent, NP20 2PE

All quoted prices are exclusive of VAT for consumers who pay no VAT or can recover VAT. The current rate of VAT is 20% for consumers that are required to pay VAT.
All course bookings are subject to availability.