Crystal 2008: Report Design I

Student Profile: This course is designed for report designers, new to Crystal Reports, who are responsible for creating and distributing reports.

Duration: 2 Days

Description: This two-day instructor-led course is designed to give learners comprehensive skills and in-depth knowledge to plan and create reports that will help them analyze and interpret important information.

Prerequisites: To successfully understand and complete the activities, you must already be able to:

  • Understand and use Windows conventions
  • Understand basic database concepts

Objectives: You will learn to plan a report, create a report, organize data on a report, format a report and create basic formulas. As well as, apply section formatting, apply conditional reporting, present data visually and distribute a report.

Topics Covered:

Planning a Report

  • Define database concepts
  • Plan and develop a report prototype

Creating a Report

  • Create a report
  • Add Tables
  • Describe the design environment
  • Insert objects on a report
  • Previewa report
  • Save a report 
  • Position and size objects
  • Format objects

Selecting Records

  • Define the Select Expert
  • Determine the criteria for record selection
  • Understanding saved and refreshed data
  • Apply record selection
  • Apply additional record selection criteria
  • Modify record selection
  • Apply time-based record selection

Organizing Data on a Report

  • Sort records
  • Group records
  • Summarize data

Formatting a Report

  • Add graphical elements
  • Combine text objects with database fields
  • Apply specialized formatting
  • Insert fields with pre-built functions

Applying Section Formatting

  • Format sections
  • Create a summary report

Creating Basic Formulas

  • Define a formula and its purpose
  • Create formulas
  • Apply Boolean formulas
  • Apply If-Then-Else formulas
  • Apply date calculations
  • Apply number calculations
  • Apply string manipulations

Applying Conditional Reporting

  • Determine trends in data
  • Format data conditionally

Representing Data Visually

  • Create a chart

Distributing Reports

  • Export a report
  • Saving a report to BusinessObjects Enterprise

 

Certification Applicability: This is a recommended course for the Business Objects Certified Professional - Crystal Reports certification.

Cost: $1,150

Copyright 2004, Westbay Solutions Group
info@westbaysolutions.com