Crystal Reports V11 Advanced

Course Objectives

Now that you have completed the first course, or are familiar with the basics of building and modifying reports, you’re ready to move ahead to create complex reports and data sources using Crystal Reports’ tools. In this course, you’ll not only learn how to create more sophisticated reports including subreports and cross-tabs, but you’ll also learn how to increase the speed and efficiency of your reports by using SQL queries.

Please note: Crystal Reports has had multiple software versions released over the years. Please check that the version you are using matches to the course you will be attending: v10 and v11 were both released in 2003, thereafter versions 2008, 2011 and 2013 were released in the same year as their name.

Prerequisites

Create a basic report
Create a connection to a data source
Make simple modifications to an existing report
Use basic formatting techniques
Create Groups in a Report
Create Sub-Totals & Grand Totals in a Report
Create basic formulas
Perform simple filters & sorts

Delegates will learn how to

At the end of this course you will be able to:

Create running totals in a report
Build cross-tabs in your report
Add subreports to a report
Design a report that uses a drill-down
Improve processing speed in your reports
Chart single and multiple data series
Report from Excel data
Implement report prompts
Enhance report functionality

Course Outline

Lesson 1: Creating Running Totals

Topic 1A: Create a Running Total Field
Topic 1B: Modify a Running Total Field
Topic 1C: Create a Manual Running Total on Detail Data
Topic 1D: Create a Manual Running Total on Summary Data

Lesson 2: Building Cross-tabs in Your Report

Topic 2A: Create a Cross-tab
Topic 2B: Create a Specified Group Order
Topic 2C: Filter a Cross-tab by Group
Topic 2D: Change the Cross-tab Format
Topic 2E: Conditionally Format Rows and Columns
Topic 2F: Keep Groups Together

Lesson 3: Adding Subreports

Topic 3A: Insert a Subreport
Topic 3B: Link a Subreport to a Primary Report
Topic 3C: Edit a Subreport’s Structure
Topic 3D: Format a Subreport Using the Format Editor
Topic 3E: Share Variables Between Subreports and Primary Reports
Topic 3F: Create an On-demand Subreport

Lesson 4: Creating Drill-downs

Topic 4A: Create a Drill-down
Topic 4B: Create Separate Headings for Drill-down Data

Lesson 5: Enhancing Report Processing by Writing SQL Statements

Topic 5A: Create a Report Using SQL Queries
Topic 5B: Summarise Report Data Using SQL Aggregate Functions
Topic 5C: Create Joins Using SQL
Topic 5D: Create Subqueries
Topic 5E: Create a SQL Expression Field

Lesson 6: Charting Data

Topic 6A: Create a Bar Chart
Topic 6B: Modify a Chart
Topic 6C: Format a Chart
Topic 6D: Create a Chart Template
Topic 6E: Create a Top N Chart
Topic 6F: Create a Cross-tab Chart

Lesson 7: Reporting on Excel Data with Crystal Reports

Topic 7A: Create a Report Based on Excel Data
Topic 7B: Modify a Report Generated from Excel Data
Topic 7C: Update Data in a Report Based on Excel Data

Lesson 8: Working with Prompts

Topic 8A: Create a Static Prompt
Topic 8B: Create a Dynamic Prompt

Lesson 9: Enhancing Report Functionality

Topic 9A: Group Data Hierarchically
Topic 9B: Create a Dynamic Image
Topic 9C: Create a Report Alert
Topic 9D: Create a Geographic Map