Office 365
Training
Welcome!    Login | Checkout 0 Items | Checkout
ETI Performance Improvement

Software Training

Showing that application who's boss since 1984


Crystal Reports

Please Select Your Version: 2008 2011 2013 2016 XI

Turn information from almost any data source into a sophisticated, interactive report – with our market-leading report design software, SAP Crystal Reports. This powerful, user friendly application can help you deliver key insights for smarter operational and strategic decision making.



Choose Session Level

Level 1
Level 2
What Level Is Right For Me?
Contact Our Sales Team!
Level 1
Level 2
What Level Is Right For Me?
Contact Our Sales Team!
Level 1
Level 2
Level 3
What Level Is Right For Me?
Contact Our Sales Team!
Level 1
Level 2
Level 3
What Level Is Right For Me?
Contact Our Sales Team!
Level 1
Level 2
What Level Is Right For Me?
Contact Our Sales Team!

Topics
Dates & Registration

Crystal Reports 2008

Level 1

This two day interactive workshop was designed for new users of Crystal Reports 2008. Some of the topics covered include a review of the software features, report design and the creation of presentation quality reports. This course incorporates a number of hands on exercises to reinforce the learning process.

Crystal Reports

2 Days

List Price: $850


Register!

Topic 1: Creating a Report

  • Starting the Crystal Reports Program
  • Starting a New Report
  • Choosing a Data Source
  • The Main Components of the Design Window
  • Exploring the Toolbars
  • Managing Resources with Explorers
  • Placing Fields on the Report
  • Selecting and Sizing Objects
  • Browsing Field Data
  • Moving and Aligning Objects
  • Using Guides and Guidelines to Move and Align Objects
  • Creating Text Objects
  • Saving the Report
  • Auto-saving the Report
  • Previewing the Report
  • Refreshing the Data
  • Using the Status Bar
  • Getting Help
  • Challenge Exercise - Creating a Basic Report

Topic 2: Formatting Features

  • Quick Formatting with the Template Expert
  • Using the Format Painter
  • Formatting Objects
  • Inserting Lines and Boxes
  • Inserting Graphics
  • Working with the Page Commands
  • Changing Page Orientation
  • Changing Margins
  • Working with Text Objects
  • Adding Fields into a Text Object
  • Formatting Part or All of an Object
  • Inserting Special Fields
  • Challenge Exercise – Formatting Features

Topic 3: Database Filters

  • Filtering Data with the Select Expert
  • Selecting Records with Multiple Criteria
  • Viewing and Editing the Select Formula
  • Case Sensitive vs. Case Insensitive
  • Record Selection Formula Templates
  • Challenge Exercise - Selecting Specific RecordsChallenge Exercise - Selecting a Range of Values

Topic 4: Report Grouping

  • When and Why to Group Records
  • Creating a Group
  • Group and Sort Direction
  • Customize Group Name Field
  • Modifying Groups
  • Creating Multiple Groups in a Report
  • Using the Group Tree to Navigate the Report
  • Reordering Groups
  • Using the Sort Control
  • Summarizing Groups
  • Additional Summary Options
  • Grouping Data in Date/Time Intervals
  • Calculating Percentages
  • Ordering Groups Based on Their Subtotals Using the Group Sort Expert
  • Challenge Exercise - Grouping, Sorting, Summarizing
  • Challenge Exercise - Calculating Percentages

Topic 5: Multiple Table Joins

  • Understanding Tables, Records, and Fields
  • Learning About Linking
  • Adding Multiple Tables to a Report
  • Challenge Exercise - Using the Database Expert to Link Tables

Topic 6: Creating Formulas

  • Understanding Crystal Formula Syntax without Being a Programmer
  • About the Formula Workshop
  • Using the Formula Workshop
  • Using the Formula Editor
  • The Formula Editor Toolbar
  • Performing Simple Number Calculations
  • Manipulating Dates with Formulas
  • Creating Boolean (True/False) Formulas
  • Creating String Formulas
  • Using Bookmarks to Navigate Through Formulas
  • Challenge Exercise - Creating String Formulas Challenge
  • Exercise – Creating String Formulas
  • Challenge Exercise – Doing Calculations
  • Challenge Exercise – Subtracting Dates
  • Challenge Exercise – Using Nested If Statements

Topic 7: Conditional Formatting

  • Formatting Sections
  • Formatting Sections Conditionally
  • Conditionally Formatting Fields
  • Challenge Exercise - Section Formatting and Conditional Formatting
  • Summary Reports and Charts

Topic 8: Creating a Summary Report

  • Applying the Drill Down Feature
  • Applying the DrillDownGroupLevel
  • Producing Charts
  • Editing Charts
  • Formatting Charts
  • Using the Chart Options
  • Modifying Individual Objects in the Chart
  • Applying Chart Templates
  • Challenge Exercise - Creating a Summary Report
  • Challenge Exercise - Charting

Topic 9: Exporting Reports

  • Understanding Export Formats and Destinations
  • Using a PDF Format for Crystal Reports
  • Exporting to Windows Applications
  • Exporting to a Report Definition Format

