About this Course

Participants will gain the fundamentals of report design, and will acquire the basis for more advanced courses in the SAP BI curriculum. SAP Crystal Reports for Enterprise is a powerful, dynamic, actionable reporting solution that helps you design, explore, visualize, and deliver reports via the web or embedded in enterprise applications. This two-day instructor led course is designed to give you comprehensive skills and in-depth knowledge to plan and create reports that will help you analyze and interpret data. As a business benefit, you will find that this course is an in-depth approach to the entire report creation cycle from planning a report prototype to distribution a report.

Audience Profile

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

Course Outline

Fundamentals of planning and creating a report

• Defining database concepts
• Planning and developing a report prototype
• Logon to SAP Business Objects Enterprise
• Select a Data Source
• Connecting to a Data Source
• Create a query to retrieve data from the data source
• Using the Report Design Environment
• Report Sections
• Working with field objects
• Save a report

Report Layout and Formatting

• Setting Page properties
• Formatting options

Selecting Data

• Editing a query
• Inserting additional filter conditions
• Modifying query filters
• Applying time based filters

Sorting, Grouping and Totalling

• Sorting Data
• Grouping data
• Create nested and multiple groups
• Create a custom group
• Group on time-based data
• Total grouped data
• Total column data

Additional Report Objects

• Predefined Objects
• Graphical Objects

Formulas

• Formulas overview
• Working with the Formula Workshop
• Creating and modifying formulas
• Applying Boolean formulas
• Applying If-Then-Else formulas
• Applying date calculations
• Applying numeric calculations
• Applying string manipulation

Conditional Formatting

• Formatting Objects conditionally
• Formatting Fields conditionally with formulas
• Formatting Sections
• Formatting Sections conditionally
• Drill down on Sections

Charting

• Charting Concepts
• Charting on grouped data
• Creating a chart on detailed data
• Formatting Charts

Distributing Reports

• Exporting a report
• Saving to SAP BusinessObjects Business Intelligence Platform