Book Now

Crystal Reports - Advanced

Category: Crystal Reports, Crystal Reports Training

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

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 Duration

1 Day

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.

Course Dates 

View our full course schedule here.

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.

Enquiry Form

* indicates required

Booking

Looking for in-house training that can be customised to you/your businesses exact needs? Contact us below for one of our team to contact you.

Upcoming Courses

Below are a list of upcoming dates and locations where this course is scheduled to take place.

Location Start Date Duration Cost

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