ADVANCED CRYSTAL REPORTS 2011– GTD12

Course Description

This Crystal Reports class is intended for those experienced in Crystal Reports and who want to learn more about database functionality and the more advanced features of Crystal Reports. This will be enhanced through the use of hands-on exercises throughout the course.

Please note that XI is the older version of Crystal Reports and should not be confused with 2011.

^^

Duration

2 days

^^

Target Audience

This Crystal Reports class is intended for those experienced in Crystal Reports and who want to learn more about database functionality and the more advanced features of Crystal Reports.

^^

Course Prerequisites

Experience in Solid Crystal Reports experience as taught in our introductory course below:

If you have any questions or doubts as to whether you meet the pre-requisites for this course, or indeed are wondering which course best suits you, please consult with us to discuss your suitability for course attendance.

^^

Suggested Follow on Courses

Please contact us for further details.

^^

Course Content

Crystal Reports Refresher

Creating a Crystal Report

Using Parameters

Creating Parameters

Optional Parameters

Using a List of Values

Using Parameters

Subreports

Unlinked Subreports

Linked Subreports

Charts

Adding Charts to Reports

Cross-tabulation Reports

Using Cross-tabulation Reports

Working with SQL

The SELECT Statement

The WHERE Clause

The ORDER BY Clause

Joins

SQL Commands

SQL Expressions

 

Advanced Techniques

Special Fields

Using the Select Case Statement

Evaluation Time Functions

Conditional Formatting

Alternating Row Formatting

Report Alerts

Using Report Alerts

^^

See more Database Technologies courses