Topic 10: Report Wizards

  • What are the Report Wizards?
  • Create a Report Using the Standard Report Creation Wizard
  • The Data Dialog Box
  • The Fields Dialog Box
  • The Grouping Dialog Box
  • The Summaries Dialog Box
  • The Group Sorting Dialog Box
  • The Chart Dialog Box
  • The Record Selection Dialog Box The Template Dialog Box
  • Challenge Exercise - Create a Report Using a Report Wizard

Crystal Reports 2008

Level 1

2 Days

List Price: $850

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

Crystal Reports 2008

Level 2

This two-day workshop is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice.

In addition, you will cover professional design, techniques, sub-reporting and advanced formulas. This course incorporates a number of hands on exercises that reinforce the learning process.

Crystal Reports

2 Days

List Price: $850


Register!

Topic 1: Power Formatting and Formulas

Power formatting with multiple sections

  • Using multiple sections in reports
  • Using the Section Export to work with sections
  • Conditionally formatting multiple sections

Using the Running Totals feature
  • Understanding Running Totals
  • Creating Running Totals for a list of numbers
  • Conditional Running Totals

Prompting with Parameters

  • Parameter field considerations
  • Creating a parameter field
  • Using a parameter to select records
  • Using the Parameter Panel
  • Creating a dynamic value list for parameter values
  • Importing a Pick List
  • Adding parameter values to Text Objects
  • Allowing Multiple values in parameters
  • Using multiple parameter fields in reports
  • Specifying and limiting a range
  • Using parameters in conditional formatting
  • Using an Edit Mask to limit string parameters
  • Sorting with a parameter
  • Using a parameter to set N in a Top N Report
  • Cascading Parameters
Using Advanced Formula Features
  • Understanding how Crystal Reports processes the data
  • What is a Pass?
  • Using Evalution Time Functions
  • Working with variables
  • Declaring a variable
  • Assigning a value to a variable
  • Using a variable in a formula
  • Variable scope
  • Separating statements in complex formulas
  • Working with arrays
  • Understanding the Evaluation Time Debugger
Topic 2: Tools for Creating Advanced ReportsUsing Sub reporting as a Workaround Solution
  • Understanding Sub reports
  • Unlinked versus Linked Subreports
  • Creating an unlinked sub report
  • Linking a subreport
  • Database Links versus subreports in one-to-many situations
  • Formatting the subreport
  • Passing data from the main report into a subreport
  • Creating On-demand Subreports
  • Creating hyperlinks
  • Using subreports to link "unlinkable" data
Creating Powerful Groups
  • Creating custom groups
  • Customizing group sort order
  • Using group selection to filter the records in the report
  • Grouping on a formula field
  • Grouping hierachically
Working with Cross-Tab Reports
  • Understanding how cross-tabs affect your data
  • Creating a cross-tab report
  • Creating a cross-tab with multiple rows or columns
  • Applying a formatting style to the cross-tab
  • Customizing the cross-tab format
  • Changing background colors
  • Formatting individual cells
  • Changing the summary operation
  • Suppressing rows, columns or totals
  • Repeating row heading for multi-page cross-tabs
  • Using alias names for column and row headings
  • Charting cross-tabs
  • Customizing cross-tab group names
  • Using the CurrentFieldValue function
Report Alerts
  • What are Report Alerts
  • Creating report alets
  • Basing report formulas or conditional formatting on report alerts
  • Creative usage for report alerts

Crystal Reports 2008

Level 2

2 Days

List Price: $850

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

Crystal Reports 2011

Level 1

This two day interactive workshop was designed for new users of Crystal Reports 2011. Some of the topics covered include a review of the software features, report design and the creation of presentation quality reports. This course incorporates a number of hands on exercises to reinforce the learning process.

2 Days

List Price: $850


Register!

Topic 1: Creating a Report

  • Starting the Crystal Reports Program
  • Starting a New Report
  • Choosing a Data Source
  • The Main Components of the Design Window
  • Exploring the Toolbars
  • Managing Resources with Explorers
  • Placing Fields on the Report
  • Selecting and Sizing Objects
  • Browsing Field Data
  • Moving and Aligning Objects
  • Using Guides and Guidelines to Move and Align Objects
  • Creating Text Objects
  • Saving the Report
  • Auto-saving the Report
  • Previewing the Report
  • Refreshing the Data
  • Using the Status Bar
  • Getting Help
  • Challenge Exercise - Creating a Basic Report

Topic 2: Formatting Features

  • Quick Formatting with the Template Expert
  • Using the Format Painter
  • Formatting Objects
  • Inserting Lines and Boxes
  • Inserting Graphics
  • Working with the Page Commands
  • Changing Page Orientation
  • Changing Margins
  • Working with Text Objects
  • Adding Fields into a Text Object
  • Formatting Part or All of an Object
  • Inserting Special Fields
  • Challenge Exercise – Formatting Features

Topic 3: Database Filters

  • Filtering Data with the Select Expert
  • Selecting Records with Multiple Criteria
  • Viewing and Editing the Select Formula
  • Case Sensitive vs. Case Insensitive
  • Record Selection Formula Templates
  • Challenge Exercise - Selecting Specific RecordsChallenge Exercise - Selecting a Range of Values

