Course Overview

Delegates will learn how to create advanced formulas in Crystal Reports, format Crystal reports based on calculation results (conditional formatting), use multiple sections, insert sub reports and access data from sources other than PC databases.

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.

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

Included with this course

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