Crystal Reports Report Design (5 Days)

7 JULY 2008

T.B.A.

T.B.A.

$1,100

9 JULY 2008

T.B.A.

T.B.A.

$1,100

11 JULY 2008

T.B.A.

T.B.A.

$550

SPECIAL: Sign up for all 3 Crystal Reports Classes and Receive a $125 Discount!

Crystal Reports Report Design I - Fundamentals of Report Design
Alto Consulting & Training Course (CR-1001)

Course Description

This two day instructor led course is designed to give learners comprehensive skills and in-depth knowledge to plan and create reports that will help them analyze and interpret information. As a business benefit, learners will find that this course is an in-depth approach to the entire report creation cycle from planning a report prototype to distributing a report.

BusinessObjects XI R1 and BusinessObjects XI R2

This offering is applicable for both BusinessObjects XI Release 1 and XI Release 2 audiences.

Course Audience

The target audience for this course is report designers, new to Crystal Reports, who are responsible for creating and distributing reports.

Course Topics Lesson #1 - Planning a Report

• Defining database concepts
• Planning and developing a report prototype

Lesson #2 - Creating a Report

• Connecting to a data source
• Adding tables
• The design environment
• Inserting objects on a report
• Previewing and saving a report
• Positioning and sizing objects
• Formatting objects

Lesson #3 - Selecting Records

• Defining the Select Expert
• Determining the record selection criteria
• Defining saved and refreshed data
• Applying record selection
• Applying additional record selection criteria
• Modifying record selection
• Applying time-based record selection

Lesson #4 - Organizing Data on a Report

• Sorting records
• Grouping records
• Summarizing data

Lesson #5 - Formatting a Report

• Adding graphical elements
• Combining text objects with database fields
• Applying specialized formatting
• Inserting fields with pre-built functions

Lesson #6 - Applying Section Formatting

• Formatting sections
• Creating a summary report

Lesson #7 - Creating Basic Formulas

• Defining formulas
• Creating formulas
• Applying Boolean formulas
• Applying If-Then-Else formulas
• Applying date calculations
• Applying number calculations
• Applying string manipulation

Lesson #8 – Applying Conditional Reporting

• Determining trends in data
• Formatting data conditionally

Lesson #9 – Representing Data Visually

• Creating a chart

Lesson #10 – Distributing a Report

• Exporting a report
• Saving a report to BusinessObjects Enterprise

Prerequisite Knowledge/Experience

To be successful, learners who attend this course must have working knowledge of:

• Windows conventions
• Basic database concepts

  Return to Top

Crystal Reports Report Design II - Business Reporting Solutions
Alto Consulting & Training Course (CR-1002)

This two day instructor led course is designed to give learners comprehensive skills and in-depth knowledge to plan and create reports that will help them analyze and interpret information. As a business benefit, learners will find that their increased understanding of formulas, variables, arrays, templates, parameters, summaries, and sections will help them make more effective report design decisions and create more efficient reports.

BusinessObjects XI R1 and BusinessObjects XI R2

This offering is applicable for both BusinessObjects XI Release 1 and XI Release 2 audiences.

Course Audience

The target audience for this course is report designers who are responsible for creating and distributing reports and have completed RD110R2

Course Topics

Lesson #1 – Report Creation Review

• Using your Crystal Reports knowledge

Lesson #2 - Using the Repository

• Using the repository
• Creating a report from a repository data source

Lesson #3 - Creating Formulas

• Using functions and operators
• Defining control structures available in Crystal Reports Syntax

Lesson #4 - Managing Reports

• Using the Workbench
• Publishing reports to BusinessObjects Enterprise

Lesson #5 - Using Variables and Arrays

• Using variables
• Using arrays

Lesson #6 - Building Parameterized Reports

• Defining and creating parameters
• Building a report with multiple parameters
• Using edit masks and descriptions
• Creating a date range parameter
• Grouping using parameters

Lesson #7 - Using Report Templates

• Applying report templates
• Building a template without a data source
• Removing a template

Lesson #8 – Summarizing Data with Cross-Tabs

• Building a basic cross-tab
• Formatting a cross-tab

Lesson #9 – Using Report Sections

• Using sections
• Using group related functions to format sections
• Using section underlay
• Using multiple column reporting

Lesson #10 – Building Specialized Reports

• Using the Running Total Expert
• Creating a form letter
• Adding a hyperlink to a report
• Using Dynamic Graphic Locations
• Building a report with alerts
• Building a top N report

Prerequisite Education

Learners who attend this course should have completed RD110R2.

Prerequisite Knowledge/Experience

To be successful, learners who attend this course must have working knowledge of:

• Windows conventions
• Basic database concepts
• Experience using web browse

Return to Top

Crystal Reports Report Design III - Report Processing Strategies
Alto Consulting & Training Course (CR-1003)

Course Description

This one day instructor led course is designed to give learners comprehensive skills and in-depth knowledge required to plan and create reports that will help them analyze and interpret important information. As a business benefit, learners will find that their increased understanding of report processing, formulas, custom functions and subreports will help them make more effective report design decisions and create more efficient reports.

BusinessObjects XI R1 and BusinessObjects XI R2

This offering is applicable for both BusinessObjects XI Release 1 and XI Release 2 audiences.

Course Audience

This course is designed for report designers, who have taken CR: Report Design I – Fundamentals of Report Design and CR: Report Design II – Business Reporting Solutions and who are responsible for creating and distributing reports.

Course Topics Lesson #1 – Describing Report Processing

• Describing multipass reporting
• Using evaluation time functions
• Using a dynamic array

• Creating complex formulas
• Using loop control structures
• Using arrays functions and loops
• Using nested functions

Lesson #3 – Using Custom Functions

• Creating custom functions Using custom functions Modifying custom functions

Lesson #4 – Using Subreports

• Defining subreports
• Creating an unlinked subreport
• Creating a linked subreport
• Creating an on-demand subreport
• Using shared variables in a subreport
• Using subreports to link “unlinkable” data

Prerequisite Education

Learners who attend this course should have completed RD110R2 and RD210R2.

Prerequisite Knowledge/Experience

In this course you will be working intensively with Crystal Reports. To successfully understand the content and complete the activities, you must already have:

• Knowledge of Windows conventions
• Basic computer skills
• Experience using a web browser
• Basic database concepts
• Knowledge of concepts taught in the Associate level course

Note: Topics on Report Design III - Report Processing Strategies build on concepts from Report Design I – Fundamentals of Report Design and Report Design II – Business Reporting Solutions, therefore it is important that learners have a solid understanding of the concepts taught at that level.

Return to Top

Register for classes online by clicking here or
give us a call at 1-888-600-ALTO (2586).