Course Syllabus Crystal Reports 8.0, Level 2

Series: Crystal Reports 8.0

Platform: See Software Requirements

Overview: You will briefly review the basics of this report-writing software and then move on to more advanced topics including conditional formatting, advanced formulas, variables, running totals, multiple sections, parameter fields, queries, dictionaries and graphing.

Objectives: Conditionally format report objects. Create charts. Create Crystal dictionary files. Create parameter fields for report titles, selection criteria, sort options, and conditional formatting. Create queries using the Crystal SQL Designer expert. Create running total fields. Format subreports and create on-demand subreports. Insert linked and unlinked subreports. Insert multiple sections and utilize section formatting features. Modify charts using the Chart Expert and the Chart Analyzer. Use variables in formulas. Work with advanced cross-tab features.

General Prerequisites: No general prerequisites.

Prerequisites: Crystal Reports 8.0, Level 1

Table of Contents
LESSON 1:	Review and Conditional Formatting
Adding and linking databases to a report Selecting, grouping, and summarizing Creating and using formulas Formatting sections for summary/drill down reports Formatting absolute properties Formatting conditional attributes Using the highlighting expert Removing conditional and highlighted formats
LESSON 2:	Advanced Formulas
Using variables in formulas: creating, declaring, referencing Creating running totals Understanding multiple-pass reporting Using evaluation time functions Creating formulas using multiple variables
LESSON 3:	Multiple Sections and Parameter Fields
Inserting, moving and splitting sections Applying conditional formatting to sections Displaying drill-down column headings Special effects with section formatting: banded reports; watermarks Creating parameter fields and pick lists in parameter fields Using parameter fields for titles, selection criteria and sorting, and conditional formatting Working with wildcard characters in parameter fields
LESSON 4:	Advanced Cross-Tabs and Subreports
Creating cross-tabs with multiple fields Changing cross-tab summary operations Using formulas and parameters in cross-tabs Creating cross-tab objects for group values Inserting unlinked subreports Formatting subreports Inserting linked subreports Using on-demand subreports
LESSON 5:	Crystal SQL Designer and Dictionaries
Introduction to SQL Introduction to ODBC data sources Creating queries using the Crystal SQL designer Creating dictionary files Adding formulas and graphics to dictionary files Creating reports using queries or dictionaries
LESSON 6:	Graphing
Understanding chart types and layouts Using the Chart Expert to create graphs Graphing Top N values Graphing Cross-tab objects Modifying existing charts with Chart Expert Formatting graphs with Chart Analyzer