Topic 4: Report Grouping

  • When and Why to Group Records
  • Creating a Group
  • Group and Sort Direction
  • Customize Group Name Field
  • Modifying Groups
  • Creating Multiple Groups in a Report
  • Using the Group Tree to Navigate the Report
  • Reordering Groups
  • Using the Sort Control
  • Summarizing Groups
  • Additional Summary Options
  • Grouping Data in Date/Time Intervals
  • Calculating Percentages
  • Ordering Groups Based on Their Subtotals Using the Group Sort Expert
  • Challenge Exercise - Grouping, Sorting, Summarizing
  • Challenge Exercise - Calculating Percentages

Topic 5: Multiple Table Joins

  • Understanding Tables, Records, and Fields
  • Learning About Linking
  • Adding Multiple Tables to a Report
  • Challenge Exercise - Using the Database Expert to Link Tables

Topic 6: Creating Formulas

  • Understanding Crystal Formula Syntax without Being a Programmer
  • About the Formula Workshop
  • Using the Formula Workshop
  • Using the Formula Editor
  • The Formula Editor Toolbar
  • Performing Simple Number Calculations
  • Manipulating Dates with Formulas
  • Creating Boolean (True/False) Formulas
  • Creating String Formulas
  • Using Bookmarks to Navigate Through Formulas
  • Challenge Exercise - Creating String Formulas Challenge
  • Exercise – Creating String Formulas
  • Challenge Exercise – Doing Calculations
  • Challenge Exercise – Subtracting Dates
  • Challenge Exercise – Using Nested If Statements

Topic 7: Conditional Formatting

  • Formatting Sections
  • Formatting Sections Conditionally
  • Conditionally Formatting Fields
  • Challenge Exercise - Section Formatting and Conditional Formatting
  • Summary Reports and Charts

Topic 8: Creating a Summary Report

  • Applying the Drill Down Feature
  • Applying the DrillDownGroupLevel
  • Producing Charts
  • Editing Charts
  • Formatting Charts
  • Using the Chart Options
  • Modifying Individual Objects in the Chart
  • Applying Chart Templates
  • Challenge Exercise - Creating a Summary Report
  • Challenge Exercise - Charting

Topic 9: Exporting Reports

  • Understanding Export Formats and Destinations
  • Using a PDF Format for Crystal Reports
  • Exporting to Windows Applications
  • Exporting to a Report Definition Format

Topic 10: Report Wizards

  • What are the Report Wizards?
  • Create a Report Using the Standard Report Creation Wizard
  • The Data Dialog Box
  • The Fields Dialog Box
  • The Grouping Dialog Box
  • The Summaries Dialog Box
  • The Group Sorting Dialog Box
  • The Chart Dialog Box
  • The Record Selection Dialog Box The Template Dialog Box
  • Challenge Exercise - Create a Report Using a Report Wizard

Crystal Reports 2011

Level 1

2 Days

List Price: $850

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

Crystal Reports 2011

Level 2

This two-day workshop is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice.

In addition, you will cover professional design, techniques, sub-reporting and advanced formulas. This course incorporates a number of hands on exercises that reinforce the learning process.

2 Days

List Price: $850


Register!

Topic 1: Power Formatting and Formulas

Power formatting with multiple sections

  • Using multiple sections in reports
  • Using the Section Export to work with sections
  • Conditionally formatting multiple sections
Using the Running Totals feature
  • Understanding Running Totals
  • Creating Running Totals for a list of numbers
  • Conditional Running Totals

Prompting with Parameters

  • Parameter field considerations
  • Creating a parameter field
  • Using a parameter to select records
  • Using the Parameter Panel
  • Creating a dynamic value list for parameter values
  • Importing a Pick List
  • Adding parameter values to Text Objects
  • Allowing Multiple values in parameters
  • Using multiple parameter fields in reports
  • Specifying and limiting a range
  • Using parameters in conditional formatting
  • Using an Edit Mask to limit string parameters
  • Sorting with a parameter
  • Using a parameter to set N in a Top N Report
  • Cascading Parameters

Using Advanced Formula Features

  • Understanding how Crystal Reports processes the data
  • What is a Pass?
  • Using Evalution Time Functions
  • Working with variables
  • Declaring a variable
  • Assigning a value to a variable
  • Using a variable in a formula
  • Variable scope
  • Separating statements in complex formulas
  • Working with arrays
  • Understanding the Evaluation Time Debugger

Topic 2: Tools for Creating Advanced Reports

Using Sub reporting as a Workaround Solution

  • Understanding Sub reports
  • Unlinked versus Linked Subreports
  • Creating an unlinked sub report
  • Linking a subreport
  • Database Links versus subreports in one-to-many situations
  • Formatting the subreport
  • Passing data from the main report into a subreport
  • Creating On-demand Subreports
  • Creating hyperlinks
  • Using subreports to link "unlinkable" data
Creating Powerful Groups
  • Creating custom groups
  • Customizing group sort order
  • Using group selection to filter the records in the report
  • Grouping on a formula field
  • Grouping hierachically
Working with Cross-Tab Reports
  • Understanding how cross-tabs affect your data
  • Creating a cross-tab report
  • Creating a cross-tab with multiple rows or columns
  • Applying a formatting style to the cross-tab
  • Customizing the cross-tab format
  • Changing background colors
  • Formatting individual cells
  • Changing the summary operation
  • Suppressing rows, columns or totals
  • Repeating row heading for multi-page cross-tabs
  • Using alias names for column and row headings
  • Charting cross-tabs
  • Customizing cross-tab group names
  • Using the CurrentFieldValue function
