START
 

Crystal Reports - Level 1

SquareOne Training
Course summary
Length: 2 days
Price: 440 GBP excl. VAT
Language: English
Course type: Open / Scheduled
Next available date: 02/11/2017 09:30 - Liverpool
Course Dates
Liverpool
02/11/2017 09:30  (English)
440 GBP
Contact us for more information  (English)
Birmingham
Please enquire for dates & details  (English)
440 GBP
London
Please enquire for dates & details  (English)
440 GBP

Course Description

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.

Suitability - Who should attend?

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.

Course Pre-Requisites

Prior knowledge of SQL Desirable but not essential.

For more information on suitability, please send an enquiry here

Training Course Content

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

Expenses

For information on pricing for this open/scheduled course, please send an enquiry here

This course can also be delivered in-house and tailored to meet the particular requirements of your organisation. 

Provider: SquareOne Training

SquareOne Training - In-House IT & Computer Training

We are an internationally renowned IT Training company who create inspiring, motivational and cost effective training services which bring about tangible improvements in productivity. We specialise in providing classroom courses, Microsoft upgrade training, IT consultancy and large-scale rollout support to...


Read more and show all courses with Provider: SquareOne Training

Request information - obligation free

Fill out your details to find out more about Crystal Reports - Level 1.

  Contact the provider

  Get more information

  Register your interest

Errors
Optional
Optional
Optional

Contact information for SquareOne Training

SquareOne Training



2 Tower Road
CH41 1FN Birkenhead

 Show phone number
www.squareonetraining.com

Contact SquareOne Training

Reviews by course attendees

          (4)
Delegate   |   02/03/2017
Sessions were helpful in getting to know the basics of Crystal Reports - thank you
          (5)
Delegate   |   02/03/2017
Excellent training and trainer
          (5)
Delegate   |   02/03/2017
The training was to a really high standard - I have marked a 4 and a 5 as a high standard
Enter & win £50 voucher

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Request information

Find out more about this Crystal Reports - Level 1 course - simply fill out your details:

 
Similar courses

With Activia, IT User training comes the way you want it: at your place or ours; off-the-shelf or bespoke; scheduled public classes or closed private courses matched to your requirements.

 
Case Study
SquareOne Deliver IT Rollout Pro...

Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.

Read more
 
Find more courses here