Crystal Reports Advanced

Duration: 2 days

Overview:

On Aspect Training’s Crystal Reports Advance training course, delegates will create complex reports and data sources using Crystal Reports tools. They will create more sophisticated reports including sub reports and cross-tabs, and also increase the speed and efficiency of reports by using SQL queries.

Aspect Training’s Crystal Reports Advance training course is designed for people who know how to create basic list and group reports and need to create reports that include sub reports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience.

Prerequisites:

Delegates should be familiar with the content covered in the Aspect Training’s Crystal Reports Introduction/ Intermediate training course. Knowledge of programming and/or SQL would also be helpful.

Topics:

1 - Working with Cross-Tabs

Create a Cross-Tab Report

Format a Cross-Tab Report

Create Groups in Cross-Tab Reports

2 - Adding Sub reports

Insert a Sub report

Edit a Sub report

Share Variables

3 - Creating Drill-Downs in a Report

Create a Drill-Down

Create Headings for Drill-Down Data

4 - Using SQL Statements in Report Processing

Create a Report Using SQL Queries

Summarise Report Data • Create Joins Using SQL

Create Sub queries

Create a SQL Expression Field

5 - Creating Complex Formulas

Work with Loops

Work with Arrays

6 - Adding Charts to Reports

Create Charts

Create a Chart with a Drill-Down

Create a Top N Chart

Create a Cross-Tab Chart

Create Charts for Grouped Data

Format a Chart

Create a Chart Template

7 - Enhancing Report Functionality

Organize Data Based on a Hierarchy

Create a Dynamic Image

Create a Report Alert

Create a Geographic Map