Crystal Reports Training at The Learning Center

Currently Not Logged In (Click here to login to E-Learning)

The Learning Center of Las Vegas, Nevada offers Computer Professional and Certification training and testing for Microsoft, MCSE, MCAD, MCDBA, MCSD, .Net, CISCO, A+, Network+, and many applications including Microsoft Office.


Serving Your Training Needs Since 1985
Click on the links for the course you need information for: *Crystal Reports 7.0: Basic Skills* *Crystal Reports 7.0: Advanced* *Crystal Reports 8.5 Beginning* *Crystal Reports 8.5 Advanced* If a link doesn’t contain the information you require now, please check back soon or call 702-320-8885 for more details.

Crystal Reports 7.0: Basic Skills

Course length: 2 days

Course content

Overview

What is Crystal Reports

Preview sample reports

Preview sample databases

The Crystal Report window

Using help

Creating Basic Reports

Creating a new report

Inserting database fields

Previewing a report

Selecting multiple objects

Moving and resizing objects

Inserting text objects

Formatting objects

Saving a report

Saved data vs. refresh data

Sorting, Grouping and Summarizing

Sorting records

Inserting groups

Group Name field

Changing group options

Creating specified groups

Inserting subtotals

Inserting grand totals

Inserting summary fields

Top N group expert

Record Selection

Selection records

Multiple selection criteria

Editing the record selection formula

Creating Formulas

Why use formulas

Formula components

Using the Formula Editor

Editing a formula

Renaming a formula

Deleting a formula

String functions

Date Functions

Formulas using summary fields

If-Then-Else formulas

Linking

What is linking?

Join types

Self joins

PC database links

SQL/ODBC database links

Using the visual linking expert

Using the Report Expert

Creating a report using the Report Expert

Edit report using the Report Expert

Section Formatting

Report section definitions

Using the Section Expert

Section format options

Summary/Drill-Down Reports

Basic Cross-Tabs

What is a Cross-Tab?

Using the Cross-Tab Expert

Editing a Cross-Tab layout

Additional Cross-Tab layout features

Report Distribution

Exporting a report to another format

Mailing a report

Compiling a report

Additional Formatting & File Options

Inserting special fields

Inserting fields in text objects

Moving and copying objects

Inserting lines and boxes

Inserting pictures

Changing file options

Return to the Top of the Page

Crystal Reports 7.0: Advanced

Course length: 2 days

Course content

Review

Creating reports

Formatting

Grouping

Summarizing

Selecting records

Summary Drill Down

Linking

Formulas

Cross-Tabs

Advanced Formulas

Creating multiple statement formulas

Using variables

Understanding two-pass reporting

Using evaluation time functions

Creating running totals

Adding User Functions Libraries (UFLs)

Conditional Formatting

Types of formatting

Absolute formatting

Conditional on/off formatting

Conditional attribute formatting

Using the highlighting feature

Multiple Sections

Inserting sections

Splitting Sections

Moving sections

Deleting sections

Multiple section formats (underlay following sections)

Example uses (watermark, shading

every other record, creating different header/footers, different form letters, suppress blank lines)

Parameter Fields

Creating parameter fields

Using parameter fields in record selection formula

Advanced Cross-Tabs

Multiple rows, columns and summarized fields

Formatting Cross-Tabs

Using formulas, parameter fields in cross-tabs

Simulated Cross-Tabs

Subreports

What are subreports?

Linked subreports

Unlinked subreports

On-demand subreports

SQL/ODBC Query Designer

What is the SQL/ODBC?

What is the Query Designer?

What is an ODBC data source?

SQL statement components

Creating queries

Creating Data Sources

Using Access files

Graphing

Creating a graph on summary fields

Graphing on multiple summary values

Graphing on Cross-Tabs

Editing and formatting graphs

Dictionaries

What are Dictionaries?

Using dictionaries to create reports

Creating dictionaries

Web Reporting

Crystal Web Report server installation

Introduction to Web Reporting

Viewing Crystal Reports on the Web

Return to the Top of the Page

Crystal Reports 8.5 Beginning

