Crystal Reports Part 1: Report Design Fundamentals (BOC310)

Request a Quote for this class

Audience Profile

  • Business Analysts
  • Report Writers
  • Report Designers
  • Application Developers
  • BI System Administrators

At Course Completion

  • Participants will gain the fundamentals of report design.
  • Participants will acquire the basis for more advanced courses in the SAP BI curriculum.

Prerequisites

Essential: None

Recommended: Basic knowledge of database concepts

 

Course Outline

  • Fundamentals of planning and creating a report
  • Choosing a suitable report creating method
  • Connecting to Data Sources
  • Navigating the Crystal Reports design environment & toolbars
  • Inserting Objects in a Report
  • Previewing a report
  • Saving options
  • Setting size and position of report objects
  • Formatting objects
  • Record Selection
  • Using the Select Expert tool
  • Saving and refreshing data
  • Time-based record selection
  • Data sorting, Summarizing, Grouping
  • Creating grand totals
  • Creating and managing groups
  • Grouping on time-based criteria
  • Sorting and filtering groups
  • Sorting using Specified Order tool
  • Adding graphical elements & special fields
  • Formatting Sections
  • Controlling Page Breaks
  • Creating summary-style reports
  • Using basic formulas
  • Creating If-Then-Else formulas
  • Creating Boolean formulas
  • Creating formulas with dates
  • Summary functions within formulas
  • Applying string manipulation
  • Formatting & highlighting data conditionally
  • Creating and formatting charts
  • Distributing reports
  • Output choices
  • Publishing to the SAP BI Enterprise platform
  • Basics of creating formulas and applying conditional reporting
  • Introduction to exporting and distribution of reports