Course Description
This course is based on software release SAP Crystal Reports for Enterprise and SAP BusinessObjects BI platform 4.1.
What You'll Learn
Plan and create a report
Organize and format data
Apply record selection
Create formulas and apply conditioning report
Export and distribute reports
Who Needs to Attend
Business analyst
System administrator
Prerequisites
Knowledge of Windows
Basic database concepts is highly recommended
Follow-On Courses
SAP Crystal Reports for Enterprise: Advanced Report Design (BOCE20v15)
Course Outline
1. Report Planning
Describing Database Concepts
Planning and Developing a Report Prototype
2. SAP Business Objects BI Platform and Data Source Connection
Logging On to SAP BusinessObjects BI Platform
Defining a Data Source
3. Report Creation
Connecting to a Data Source
Creating a Query
Describing the Report Design Environment
Setting Up Report Sections
Describing the Field Objects Controls
Saving a Report
4. Report Layout and Formatting
Setting Page Properties
Applying Report Formatting Options
5. Data Selection
Editing a Query
Inserting Additional Filter Conditions
Modifying Query Filters
Applying Time-Based Filters
6. Sorting, Grouping, and Totaling
Sorting Data
Grouping Data
Creating Nested and Multiple Groups
Creating a Custom Group
Grouping on Time-Based Data
Totaling Grouped Data
Totaling Column Data
7. Additional Report Objects
Inserting Predefined Objects
Adding Graphical Objects
8. Formulas
Defining Formulas
Using the Formula Workshop
Creating and Modifying Formulas
Applying Boolean Formulas
Applying If-Then-Else Formulas
Applying Date Calculations + Applying Numeric Calculations + Applying String Manipulation
9. Conditional Formatting
Formatting Objects Conditionally
Formatting Fields Conditionally with Formulas
Formatting Sections
Formatting Sections Conditionally
Drilling Down on Sections
10. Charting
Describing Charting Concepts
Charting On Data
Formatting Charts
11. Report Distribution
Exporting a Report
Saving Reports to SAP BusinessObjects Business Intelligence Platform