Report Alerts
  • What are Report Alerts
  • Creating report alets
  • Basing report formulas or conditional formatting on report alerts
  • Creative usage for report alerts

Crystal Reports 2011

Level 2

2 Days

List Price: $850

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

Crystal Reports 2013

Level 1

This two day interactive workshop was designed for new users of Crystal Reports 2013. Some of the topics covered include a review of the software features, report design and the creation of presentation quality reports. The course incorporates a number of hands on exercises to reinforce the learning process.

2 Days

List Price: $850


Register!

Topic 1: Creating a Report

  • Starting the Crystal Reports Program
  • Starting a New Report
  • Choosing a Data Source
  • The Main Components of the Design Window
  • Exploring the Toolbars
  • Managing Resources with Explorers
  • Placing Fields on the Report
  • Selecting and Sizing Objects
  • Browsing Field Data
  • Moving and Aligning Objects
  • Using Guides and Guidelines to Move and Align Objects
  • Creating Text Objects
  • Saving the Report
  • Auto-saving the Report
  • Previewing the Report
  • Refreshing the Data
  • Using the Status Bar
  • Getting Help
  • Challenge Exercise - Creating a Basic Report

Topic 2: Formatting Features

  • Quick Formatting with the Template Expert
  • Using the Format Painter
  • Formatting Objects
  • Inserting Lines and Boxes
  • Inserting Graphics
  • Working with the Page Commands
  • Changing Page Orientation
  • Changing Margins
  • Working with Text Objects
  • Adding Fields into a Text Object
  • Formatting Part or All of an Object
  • Inserting Special Fields
  • Challenge Exercise – Formatting Features

Topic 3: Database Filters

  • Filtering Data with the Select Expert
  • Selecting Records with Multiple Criteria
  • Viewing and Editing the Select Formula
  • Case Sensitive vs. Case Insensitive
  • Record Selection Formula Templates
  • Challenge Exercise - Selecting Specific RecordsChallenge Exercise - Selecting a Range of Values

Topic 4: Report Grouping

  • When and Why to Group Records
  • Creating a Group
  • Group and Sort Direction
  • Customize Group Name Field
  • Modifying Groups
  • Creating Multiple Groups in a Report
  • Using the Group Tree to Navigate the Report
  • Reordering Groups
  • Using the Sort Control
  • Summarizing Groups
  • Additional Summary Options
  • Grouping Data in Date/Time Intervals
  • Calculating Percentages
  • Ordering Groups Based on Their Subtotals Using the Group Sort Expert
  • Challenge Exercise - Grouping, Sorting, Summarizing
  • Challenge Exercise - Calculating Percentages

Topic 5: Multiple Table Joins

  • Understanding Tables, Records, and Fields
  • Learning About Linking
  • Adding Multiple Tables to a Report
  • Challenge Exercise - Using the Database Expert to Link Tables

Topic 6: Creating Formulas

  • Understanding Crystal Formula Syntax without Being a Programmer
  • About the Formula Workshop
  • Using the Formula Workshop
  • Using the Formula Editor
  • The Formula Editor Toolbar
  • Performing Simple Number Calculations
  • Manipulating Dates with Formulas
  • Creating Boolean (True/False) Formulas
  • Creating String Formulas
  • Using Bookmarks to Navigate Through Formulas
  • Challenge Exercise - Creating String Formulas Challenge
  • Exercise – Creating String Formulas
  • Challenge Exercise – Doing Calculations
  • Challenge Exercise – Subtracting Dates
  • Challenge Exercise – Using Nested If Statements

Topic 7: Conditional Formatting

  • Formatting Sections
  • Formatting Sections Conditionally
  • Conditionally Formatting Fields
  • Challenge Exercise - Section Formatting and Conditional Formatting
  • Summary Reports and Charts

Topic 8: Creating a Summary Report

  • Applying the Drill Down Feature
  • Applying the DrillDownGroupLevel
  • Producing Charts
  • Editing Charts
  • Formatting Charts
  • Using the Chart Options
  • Modifying Individual Objects in the Chart
  • Applying Chart Templates
  • Challenge Exercise - Creating a Summary Report
  • Challenge Exercise - Charting

Topic 9: Exporting Reports

  • Understanding Export Formats and Destinations
  • Using a PDF Format for Crystal Reports
  • Exporting to Windows Applications
  • Exporting to a Report Definition Format

Topic 10: Report Wizards

  • What are the Report Wizards?
  • Create a Report Using the Standard Report Creation Wizard
  • The Data Dialog Box
  • The Fields Dialog Box
  • The Grouping Dialog Box
  • The Summaries Dialog Box
  • The Group Sorting Dialog Box
  • The Chart Dialog Box
  • The Record Selection Dialog Box The Template Dialog Box
  • Challenge Exercise - Create a Report Using a Report Wizard

Crystal Reports 2013

Level 1

2 Days

List Price: $850

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

Crystal Reports 2013

Level 2

This two-day workshop is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice.

In addition, you will cover professional design, techniques, sub-reporting and advanced formulas. This course incorporates a number of hands on exercises that reinforce the learning process.

2 Days

List Price: $850


Register!

Topic 1: Power Formatting and Formulas

Power formatting with multiple sections

  • Using multiple sections in reports
  • Using the Section Export to work with sections
  • Conditionally formatting multiple sections
