Computer Training

Crystal Reports - Intermediate

Course Length: 2 Days

Course Prerequisites

  • Required: Solid understanding of Crystal Reports Introduction topics.

Course Description

  • This course looks at creating running totals, adding subreports, cross-tabs, creating charts, report speed, dictionaries, and reporting Excel data. Knowledge of programming and/or SQL would be helpful.

Detailed List of Topics

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 Cross-tab by Group
  • Change the Cross-tab Format
  • Format Rows and Columns
  • Keep Groups Together

Adding Subreports

  • Insert a Subreport
  • Link a Subreport to Data in a Primary Report
  • Edit a Subreport
  • Format a Subreport Object
  • Share Formulas Between Main and Subreports
  • Create an On-demand Subreport

Improving Report Processing Speed

  • Create a SQL Expression
  • Select Records on the Server
  • Write a SQL Query
  • Edit a SQL Query
  • Build a Report on a SQL Query
  • Create SQL Commands in Crystal Environment

Building Dictionaries

  • Create a Dictionary
  • Organize the View of Data in a Dictionary
  • Adding Graphics to the Dictionary
  • Build a Report Based on a Dictionary

Charting Data

  • Create a Chart
  • Modify a Chart
  • Create a Top N Chart
  • Format a Chart
  • Create a Chart Template

Reporting on Excel Data

  • Create a Report
  • Modify a Report
  • Update the Report