Length of Course:	2 days
Prerequisites:	It is recommended that you first take one of the following courses or have equivalent knowledge: Windows 95: Introduction, Windows 98: Introduction, and Windows NT 4.0 Introduction.
Course Objective:	Upon successful completion of this course, students will be able to: Plan the needs for your report including data as well as appearance. Become familiar with components of the Crystal Reports application window. Create reports based directly on database information, use a report expert or create a copy of an existing report. Add, modify and remove report objects such as data fields, text objects, file information, graphics or decorative lines and boxes. Format the appearance of your report using font, color, border and number choices. Change the selection criteria and sort order of your data. Create subtotals, grand totals and summaries for your report data. Create, edit and delete formulas. Understand Crystal’s formula language. Understand linking concepts then create and modify your own links. Identify and control Crystal’s report sections. Distribute your reports to those who need the information through a variety of methods.

Course Outline:

Overview

Examine the application’s capabilities

Think about the steps necessary to create reports

Review reports and databases to be used in class

Modify the program default settings

Use help

Creating Basic Reports

Identify the sections of the report

Create a new report

View your report as it will print

Format your report by changing the size and position of the fields

Enhance your report by adding a report title and changing the font attributes of your labels

Add page numbers and other document information as well as a company logo or other graphics in your report

Save your report

Sorting and Selecting Records

Sort records

Use the Select Expert to limit records

Add an additional selection criterion using the "And" statement

Modify composite formulas and the selection criteria statement

Grouping and Summarizing

Define a single level group

Define a multiple level group

Modify grouping options

Insert subtotals and grand totals

Insert summary fields

Insert percent of the total fields

Insert grand total summary fields

Use Top N/Sort Group Expert

Using the Report Expert

Create new reports using the Standard Report Expert

Create new reports using the Mailing Labels Report Expert

Edit a report created using an Expert

Basic Cross-Tabs

Understanding cross-tab reports

Use the Cross-Tab Expert

Edit your cross-tab report

Modify cross-tab layout options

Format your cross-tab report

Linking

Understand relational database basic concepts

Create links using the Visual Linking Expert

Examine Link Options

Look at the difference between PC and SQL links

Creating Formulas

Understand Formula Components

Create new formulas using the Formula Editor

Make changes to formulas

Create and use String formulas

Create and use Date functions

Work with summary formulas

Create and use If-Then-Else functions

Formatting Sections

Review sections

Resize sections in Design view

Use the Section Expert

Create Summary and Drill Down reports

Distributing Data

Identify exporting options

Export a report into office suite applications

Create a report using spreadsheet data

Discuss Web browser options to view reports on-line

Return to the Top of the Page

Crystal Reports 8.5 Advanced

Length of Course:	2 days
Prerequisites:	Windows 95/98/NT Beginning

Course Objective:	You will learn how to: create advanced formulas, format reports based on calculation results, use multiple sections, insert subreports, access data from sources other than PC databases, and create user libraries.

Course Outline:

Review Exercises

Creating a basic report

Adding and linking databases

Selecting, grouping and summarizing

Creating formulas

Formatting sections for Summary/Drill-Down

Conditional Formatting

Understand the difference between absolute and conditional formatting

Apply and remove conditional on/off formatting

Assign conditional attribute formatting

Use the Highlighting Expert

Remove conditional formatting

Advanced Formulas

Use variables in formulas

Create running totals

Understand multiple pass reporting

Use evaluation time functions

Create formulas using multiple variables

Multiple Sections

Planning a Web

Adding Content to a Home Page

Adding, Saving, and Deleting Pages to a Web

Using Templates to Create Web Pages

Inserting and Importing a File into a Web Page

Parameter Fields

Define parameter fields

Create parameter fields

Create a pick list parameter field

Use parameter fields in the record selection formula

Use edit masks

Use parameter fields to specify the sort criteria

Use the Like statement

Use parameter fields to set conditional formats

Advanced Cross-Tabs

Insert multiple rows, columns and summarized fields

Format cross-tab components

Use formula fields in cross-tab layouts

Use parameter fields with cross-tab reports

Insert a cross-tab for each group value

Subreports

Identify when subreports are needed

Insert unlinked subreports

Format subreports

Insert linked subreports

Create on-demand subreports

SQL/ODBC and Crystal SQL Designer

Defining SQL

Defining ODBC

Use Crystal Query Designer

Using a query to create a report

Crystal Dictionaries

Define a dictionary

Use existing dictionaries

Create dictionaries

Enhance dictionaries

Modify a dictionary

Graphing

Discuss chart types and layout options

Use the Chart Expert

Format existing graphs

Return to the Top of the Page

E-mail us now or contact us at 702-320-8885

Legal Terms and Conditions