Using the Running Totals feature
  • Understanding Running Totals
  • Creating Running Totals for a list of numbers
  • Conditional Running Totals

Prompting with Parameters

  • Parameter field considerations
  • Creating a parameter field
  • Using a parameter to select records
  • Using the Parameter Panel
  • Creating a dynamic value list for parameter values
  • Importing a Pick List
  • Adding parameter values to Text Objects
  • Allowing Multiple values in parameters
  • Using multiple parameter fields in reports
  • Specifying and limiting a range
  • Using parameters in conditional formatting
  • Using an Edit Mask to limit string parameters
  • Sorting with a parameter
  • Using a parameter to set N in a Top N Report
  • Cascading Parameters

Using Advanced Formula Features

  • Understanding how Crystal Reports processes the data
  • What is a Pass?
  • Using Evalution Time Functions
  • Working with variables
  • Declaring a variable
  • Assigning a value to a variable
  • Using a variable in a formula
  • Variable scope
  • Separating statements in complex formulas
  • Working with arrays
  • Understanding the Evaluation Time Debugger

Topic 2: Tools for Creating Advanced Reports

Using Sub reporting as a Workaround Solution

  • Understanding Sub reports
  • Unlinked versus Linked Subreports
  • Creating an unlinked sub report
  • Linking a subreport
  • Database Links versus subreports in one-to-many situations
  • Formatting the subreport
  • Passing data from the main report into a subreport
  • Creating On-demand Subreports
  • Creating hyperlinks
  • Using subreports to link "unlinkable" data

Creating Powerful Groups

  • Creating custom groups
  • Customizing group sort order
  • Using group selection to filter the records in the report
  • Grouping on a formula field
  • Grouping hierachically

Working with Cross-Tab Reports

  • Understanding how cross-tabs affect your data
  • Creating a cross-tab report
  • Creating a cross-tab with multiple rows or columns
  • Applying a formatting style to the cross-tab
  • Customizing the cross-tab format
  • Changing background colors
  • Formatting individual cells
  • Changing the summary operation
  • Suppressing rows, columns or totals
  • Repeating row heading for multi-page cross-tabs
  • Using alias names for column and row headings
  • Charting cross-tabs
  • Customizing cross-tab group names
  • Using the CurrentFieldValue function
Report Alerts
  • What are Report Alerts
  • Creating report alets
  • Basing report formulas or conditional formatting on report alerts
  • Creative usage for report alerts

Crystal Reports 2013

Level 2

2 Days

List Price: $850

Date Time Classroom or Online Select Session
12/20/2018 8:30 AM Classroom Add To Cart Add To Cart
12/20/2018 8:30 AM Online Add To Cart Add To Cart

Crystal Reports 2013

Level 3

This two-day workshop is designed to expand your working knowledge of Crystal Reports and move you into creating substantially more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice.

In addition, you will cover custom functions, advanced formulas and report efficiencies techniques.

2 Days

List Price: $850


Register!

Topic 1: Advanced Database Topics and Formulas

Advanced Database Concepts

  • What is SQL
  • Native Database Driver
  • ODBC
  • OLE DB
  • ODBC, OLE DB or Native
  • Using the Database Expert for linking
  • Adding a table multiple times
  • Changing Join Types
  • Database changes
  • Database verification
  • Set Data Source Location
  • Re-mapping database fields
  • Views
  • Stored procedures
  • SQL commands
  • Creating a SQL Command
Using the Advanced Formula Features
  • Select Case Statement
  • For Loop Control Structure
  • While...Do Loops
  • Do...Whtie Loops
  • Building arrays
  • The Split Function
  • Array sizing limitations
Custom Functions
  • What is a custom function
  • Function arguments
  • When to use a custom function
  • Using the custom function editor
  • Using Crystal Syntax
  • Custom function properties
  • Using the Formula Expert and custom functions
  • Using the Formula Extractor
  • Custom function limitations
Running Reports Efficiently
  • Understanding what Crystal sends to the database
  • Strategies for efficient report performance
  • Using the SQL statement 
  • Record selection and performance
  • Performance information
  • Report definition
  • Saved data
  • Procesing
  • Latest report changes
  • Performance timing
  • Server based grouping
  • Select distinct command
Topic 2: Tips, Tricks and Special Features
Advanced Cross-Tab Design
  • Dissecting a cross-tab grid
  • Cross-tab parts listing
  • Row and column indexes
  • Summary indexes
  • Grid value functions
  • Embedded summaries
  • Conditionally formatting embedded summaries
  • Calculated members
Tips and Tricks
  • Manual cross-tabs
  • Formatting subreports
  • Parameter tricks
  • Using unique fonts in the report

Crystal Reports 2013

Level 3

2 Days

List Price: $850

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

Crystal Reports 2016

Level 1

This two day interactive workshop was designed for new users of Crystal Reports 2008. Some of the topics covered include a review of the software features, report design and the creation of presentation quality reports.

2 Days

List Price: $850


Register!

Creating a Report

• Starting the Crystal Reports Program

• Starting a New Report

• Choosing a Data Source

• The Main Components of the Design Window

• Exploring the Toolbars

• Managing Resources with Explorers

• Placing Fields on the Report

• Selecting and Sizing Objects

• Browsing Field Data

• Moving and Aligning Objects

