Crystal Reports

Creating A Report

• Crystal Reports Window
• Field Types
• Specify Fields For a New Report
• Previewing the Report
• Modifying Field Display
• Positioning Fields
• Adding Fields From Additional Tables

Finding, Sorting and Filtering Data

• Finding Data in an Existing Report
• Sorting Data
• Filtering Data

Grouping Report Data

• Inserting a Group by
• Adding Group Summaries
• Formatting Summary Data
• Changing an Existing Group
• Adding a Second Group
• Filtering Groups
• Creating a Top N Sort

Using Formulas

• Creating Formulas
• Editing an Existing Formula
• Combining Fields by Formula
• Filtering Data Using Multiple Criteria
• Modifying a Filter To Include an OR Operator
• Creating a Parameter Field
• Using a Formula To Account for Null Values

Formatting Reports

• Removing White Spaces
• Page Headers and Footers
• Adding Borders, Boxes and Lines
• Changing the Field Background Colour
• Altering the Margins

Enhancing Reports

• Adding Watermarks
• Object Linking and Embedding
• Using the Highlight Expert
• Suppressing Report Sections
• Inserting Hyperlinks
• Hiding Blank Sections

Creating Pie Charts

• Create a Pie Chart Drill-down
• Modifying Chart text
• Formatting a Chart
• Charting by Group

Exporting Data

• Exporting To PDF
• Exporting To Excel
• Exporting To Access
• Exporting a Report Definition
• Creating Labels

Creating A Running Total

• Creating a Running Total Field
• Modifying a Running Total
• Suppressing the Running Total
• Resetting the Running Total

Creating Cross-Tab Reports

• Planning a Cross-tab Report
• Creating a Cross-tab Report
• Creating a Specified Group Order
• Filtering a Cross-tab by Group
• Changing The Cross-tab Format
• Conditionally Formatting Rows and Columns
• Keeping Groups Together

Adding Subreports

• Inserting a Subreport
• Linking a Subreport to a Primary Report
• Editing a Subreport
• Formatting a Subreport Object
• Creating an On-demand Subreport

Creating Drill-downs

• Creating Drill-downs
• Creating Separate Headings for Drill-down Data

Creating Prompts

• Creating a Static Prompt with Dates
• Creating a Dynamic Prompt

Writing Basic SQL Statements

• Creating a Report Using SQL Queries
• Summarising Reports Using SQL Aggregate Functions
• Creating Joins Using SQL
• Specifying the Join Type

Advanced Charting

• Creating a Bar Chart
• Modifying a Chart
• Formatting a Chart
• Creating a Chart Template
• Creating a Top N Chart

Before attending this course, students must have:

• Knowledge of programming and/or SQL.

There is no formal assessment for this course.

The following will be included in this Crystal Reports training course:

• Crystal Reports Courseware
• Course Equipment (if required)
• Experienced Instructor
• Certificate
• Refreshments