Monday, September 06, 2010
Crystal 11 Level 2 Minimize
Class Time 2 Days (8:30am-3:30pm)
Prerequisite: PC experience, Introduction to Windows, or experience within the Windows environment. Experience in using a mouse and reasonable degree of keyboard proficiency.

Topics covered in this class include:
RUNNING TOTALS
  • Using the running total expert
  • Placement of running total fields
  • Create a running total in a list.
  • Creating running totals for a group
  • Creating conditional running totals
SUBREPORTS
  • Introduction
  • Creating Subreports
  • Suppress Blank Subreport
  • Creating an On-Demand Subreport
  • Adding captions to on-demand subreports
  • Unlinked Subreports
CROSS–TAB REPORTS
  • Creating Cross–Tab Reports
  • Create a Cross-Tab object in a new report
  • To add a Cross-Tab to an existing report
  • Editing and Formatting Cross–Tab Reports
  • Format Rows and Columns
  • Create a Cross-Tab Using Multiple Summarized Fields
  • Cross-Tab in Group Sections
ADVANCED FORMULAS
  • Introduction
  • Formula Syntax - Crystal v. Basic
  • Evaluation Passes
  • Decision Structures
  • Nested If Statements
  • Using Select Structures
  • Understanding and Using Arrays
  • Declaring and Using Variables in Formulas
  • Declaring variables
  • Variable Scope
  • Creating Manual Running Totals
  • Create and pass a Shared Variable
  • Looping Structures -- Reference
  • For loops (Crystal syntax)
  • While Loops (Crystal syntax)
CREATING CHARTS
  • Introduction
  • Chart Layouts
  • Charting on summary or subtotal fields (Group layout)
  • Editing charts using the Chart Expert
  • Editing charts using the Chart Options menu
  • Charting on details or formula fields (Advanced layout)
  • Using the Zoom Feature with Bar and Line Charts
  • Charting on Cross-Tab summaries (Cross-Tab layout)
  • Creating a Chart Template
ADDITIONAL CRYSTAL REPORTS INFORMATION
  • Inserting OLE objects
  • OLE overview
  • Inserting OLE objects into reports
  • Creating OLE Objects in a Report
  • Report Alerts
  • Introduction
  • Creating Report Alerts
  • Editing Report Alerts
  • Deleting Report Alerts
  • Viewing Report Alerts
  • SQL Expressions
  • What is SQL?
  • Creating an SQL Expression Field
  • Hierarchical Grouping
  • Summarize Fields Across Hierarchal Groups
    

Copyright 2009 by The Continuous Improvement Center