• Using Guides and Guidelines to Move and Align Objects

• Creating Text Objects

• Saving the Report

• Auto-saving the Report

• Previewing the Report

• Refreshing the Data

• Using the Status Bar

• Getting Help

• Challenge Exercise - Creating a Basic Report 

Formatting Features

• Quick Formatting with the Template Expert

• Using the Format Painter

• Formatting Objects

• Inserting Lines and Boxes

• Inserting Graphics

• Working with the Page Commands

• Changing Page Orientation

• Changing Margins

• Working with Text Objects

• Adding Fields into a Text Object

• Formatting Part or All of an Object

• Inserting Special Fields

• Challenge Exercise – Formatting Features 

Database Filters

• Filtering Data with the Select Expert

• Selecting Records with Multiple Criteria

• Viewing and Editing the Select Formula

• Case Sensitive vs. Case Insensitive

• Record Selection Formula Templates

• Challenge Exercise - Selecting Specific Records

• Challenge Exercise - Selecting a Range of Values 

Report Grouping

• When and Why to Group Records

• Creating a Group

• Group and Sort Direction

• Customize Group Name Field

• Modifying Groups

• Creating Multiple Groups in a Report

• Using the Group

Tree to Navigate the Report

• Reordering Groups

• Using the Sort Control

• Summarizing Groups

• Additional Summary Options

• Grouping Data in Date/Time Intervals

• Calculating Percentages

• Ordering Groups Based on Their Subtotals Using the Group Sort Expert

• Challenge

Exercise - Grouping, Sorting, Summarizing


Crystal Reports 2016

Level 1

2 Days

List Price: $850

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

Crystal Reports 2016

Level 2

This two-day workshop is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover professional design, techniques, sub reporting and advanced formulas. This course incorporates a number of hands on exercises that reinforce the learning process.

2 Days

List Price: $850


Register!

Refresher Exercise

• Review of Planning a Report

• Creating the Report

• Placing Fields on the Report

• Creating the Formulas

• Advanced Grouping

• Selecting Certain Records

• Helpful Hints for Formatting the Report

• Adding and Working with Text Objects

• Hiding and Suppressing Sections

• Guidelines

Power Formatting with Multiple Sections

• Using Multiple Sections in Reports

• Using the Section Expert to Work with Sections

• Conditionally Formatting Multiple Sections

• Challenge Exercise - Formatting with Multiple Sections

• Challenge Exercise - Conditionally Formatting Using DrillDownGroupLevel

Using the Running Totals Feature

• Understanding Running Totals

• Creating Running Totals for a List of Numbers

• Conditional Running Totals

• Challenge Exercise - Creating a Conditional Running Total 

Prompting with Parameters

• Parameter Field Considerations

• Creating a Parameter Field

• Using a Parameter to Select Records

• Using a Parameter Field

• Using the Parameter Panel

• Creating a Dynamic Value List for Parameter Values

• Importing a Pick List

• Adding Parameter Values to Text Objects

• Allowing Multiple Values in Parameters

• Using Multiple Parameter Fields in Reports

• Specifying and Limiting a Range

• Using Parameters in Conditional Formatting

• Using an Edit Mask to Limit String Parameters

• Sorting with a Parameter

• Using a parameter to set N in a Top N Report

• Cascading Parameters

• Challenge Exercise - Using and Displaying Parameters

Using Advanced Formula Features

• Understanding How Crystal Reports Processes the Data

• What Is a Pass?

• Using Evaluation Time Functions

• Working with Variables

• Declaring a Variable

• Assigning a Value to a Variable

• Using a Variable in a Formula

• Variable Scope

• Separating Statements in Complex Formulas

• Working with Arrays

• Understanding the Evaluation Time Debugger

• Challenge Exercise - Understand and Set Up the YTD Comparison Report

Using Sub reporting as a Workaround Solution

• Understanding Sub reports

• Unlinked versus Linked Subreports

• Creating an Unlinked Sub report

• Linking a Subreport

• Database Links versus Subreports in One-toMany Situations

• Formatting the Subreport

• Passing Data from the Main Report into a Subreport

• Creating On-Demand Subreports

• Creating Hyperlinks

• Using Subreports to Link "Unlinkable" Data

• Challenge Exercise - Creating Reports with Linked Subreports Creating Powerful Groups

• Creating Custom Groups

• Customizing Group Sort Order

• Using Group Selection to Filter the Records in the Report

• Grouping on a Formula Field

• Grouping Hierarchically

• Challenge Exercise – Create Customized Grouping

• Challenge Exercise - Using Group Selection

• Challenge Exercise - Creating a Group Using a Formula 

Working with Cross-Tab Reports

• Understanding How Cross-Tabs Affect Your Data

• Creating a Cross-Tab Report

• Creating a CrossTab with Multiple Rows or Columns

• Applying a Formatting Style to the Cross-Tab

• Customizing the Cross-Tab Format

• Changing Background Colors

• Formatting Individual Cells

• Changing the Summary Operation

• Suppressing Rows, Columns or Totals

• Repeating Row Heading for MultiPage Cross-Tabs

• Using Alias Names for Column and Row Headings

• Charting Cross-Tabs

• Customizing CrossTab Group Names

• Using the CurrentFieldValue Function

• Challenge Exercise - Cross-Tab Reports


