SAP Crystal Reports SAP Crystal Reports Training Courses | Classroom & Virtual | NILC

SAP Crystal Reports Training Course

> Create powerful and richly formatted reports

> Classroom, Virtual and Online courses available

> Expert instructors with 5 Star customer ratings

> Onsite and customised training courses available

> ReAct and Access funding accepted

Learn from anywhere - we offer this course as a live instructor-led online virtual course that allows you to access classroom training wherever you are

Award Winning

 

High quality training courses

NILC 5 Stars - Trustpilot Reviews

Rated "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

Can’t find the course dates or training location you are looking for? We’ll try our best to accommodate.

Enter your training requirements below and a member of our team will be in contact with you to discuss them further.

 

13 + 9 =

Save time and money by letting our expert trainers come to your offices. 

Enter your onsite training requirements below and a member of our team will be in contact with you to discuss them further.

 

4 + 15 =

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

Enter your group training requirements below and a member of our team will be in contact with you to discuss them further.

 

15 + 9 =

Learn new skills from our expert instructors in your own time and at your own pace. 

Unfortunately this courses does not currently have an online self-paced learning option.

 

Can't find the course dates, location or delivery type you are looking for? Fill out the Request Dates form above and we'll try our best to accommodate. 

Classroom Courses

 Interact in person with our expert instructors in venues throughout the UK

Virtual-Live Courses

Participate in live instructor-led sessions from the comfort of your home or office

Online Self-Paced

Learn new skills from our expert instructors, in your own time and at your own pace

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.

Newport Office: NILC, 50 Commercial Road, Newport, Gwent, NP20 2PE

Cardiff Office: NILC, 13a Cathedral Road, Cardiff, CF11 9HA

Bridgend Office: NILC, Floor 1, 5 Five Bells Road, Bridgend, CF31 3HW

 

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.