Crystal Reports 10 - Level 1

Objective:
Learn to build basic list and group reports to obtain information from a database.

Prerequisite Skills:

• Comfortable with the Windows environment.

• Basic understanding of database concepts.

Course Description:
Do you need to create reports using data from an existing database? Do you want to enhance your reports with various formatting attributes? Do you need to distribute report data to other users?

Attend this course if you want to:

• Create a report
• Display specific report data
• Group report data
• Build formulas
• Format a report
• Create a watermark in a report
• Insert objects using Object Linking and Embedding (OLE)
• Conditionally suppress data
• Insert hyperlinks
• Hide blank report sections
• Create and modify pie charts
• Export data to a PDF file, Excel workbook, or Access database
• Create a report definition
• Create mailing labels

Class Length: 2 days

Delivery Formats: On-site instructor-led

Crystal Reports 10 - Level 2

Objective:
Learn to create more complex reports that include features such as subreports, cross-tabs, advanced formulas, and charts based on more than one data series.

Prerequisite Skills:

• Comfortable using Crystal Reports to create basic reports.

• Basic knowledge of programming and SQL is helpful but not required.

Course Description:
Are you familiar with the basics of building and modifying reports? Are you ready to create more sophisticated reports that include subreports, cross-tabs, and advanced formulas? Do you want to increase the speed and efficiency of your reports by using SQL queries and dictionaries?

Attend this course if you want to:

• Create running totals
• Build cross-tabs in your report
• Add subreports
• Create drill-downs
• Improve report processing speed using SQL
• Chart data
• Report on Excel data

Class Length: 2 days

Delivery Formats: On-site instructor-led

Crystal Reports 9.0 - Level 1

Objective:
Learn to build basic list and group reports to obtain information from a database.

Prerequisite Skills:

• Comfortable with the Windows environment.

• Basic understanding of database concepts.

Course Description:
Do you need to create reports using data from an existing database? Do you want to enhance your reports with various formatting attributes? Do you need to distribute report data to other users?

Attend this course if you want to:

• Create a list report
• Display data in a report
• Group report data
• Build formulas
• Format a report
• Create a watermark in a report
• Insert hyperlinks
• Create and modify pie charts
• Export data to Excel or to an Access database
• Create a report definition
• Create mailing labels

Class Length: 2 days

Delivery Formats: On-site instructor-led

Crystal Reports 9.0 - Level 2

Objective:
Learn to create more complex reports that include features such as subreports, cross-tabs, advanced formulas, and charts based on more than one data series.

Prerequisite Skills:

• Comfortable using Crystal Reports to create basic list and group reports.

• Basic knowledge of programming and SQL is helpful but not required.

Course Description:
Are you familiar with the basics of building and modifying reports? Are you ready to create more sophisticated reports that include subreports, cross-tabs, and advanced formulas? Do you want to increase the speed and efficiency of your reports by using SQL queries and dictionaries?

Attend this course if you want to:

• Create running totals
• Build cross-tabs in your report
• Add subreports
• Improve report processing speed
• Build dictionaries
• Chart data
• Report on Excel data

Class Length: 2 days

Delivery Formats: On-site instructor-led

Crystal Reports 8.5 - Basic Skills

Objective:
Learn the basics of using Crystal Reports' report-writing features.

Prerequisite Skills:

• Comfortable with the Windows environment.

Course Description:
Do you need to create reports using data from an existing database? Do you want to enhance your reports with various formatting attributes? Do you need to distribute report data to other users?

Attend this course if you want to:

• Create a basic report
• Sort and select report data
• Group and summarize data
• Use the Report Expert to create and edit a report
• Use cross-tab reports
• Understand link options, and use the Visual Linking Expert
• Create formulas
• Format report sections
• Distribute data to other file formats

Class Length: 2 days

Delivery Formats: On-site instructor-led

Crystal Reports 8.5 - Advanced

Objective:
Learn to use more advanced features of Crystal Reports, including advanced formulas, parameter fields, and conditional format statements.

Prerequisite Skills:

• Comfortable using Crystal Reports to create basic reports.

• Basic knowledge of relational database concepts, as well as some knowledge of SQL, is helpful but not required.

Course Description:
Are you familiar with the basics of building and modifying reports? Are you ready to create more sophisticated reports that include advanced formulas and formatting? Do you need to access information that is not PC-based? Do you need to set up reports that other users will access and run?

Attend this course if you want to:

• Create formulas with multiple statement and use variables
• Understand and control the calculation process used to compile data
• Control the report appearance using conditional format statements and multiple sections
• Create parameter formulas that allow users to determine what information they want the report to display
• Use report alerts to notify you of data changes
• Use advanced cross-tabs
• Use subreports to extend your reporting capacity
• Access data from SQL/ODBC data sources
• Generate queries using Crystal SQL Designer
• Create dictionary files to make the reporting process easier for users
• Use the Chart Expert to create graphical representations of your data

Class Length: 2 days

Delivery Formats: On-site instructor-led