Crystal Reports 2016

Level 2

2 Days

List Price: $850

Date Time Classroom or Online Select Session
12/27/2018 8:30 AM Classroom Add To Cart Add To Cart
12/27/2018 8:30 AM Online Add To Cart Add To Cart

Crystal Reports 2016

Level 3

This two-day workshop is designed to expand your working knowledge of Crystal Reports and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover custom functions, advanced formulas and report efficiencies techniques. This course incorporates a number of hands on exercises that reinforce the learning process.

2 Days

List Price: $850


Register!

Refresher Exercise

• Review of Planning a Report

• Creating the Report

• Placing Fields on the Report

• Advanced Grouping

• Selecting Certain Record

Group Sorting

• Group Charting

Advanced Database Concepts

• What is SQL?

• Native Database Driver

• ODBC

• OLE DB

• ODBC, OLE DB or Native

• Using the Database Expert for Linking

• Adding a table Multiple Times

• Changing Join Types

• Database Changes

• Database Verification

• Set Data Source Location

• Re-mapping Database Fields

• Views

• Stored Procedures

• SQL Commands

• Creating an SQL Command

Using the Advanced Formula Features

• Select Case Statement

• For Loop Control Structure

• While… Do Loops

• Do… While Loops

• Building Arrays

• The Split Function

• Array Sizing Limitations

Custom Functions

• What is a Custom Function

• Function Arguments

• When to use a Custom Function

• Using the Custom Function Editor

• Using Crystal Syntax

• Using Basic Syntax

• Custom Function Properties

• Using the Formula Expert and Custom Functions

• Using the Formula Extractor

• Custom Function Limitations 

 Running Reports Efficiently

• Understanding What Crystal Sends to the Database

• Strategies for Efficient Report Performance

• Using the SQL Statement

• Record Selection and Performance

• Performance Information

• Report Definition

• Saved Data

• Processing

• Latest Report Changes

• Performance Timing

• Server Based Grouping

• Select Distinct Command

Advanced Cross-Tab Design

• Dissecting a Cross-Tab Grid

• Cross-Tab Parts Listing

• Row and Column Indexes

• Summary Indexes

• Grid Value Functions

• Embedded Summaries

• Conditionally Formatting Embedded Summaries

• Calculated Members Tips and Tricks

• Manual Cross-Tabs

• Formatting Subreports

• Parameter Tricks

• Using Unique Fonts in the Report


Crystal Reports 2016

Level 3

2 Days

List Price: $850

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

Crystal Reports XI

Level 1

This two day interactive workshop was designed for new users of Crystal Reports XI. Some of the topics covered include a review of the software features, report design and the creation of presentation quality reports. The course incorporates a number of hands on exercises to reinforce the learning process. 

Crystal Reports

2 Days

List Price: $850


Register!

Topic 1: Before You Begin

  • Defining the Purpose of the Report
  • Determining the Layout of the Report
  • Finding the Data
  • Organizing the Data for the Report

Topic 2: Creating a Report

  • Starting the CrystalReports Program
  • Starting a New Report
  • Choosing a Data Source
  • The Main Components of the Design Window
  • Exploring the Toolbars
  • Managing Resources with Explorers
  • Placing Fields on the Report
  • Selecting and Sizing Objects
  • Browsing Field Data Moving and Aligning Objects
  • Using Guides and Guidelines to Move and Align Objects
  • Creating Text Objects
  • Saving the Report
  • Auto-saving the Report
  • Previewing the Report
  • Refreshing the Data
  • Getting Help
  • Challenge Exercise - Creating a Basic Report

Topic 3: Formatting Features

  • Quick Formatting with the Template Expert
  • Using the Format Painter
  • Formatting Objects
  • Inserting Lines and Boxes
  • Drawing a Line
  • Drawing a Box
  • Inserting Graphics
  • Working with the Page Commands
  • Changing Page Orientation
  • Changing Margins
  • Working with Text Objects
  • Adding Fields into a Text Object
  • Formatting Part or All of an Object
  • Inserting Special Fields 

Topic 4: Database Filters

  • Filtering Data with the Select Expert
  • Selecting Records with Multiple Criteria
  • Viewing and Editing the Select Formula
  • Case Sensitive vs. Case Insensitive
  • Record Selection Formula Templates
  • Challenge Exercise - Selecting Specific Records
  • Challenge Exercise - Selecting a Range of Values

Topic 5: Report Grouping

  • When and Why to Group Records
  • Creating a Group
  • Group and Sort Direction
  • Customize Group Name Field
  • Modifying Groups
  • Creating Multiple Groups in a Report
  • Using the Group Tree to Navigate the Report
  • Reordering Groups
  • Summarizing Groups
  • Additional Summary Options
  • Grouping Data in Date/Time Intervals
  • Calculating Percentages
  • Ordering Groups Based on Their Subtotals Using the Group Sort Expert
  • Challenge Exercise - Grouping, Sorting, Summarizing
  • Challenge Exercise - Calculating Percentages

Topic 6: Multiple Table Joins

  • Understanding Tables, Records, and Fields
  • Learning About Linking
  • Adding Multiple Tables to a Report
  • Challenge Exercise - Using the Database Expert to Link Tables

