HOME
 

Crystal Reports - Advanced (In-House)

SquareOne Training
Course summary
1 day
English
Corporate Training for Teams
Next available date: Enquire for more information - United Kingdom
Course Dates
United Kingdom
Enquire for more information  (English)
Enquire for more information  (English)
Enquire for more information  (English)
Enquire for more information  (English)

Course description

Crystal Reports - Advanced

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.

Training Course Content

Power Formatting with Multiple Sections

  • Using Multiple Sections in Reports
  • Using the Section Expert to Work with Sections
  • Conditionally Formatting Multiple Sections

Using the Running Totals Feature

  • Understanding Running Totals
  • Creating Running Totals for a List of Numbers
  • Conditional Running Totals

Setting Default and Report Options

  • Setting the Default Layout for Design and Preview Views

Using Advanced Formula Features

  • Understanding How Crystal Reports Processes the Data
  • What Is a Pass
  • Using Evaluation Time Functions
  • Working with Variables
  • Declaring a Variable
  • Assigning a Value to a Variable
  • Using a Variable in a Formula
  • Variable Scope
  • Separating Statements in Complex Formulas
  • Working with Arrays
  • Understanding the Formula Evaluation Time Debugger

Using Sub reporting as a Workaround Solution

  • Understanding Subreports
  • Unlinked versus Linked Subreports
  • Creating an Unlinked Subreport
  • Linking a Subreport
  • Database Links versus Subreports in One-to-Many Situations
  • Formatting the Subreport
  • Passing Data from the Main Report into a Subreport
  • Creating On-Demand Subreports
  • Creating Hyperlinks
  • Using Subreports to Link "Unlinkable" Data

Creating Powerful Groups

  • Customizing the Group Name Field
  • Using a Field Name to Customize the Group Name
  • Using a Formula to Customize the Group Name Field
  • Creating Custom Groups
  • Customizing Group Sort Order
  • Grouping on a Formula Field
  • Using Group Selection to Filter the Records in the Report
  • Grouping Hierarchically

Working with Cross-Tab Reports

  • Understanding How Cross-Tabs Affect Your Data
  • Creating a Cross-Tab Report
  • Creating a Cross-Tab with Multiple Rows or Columns
  • Applying a Formatting Style to the Cross-Tab
  • Customizing the Cross-Tab Format
  • Changing Background Colours
  • Formatting Individual Cells
  • Changing the Summary Operation
  • Suppressing Rows, Columns or Totals
  • Repeating Row Heading for Multi-Page Cross-Tabs
  • Using Alias Names for Column and Row Headings
  • Charting Cross-Tabs
  • Customizing Cross-Tab Group Names
  • CurrentFieldValue

Report Alerts

  • What are Report Alerts
  • Creating Report Alerts
  • Basing Report Formulas or Conditional Formatting on Report Alerts
  • Creative Usage for Report Alerts

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 course, please give us a call on 0151 650 6907.

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

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 - Advanced (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


Request information

Find out more about this Crystal Reports - Advanced (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
SquareOne Deliver IT Rollout Pro...

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

Read more
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
Find more courses here