Crystal Reports 7 Advanced: Cross-Tabs, SQL, Distributing Reports

Overview/Description
This course, Crystal Reports 7 Advanced: Cross-Tabs, SQL, Distributing Reports, presents advanced concepts, including using cross-tabs, using SQL in Crystal Reports, and compiling reports.

Target Audience
You should be familiar with basic Crystal Reports concepts including creating and formatting a report, working with formulas, and creating special reports.

Expected Duration
This course, including the practice exercises, will take up to 4 hours to complete.

Objectives:

Using Cross-Tabs

  • Create cross-tab reports
  • Add cross-tabs to existing reports
  • Format the parts of cross-tabs
  • Use formulas in cross-tabs
  • Pivot cross-tabs

    • SQL and Crystal Reports

  • Create reports using SQL tables
  • Understand basic SQL statements
  • Create SQL expressions
  • Use the Crystal SQL Designer
  • Run reports from queries

    • Distributing Reports

  • Compile reports using the Report Distribution Expert
  • Run compiled reports
  • Make appropriate choices for Web-based reporting


    • Course Number: SCR0104