Home | Training Classes | Consulting | Hosted Solutions | FAQ | Contact     

 

Home

Training Classes

  > Word

  > Excel

  > Access 

  > PowerPoint

  > Visio 

  > Project

  > Crystal Reports 

  > ACT!

  > Other Classes 

Consulting

Hosted Solutions

FAQ

Contact

 

 

 

ACT! Consultants

High Trust for ACT

 
 
Crystal Reports: Level 2 - Syllabus  

Introduction

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 a Primary Report
Edit a Subreport's Structure
Format a Subreport Using the Format Editor
Share Variables Between Subreports and Primary Reports
Create an On-demand Subreport

Creating Drill-downs

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

 

Enhancing Report Processing by Writing SQL Statements

Create a Report Using SQL Queries
Summarize Report Data Using SQL Aggregate Functions
Create Joins Using SQL
Create Subqueries
Create a SQL Expression Field

Charting Data

Create a Bar Chart
Modify a Chart
Format a Chart
Create a Chart Template
Create a Top N Chart
Create a Cross-tab Chart

Reporting on Excel Data with Crystal Reports

Create a Report Based on Excel Data
Modify a Report Generated from Excel Data
Update Data in a Report Based on Excel Data

Working with Prompts

Create a Static Prompt
Create a Dynamic Prompt

Enhancing Report Functionality

Group Data Hierarchically
Create a Dynamic Image
Create a Report Alert
Create a Geographic Map