Crystal Reports Level 2

Course Overview

Course Prerequisites

• • To ensure your success on this advanced Crystal Reports course, we recommend that you first attend the course Crystal Reports Level 1 course, or have equivalent knowledge.

Included with this course

• • Lunch and refreshments when training is delivered at our training venues
  • Comprehensive course materials and exercises

Course Content

• Crystal Reports Review Exercises

  Formatting Crystal Reports sections for summary/drill-down
  Creating formulas in Crystal Reports
  Selecting, grouping and summarizing
  Adding and linking databases
  Creating a basic Crystal report

• Conditional Formatting in Crystal Reports

  Removing conditional formatting
  Using the Crystal Reports highlighting expert
  Assigning conditional attribute formatting
  Applying and removing conditional on/off formatting in Crystal Reports
  Understanding the difference between absolute and conditional formatting

• Advanced Formulas / Variables in Crystal Reports

  Using variables in formulas
  Creating formulas using multiple variables in your Crystal report
  Using evaluation time functions
  Understanding multiple pass reporting
  Creating running totals

• SQL and Commands in Crystal Reports

  Adding parameters to your own SQL statement
  Defining your own SQL as the Crystal report data source
  Introduction to standard query language (SQL)

• Crystal Reports Parameter Fields

  Using Crystal Reports parameter fields to set conditional formats
  Using Crystal Reports parameter fields to specify sort criteria
  Understanding edit masks in Crystal Reports

• Report Alerts

  Viewing record sets created by use of alerts
  Creating and using Crystal report alerts

• Crystal Reports Multiple Sections

  Working with multiple sections and conditional formats
  Moving, splitting and merging sections
  Inserting and deleting sections

• Subreports

  Using variables to pass data from a sub report to the main report
  Creating on-demand subreports
  Formatting subreports
  Inserting unlinked and linked subreports
  Identifying when subreports are needed

• Basic & Advanced Cross-Tabs

  Using Crystal Reports formula fields & parameter fields with cross tab reports
  Formatting cross Tab components
  Inserting multiple rows, columns and summarized fields
  Creating basic and advanced cross tab Crystal reports

• Charting

  Formatting existing graphs
  Creating basic, calculating and cross tab related charts
  Using the Crystal Reports Chart Expert
  Crystal Reports chart types and layout options