Crystal Report Training Course Level 1

Category: Crystal Reports, Crystal Reports Training

Working with Reports

  • Defining the purpose of a Report
  • Creating a Report
  • Formatting Reports
  • Display Specific Report Data
  • Work with Report Sections

Formulas in Reports

  • Creation and editing Formulae
  • Filtering Data with the Select Expert
  • Using Formula to Filter Data
  • Viewing and Editing the Select Formula
  • Advanced Formulas and Functions
  • Working with Null Values
  • Case Sensitive vs Case Insensitive Searching

Parameterised Reports

  • Create a Parameter Field
  • Use a Range Parameter in a Report
  • Create a Prompt

Grouping Report Data

  • Group and Modify a Group Report
  • Group by Using Parameters
  • Create a Parameterised Top Report
  • Create Multiple Groups
  • Summarising Groups

Enhancing a Report

  • Format a Report
  • Insert Objects in a Report
  • Suppress Report Sections
  • Use Report Templates

Combining Multiple Tables

  • Understanding Tables, Records, and Fields
  • Learning About Linking
  • Adding Multiple Tables to a Report

Creating a Report from Excel Data

  • Create a Report Based on Excel Data
  • Modify a Report Generated from Excel Data
  • Update Data in a Report Based on Excel Data
  • Create Summary Reports and Charts

Formulas in Reports

  • Creation and editing Formulae
  • Filtering Data with the Select Expert
  • Using Formula to Filter Data
  • Viewing and Editing the Select Formula
  • Advanced Formulas and Functions
  • Working with Null Values
  • Case Sensitive vs Case Insensitive Searching

Parameterised Reports

  • Create a Parameter Field
  • Use a Range Parameter in a Report
  • Create a Prompt

Grouping Report Data

  • Group and Modify a Group Report
  • Group by Using Parameters
  • Create a Parameterised Top Report
  • Create Multiple Groups
  • Summarising Groups

Enhancing a Report

  • Format a Report
  • Insert Objects in a Report
  • Suppress Report Sections
  • Use Report Templates

Combining Multiple Tables

  • Understanding Tables, Records, and Fields
  • Learning About Linking
  • Adding Multiple Tables to a Report

Creating a Report from Excel Data

  • Create a Report Based on Excel Data
  • Modify a Report Generated from Excel Data
  • Update Data in a Report Based on Excel Data
  • Create Summary Reports and Charts

About SquareOne

SquareOne is among the UK's leading providers of IT training to businesses of all shapes and sizes. Our company pledge is to deliver inspiring, motivational and cost effective training which brings about tangible improvements in productivity. Through our training solutions individuals are able to gain lifelong skills and realise their full potential whilst clients achieve their corporate goals.

Course Objectives

This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, and/or such tools may not be accessible. Organisations use reporting tools to access data sources and generate customised reports. SAP Crystal Reports enhances report building and report processing techniques with a wealth of features that add value to your presentation. In this course, you will create a basic report by connecting to a database and modifying its presentation.

Prior knowledge of SQL Desirable but not essential.

Course Duration

2 Days

Our course timings are 09:30 - 16:30.

Course Contents

At the end of this course you will be able to: Explore the Crystal Reports interface, create a basic report and modify it, use formulas to calculate and filter data, build a parameterised report, group report data, enhance a report, create a report using data sourced from an Excel database and distribute data.

This course is offered as a closed course at your office only. Please see our Training locations below for where we train.

Training Locations

Our open classroom courses are held in Birkenhead on the Wirral which is 5 minutes from the Merseyside tunnel. We also provide in-house training solutions at any office location in the UK or Europe. We frequently deliver training in Liverpool, Blackpool, Manchester, London, Chester, Warrington, Leeds, Cardiff, Birmingham, Edinburgh, Bristol, Sheffield, Glasgow, Leatherhead and Aberdeen as well as in European countries such as France, Switzerland, Germany, Sweden, Norway and Ireland.

Booking

To discuss course contents and booking arrangements, please call SquareOne on:

T: +44 (0)151 650 6907

E: enquiries@squareonetraining.com

Download Course Outline Request More Information

For more information about any of our courses please call +44 (0)151 650 6907,
email enquiries@squareonetraining.com or complete an enquiry form.

Back to top