Crystal Reports - Advanced

Audience

This course is for all delegates wishing to learn the advanced skills of Crystal Reports. It can be delivered at all versions of Crystal Reports, including 9,10, XI and CR2008.

Prerequisites

Delegates should have attended the Crystal Reports Basic Skills course.

Duration

2 days. Hands on.

Course Objectives

On completion of the course delegates will be able to:

• Use Advanced Formulas.
• Understand Cross-tab Reports.
• Work with Parameter Fields.
• Create Subreports.
• The Crystal Repository.
• Use Crystal SQL Designer and SQL/ODBC using Crystal Query Designer.
• Create, use and change dictionaries using Crystal Dictionaries.
• Geographical Mapping.

Course Content

Review Exercise
Creating a basic report
Adding and linking databases
Selecting, grouping and summarizing
Creating formulas
Formatting sections for Summary/Drill-Down

Advanced Formulas
Use variables in formulas
Understand multiple pass reporting
Use evaluation time functions
Create formulas using multiple variables

Parameter Fields
Define parameter fields
Create parameter fields
Create a pick list parameter field
Use parameter fields in the record selection formula
Use edit masks
Use parameter fields to specify the sort criteria
Use the Like statement
Use parameter fields to set conditional formats

Cross-Tabs
Understanding cross-tab reports
Use the Cross-Tab Expert
Edit your cross-tab report
Modify cross-tab layout options
Format your cross-tab report
Insert multiple rows, columns and summarised fields
Format cross-tab components
Use formula fields in cross-tab layouts
Use parameter fields with cross-tab reports
Insert a cross-tab for each group value

Subreports
Identify when subreports are needed
Insert unlinked subreports
Format subreports
Insert linked subreports
Create on-demand subreports

SQL/ODBC and Crystal SQL Designer (version 8x only)
Defining SQL
Defining ODBC
Use Crystal Query Designer
Using a query to create a report

Crystal Dictionaries (version 8x only)
Define a dictionary
Use existing dictionaries
Create dictionaries
Enhance dictionaries
Modify a dictionary

Geographical Mapping
Discuss map types and layout options
Use the Map Expert
Format existing maps

Advanced Conditional Formatting
Advanced section formatting and suppressing
Advanced field formatting and suppressing

The Crystal Repository (versions 9 onwards)
Accessing the Crystal Repository
Adding objects to the Repository
Modifying a Repository Object
Updating Repository Objects in reports

Running Totals
Using Running Totals
Editing Running Totals
Using the Evaluate and Reset options

Advanced Grouping
Creating Top N Reports
Specified Order Grouping< All third-party brands and trademarks belong to their respective owners.