COURSE OBJECTIVES
This is a 3-day instructor-led classroom training that provides you with hands-on experience to creating complex reports. You will also get a comprehensive overview of the functionality of Crystal Reports for Enterprise.
Price per Person: Click Here
TARGET AUDIENCE
Those wishing to gain hands-on experience creating complex reports including Business Analysts, Report Writers, Report Designers, Application Developers and System Administrators
PREREQUISITES
Essential
- Completion of BOCE10: SAP Crystal Reports: Fundamentals of Report Design (BOCE10)
Recommended
- Basic knowledge of database concepts
- Basic programming knowledge
Software Release and Notes
Course Based on Software Release
- SAP Crystal Reports for Enterprise
- SAP BusinessObjects BI platform 4.1
Notes
- 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 three-day instructor led course is designed to give you comprehensive skills and in-depth knowledge to create advanced reports that will help you analyze and interpret data. As a business benefit, you will be able to increase your understanding of formulas, variables, arrays, parameters, summaries and sections, which will help you to make more effective report design decisions and create more efficient reports.
Course Outline
- Running Totals
- Creating a Report with Running Totals
- Formulas and Functions
- Using String Functions and Operators
- Using Date and Time Functions
- Control Structures
- Creating Control Structures
- Variables
- Creating Variables
- Arrays and User Functions
- Creating Arrays
- Creating User Functions
- Loops
- Describing Loops in Reports
- Parameters, Filters, and Prompt Panels
- Examining Standard Parameters
- Using Interactive Filters
- Using Prompt Panels and Responding to Parameters
- Additional Parameter Types
- Using Different Types of Parameters
- Creating Date Range Parameters
- Using Edit Mask and Description Fields
- Cascading Prompts and Multiple Parameters
- Using a Cascading Prompt
- Building a Report with Multiple Parameters
- Crosstabs
- Defining Crosstabs
- Formatting a Crosstab
- Formatting Crosstabs Conditionally
- Crosstab Formulas and Calculated Members
- Using Calculated Members
- Adding Formulas to Calculated Members
- Displaying Hierarchies in Crosstabs
- Multi-Pass Reporting
- Using the Report Processing Model
- Subreports
- Defining Subreports
- Creating Subreports
- Subreports Usage
- Using Subreports
- Linked and On-Demand Subreports
- Linking a Subreport to the Main Report
- Creating On-Demand Subreports
- Advanced Subreport Usage
- Passing Data Between Subreports and Main Reports
- Linking Unlinkable Data Using Subreports
- Report Hierarchical Data
- Grouping Hierarchical Data
- Report Form Letters, Hyperlinks, and Dynamic Graphics
- Building a Form Letter Report
- Building a Report with Hyperlinks
- Using Dynamic Graphic Locations
- Additional Specialized Reports
- Building a Report with Alerts
- Building Top N and Bottom N Reports
- Integrating Flash Objects