e-academy – IT training excellence in Cardiff, Newport, Bristol and South Wales

Course details
Fee £495
Days 2
Code CST_ADV

There are currently no dates scheduled for this course.

However it can still be provided on a closed-company basis – or we may schedule it on demand. Please contact us for further information.

e-mail us
or call us on
0845 650 6500

Crystal Reports Advanced

The Crystal Reports Advanced training course is available at our Cardiff training centre in Wales, which is also within easy reach of Newport, Bristol and South Wales

Overview

Since you've probably completed the first course, or are familiar with the basics of building and modifying reports, you're ready to move ahead to create complex reports and data sources using Crystal Reports' tools. In this course, you'll not only learn how to create more sophisticated reports like subreports and cross-tabs, you'll also learn how to increase the speed and efficiency of your reports by using SQL queries and dictionaries.

Examination information

  • There are no examinations associated with this course.

Prerequisites

Before attending this course, students must have:

  • Knowledge of programming and/or SQL.

Course outline

Creating Running Totals

  • Create a Running Total Field
  • Modify a Running Total Field
  • Create a Manual Running Total on Detail Data
  • Create a Manual Running Total on Summary Data

Building Cross-tabs in Your Report

  • Create a Cross-tab
  • Create a Specified Group Order
  • Filter a Cross-tab by Group
  • Change the Cross-tab Format
  • Conditionally Format Rows and Columns
  • Keep Groups Together

Adding Subreports

  • Insert a Subreport
  • Link a Subreport to Data in a Primary Report
  • Edit a Subreport
  • Format a Subreport Using the Format Editor
  • Share Formulas Between Main and Subreports
  • Create an On-demand Subreport

Creating Drill-downs

  • Create a Drill-down
  • Create Separate Headings for Drill-down Data

Enhancing Report Processing Using SQL

  • Create a Report Using SQL Queries
  • Summarize Report Data Using SQL Aggregate Functions
  • Create Joins Using SQL
  • Create Subqueries
  • Create an SQL Expression Field to Promote Server-side Processing

Charting Data

  • Create a Bar Chart
  • Modify a Chart
  • Create a Top N Chart
  • Format a Chart
  • Create a Chart Template

Reporting on 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