Crystal Reports Level 1

Overview

Modifying the program default settings and using help
Reviewing reports and databases to be used in class
Think about the steps necessary to create reports
Examining the application's capabilities

Creating Simple Reports

Saving and refreshing a report
Adding drawings and images / company logos etc.
Adding special fields such as page numbers and other document information
Enhancing a report by using the format editor
Formatting a report by changing the size and position of the fields
Viewing a report as it will print
Creating a new report
Identifying the sections of a report

Sorting and Selecting Records

Modifying composite formulas and the selection criteria statement
Adding an additional selection criterion using the "And" / "Or" statement
Using the Select Expert to limit records using single or multiple criteria
Sorting records using single or multiple criteria

Grouping and Summarizing

Using Top N/Sort Group Expert
Inserting grand total summary fields
Inserting percent of the total fields
Inserting summary fields
Inserting subtotals and grand totals
Modifying grouping options
Defining a multiple level group
Defining a single level group

Parameter Fields

Creating pick lists for use with parameter fields
Creating parameter fields - to select records
Creating parameter fields - free text entry
Creating and utilising parameter fields

Using the Report Expert

Editing a report created using an expert
Creating new reports using the cross tab expert
Creating new reports using the standard report expert

Linking

Creating, examining and modifying links using the visual linking expert
Using multiple tables in a single report correctly
Understanding relational database basic concepts

Creating Formulas

Creating and using If-Then-Else formulas and functions
Creating and using arrays in formulas and functions
Creating and using date formulas and functions
Creating and using numeric formulas and functions
Creating and using string formulas and functions
Making changes to formulas
Creating new formulas using the formula editor
Understanding formula components

Formatting Sections

Creating summary and drill down reports
Using the section expert
Resizing sections in design view
Reviewing sections

Distributing / Exporting Data

Web browser options to view reports on-line
Creating a report using spreadsheet data
Exporting a report into office suite applications
Identifying exporting options