HOME
 

Crystal Reports - Level 1 (In-House)

SquareOne Training
Course summary
2 days
Nationwide
Next available date: Enquire for more information - United Kingdom
Corporate Training for Teams

Course description

Crystal Reports - Level 1 (In-House)

This in-house 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 in-house 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

Why choose SquareOne Training

25 years' experience of delivering quality IT Training Services

All trainers Certified Microsoft Office Trainer (MOS) or higher

Public and in-house training throughout the UK

Expenses

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

About provider

SquareOne Training - In-house IT & Computer Training

SquareOne Training

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


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Crystal Reports - Level 1 (In-House).

  Contact the provider

  Get more information

  Register your interest

Contact info

SquareOne Training

2 Tower Road
CH41 1FN Birkenhead

 Show phone number
www.squareonetraining.com


Reviews

Average rating 5

Based on 3 reviews

Carlos
(5)
Zayaan
(5)
Hannah
(5)
Request information

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

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

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

Case Study
Excel Templates For Mexichem
SquareOne Training

At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.

Read more
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