SAP Crystal Enterprise

Despite a few weaknesses, Crystal Reports for Enterprise gives SAP BI users a few more tools over standard Crystal Reports -- including more speed.

$850.00

Course Description

Developer customers should create their application reports using the powerful SAP Crystal Reports designer, and then use the free SAP Crystal Reports, version for Visual Studio or SAP Crystal Reports, version for Eclipse APIs and runtime engines for integrating reports with applications. Both the .net and Java runtime engines are considered component engines, as they run in-process with a hosting application.

What you will learn

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

Who Should Attend

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

 Duration
20 Hours

Prerequisite Education or Experience:

  •  Windows conventions
  •  Basic computer skills and database concepts
  •  Recommended
  •  Completion of SAP Crystal Reports: Fundamentals of Report Design

Course Contents

  • Planning Your Report Topic
  • Reviewing the Class Database Files and Report Type
  • Modifying the Program Default Settings Using Help
  • Creating Basic Reports Topic Report Sections
  • Generating a New Report
  • Viewing Your Report
  • Changing the Size and Position of Your Fields
  • Formatting Your Report
  • Adding the Finishing Touches to Your Report
  • Saving Your Report
  • Create a Formula
  • Edit a Formula
  • Filter Data Using a Formula
  • Work with Advanced Formulas and Functions
  • Handle Null Values
  • Creating Basic Reports Topic
  • Report Sections
  • Generating a New Report
  • Viewing Your Report
  • Changing the Size and Position of Your Fields
  • Formatting Your Report
  • Adding the Finishing Touches to Your Report
  • Saving Your Report
  • Sorting and Selecting Data Topic
  • Using Sort Options
  • Using the Select Expert
  • Using Multiple Criteria in the Selection Formula
  • Changing the Record Selection Formula
  • Grouping and Summarizing
  • Understanding Group Components
  • Defining Multiple-level Groups
  • Working with Grouping Options
  • Inserting Subtotals and Grand Totals
  • Working with Summary Fields
  • Calculating the Percentage of the Group to the Grand Total Functions
  • Using Grand Total Summary Function
  • Using the Top N/Sort Group Expert
  • Using the Report Expert
  • Creating a New Report Using the Standard Report Expert
  • Creating a New Report Using the Mail Label Report Expert
  • Editing Reports Using the Report Expert
  • Cross-tab Reports
  • Using Cross-tab Reports
  • Using the Cross-Tab Expert
  • Working with Existing Cross-tabs
  • Understand Cross-tab Layout
  • Features
  • Formatting Options
  • Working with Cross-Tabs
  • Adding Sub reports
  • Creating Drill-Downs in a Report
  • Creating Complex Formulas
  • Adding Charts to Reports
  • Enhancing Report Functionality
  • Create Charts
  • Create a Chart with a Drill-Down
  • Create a Top N Chart
  • Create a Cross-Tab Chart
  • Create Charts for Grouped Data
  • Format a Chart
  • Create a Chart Template
  • Creating Basic Reports Topic
  • Report Sections
  • Generating a New Report
  • Viewing Your Report
  • Changing the Size and Position of Your Fields
  • Formatting Your Report
  • Adding the Finishing Touches to Your Report
  • Create a Report
  • Modify a Report
  • Display Specific Report Data
  • Work with Report Sections
  • Creating the Report using the SAP BI server directly.
  • Adding the Cube into Crystal Reports etc
  • Adding the Sub Reports
  • Modifying the Reports.
  • Conditional Formatting
  • Absolute versus Conditional Formatting
  • Conditional Attribute Formatting
  • The Highlighting Expert
  • Restoring Conditional Formats
  • Advanced Formulas
  • Using Variables in Formulas
  • Creating a Running Total
  • Understanding Multiple-pass Reporting
  • Using Evaluation Time Functions
  • Creating Formulas Using Multiple Variables
  • Multiple Sections
  • Inserting Sections
  • Moving Sections
  • Splitting Sections
  • Multiple Sections and Conditional Formats
  • Create a Report Based on Excel Data
  • Modify a Report Generated from Excel Data
  • Update Data in a Report Based on Excel Data
  • Distributing Data
  • Create Mailing Labels
  • Adding Charts to Reports
  • Create Charts
  • Create a Chart with a Drill-Down
  • Create a Top N Chart
  • Create a Cross-Tab Chart
  • Create Charts for Grouped Data
  • Format a Chart
  • Create a Chart Template
  • Enhancing Report Functionality
  • Organize Data Based on a Hierarchy
  • Create a Dynamic Image
  • Create a Report Alert
  • Create a Geographic Map

Course Assignments

Announcements

Product FAQ