Crystal Reports Module 1 & 2 - Creating & Modifying Reports, Thales Training Consultancy

CRYSTAL REPORTS MODULE 1 & 2 - CREATING & MODIFYING REPORTS

Duration:

2 days

Price:

£500.00

Locations Available:

Basingstoke
11-12 Jun 08
27-28 Oct 08

Crawley
08-09 May 08
23-24 Sep 08

Versions:

8, 9, 10, 11

Suitable For:

Novice users who need to become proficient in creating and modifying reports. An understanding of database structure would be an advantage but is not essential.

Objectives:

By the end of the course delegates will be able to:

Select and sort database records in a report
Produce simple, grouped and summarised reports
Include calculations and conditional formatting in reports

Course Outline:

Planning a Report

Database, tables and fields
Understanding the data

Connecting to Data

Direct access or ODBC

Creating a New Report

Starting a new report
Report layout
Adding, moving and sizing fields
Adding, moving and sizing objects
Previewing and refreshing data
Saving a report

Formatting Objects

Editing and formatting text objects
Text fields, number fields and date/time fields

Record Selection

Using the select expert
Adding and editing selection criteria
Setting the report date

Sorting and Grouping

Applying a sort order
Adding and editing a group definition
Grouping on a date field

Grouping and Summarising

Summarising
Adding a subtotal and grand total
Top N / sort group

Working with Text Objects

Text rotation
Combining text and fields

Special Fields and Graphics

Adding and formatting special fields
Inserting boxes, lines and graphics

Linking Tables

Using the visual linking expert
Relationships and joins

Formulas

Creating and editing a formula
Numeric and date calculations
Using IF formulas

Conditional Reporting

Using the highlighting expert
Conditional formatting

Section Formatting

Using the section expert
Changing backgrounds