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