Topic 7: Creating Formulas

  • Understanding Crystal Formula Syntax without Being a Programmer
  • About the Formula Workshop
  • Using the Formula Workshop
  • Using the Formula Editor
  • The Formula Editor Toolbar
  • Performing Simple Number Calculations
  • Manipulating Dates with Formulas
  • Creating Boolean (True/False) Formulas
  • Creating String Formulas
  • Using Bookmarks to Navigate Through Formulas
  • Challenge Exercise - Creating String Formulas Challenge
  • Exercise - Doing Calculations
  • Challenge Exercise - Subtracting Dates
  • Challenge Exercise - Using Nested If Statements 

Topic 8: Conditional Formatting

  • The Highlighting Expert
  • Setting Highlighting Priorities
  • Formatting Sections
  • Formatting Sections
  • Conditionally
  • Conditionally
  • Formatting Fields
  • Challenge Exercise - Section Formatting and Conditional Formatting

Topic 9: Summary Reports and Charts

  • Creating a Summary Report
  • Applying the Drill Down Feature
  • Applying the DrillDownGroupLevel
  • Producing Charts
  • Editing Charts
  • Formatting Charts
  • Using the General Chart Options
  • Modifying Individual Objects in the Chart
  • Using Auto-Arrange Chart
  • Applying Chart Templates
  • Challenge Exercise - Creating a Summary Report
  • Challenge Exercise - Charting

Topic 10: Exporting Reports

  • Understanding Export Formats and Destinations
  • Using an HTML Format for Crystal Reports
  • Exporting to Windows Applications
  • Exporting to a Report
  • Definition Format

Topic 11: Default Options

  • Setting the Default Layout for Design and Preview Views

Topic 12: Report Wizards

  • What are the Report Wizards?
  • Create a Report Using the Standard Report Creation Wizard
  • The Data Dialog Box
  • The Fields Dialog Box
  • The Grouping Dialog Box
  • The Summaries Dialog Box
  • The Group Sorting Dialog Box
  • The Chart Dialog Box
  • The Record Selection Dialog Box
  • The Template Dialog Box
  • Challenge Exercise - Create a Report Using a Report Wizard


Crystal Reports XI

Level 1

2 Days

List Price: $850

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

Crystal Reports XI

Level 2

Turn information from almost any data source into a sophisticated, interactive report – with our market-leading report design software, SAP Crystal Reports. This powerful, user friendly application can help you deliver key insights for smarter operational and strategic decision making.

Crystal Reports

2 Days

List Price: $850


Register!

Topic 1: Refresher Exercise

  • Review of Planning a Report
  • Creating the Report
  • Placing Fields on the Report
  • Creating the Formulas
  • Advanced Grouping
  • Selecting Certain Records
  • Helpful Hints for Formatting the Report
  • Adding and Working with Text Objects
  • Hiding and Suppressing Sections
  • Guidelines

Topic 2: Power Formatting with Multiple Sections

 
  • Using Multiple Sections in Reports
  • Using the Section Expert to Work with Sections
  • Conditionally Formatting Multiple Sections
  • Challenge Exercise - Formatting with Multiple Sections
  • Challenge Exercise - Conditionally Formatting Using DrillDownGroupLevel

Topic 3: Using the Running Totals Feature

  • Understanding Running Totals
  • Creating Running Totals for a List of Numbers
  • Conditional Running Totals
  • Challenge Exercise - Creating a Conditional Running Total

Topic 4: Prompting with Parameters

  • Parameter Field Considerations
  • Creating a Parameter Field
  • Using a Parameter to Select Records
  • Using a Parameter Field
  • Using the Parameter Panel
  • Creating a Dynamic Value List for Parameter Values
  • Importing a Pick List
  • Adding Parameter Values to Text Objects
  • Allowing Multiple Values in Parameters
  • Changing the Summary Operation
  • Suppressing Rows, Columns or Totals
  • Repeating Row Heading for Multi-Page Cross-Tabs
  • Using Alias Names for Column and Row Headings
  • Charting Cross-Tabs
  • Customizing Cross-Tab Group Names
  • Using the CurrentFieldValue Function
  • Challenge Exercise - Cross-Tab Reports

Topic 5: Report Alerts

  • What are Report Alerts
  • Creating Report Alerts
  • Basing Report Formulas or Conditional Formatting on Report Alerts
  • Creative Usage for Report Alerts
  • Challenge Exercise - Using Report Alerts with Parameter

Crystal Reports XI

Level 2

2 Days

List Price: $850

No sessions are scheduled at this time.
Contact us to schedule a session for your organization.

back to top

Customize Sessions

Need a customized session?


Did you know that all of our sessions can be customized?
Let us help create a private session your team will love!

Selected Sessions

No Sessions Selected

Add a session to begin registration.
  • Personalize This Session

    All of our sessions can be customized to meet your team's specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team's valuable time!

    Let us help customize your next:

    Lunch-n-Learn

    30-90 Minute Webinar

    Half or Full Day Training

    On-Demand Learning

    Team Learning Paths



    Contact us today!



Contact

ETI Performance Improvement
8500 Keystone Crossing Suite 550
Indianapolis, Indiana 46240

p. 317.475.6555
e. [email protected]

Hours:
8:00 am - 5:00 pm M-F EST

Educate. Equip. Empower.
ETI Performance Improvement

© 2018 ETI Performance Improvement        Illustrations ©2012 Nathaniel Charles