Crystal Reports 7.0/7.0.1 - Advanced

Code:

 ZD78-401

Series:

 Computer Professional

Duration:

 2 days
Review Exercises
Create a basic report
Add and link databases
Select, group and summarize
Create formulas
Format sections for Summary/Drill-Down

Advanced Formulas
Use variables in formulas
Create running totals
Understand two pass reporting
Use evaluation time functions
Create formulas using multiple variables

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

Multiple Sections
Insert and delete sections
Move sections
Split sections
Work with multiple sections and conditional formats

Parameter Fields
Define parameter fields
Create parameter fields
Create a pick list parameter field
Use parameter fields in the record selection formula
Edit parameter fields for edit masks
Use the Like statement

 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
Create simulated cross-tabs

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
Using 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

 
Crystal Reports 7.0/7.0.1 - Advanced

Course specifications
Course number: 078 401
Course length: 2 days

Course description

Overview:
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.

Prerequisites:
To ensure your success, we recommend that you first take one of the following Ziff-Davis Education
courses or have equivalent knowledge:
•Crystal Reports 7.0 Basic Skills

Delivery method:
Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits:
Students will learn how to generate reports which their users can customize and enhance analysis capabilities.

Target student:
This course is designed for users with a basic knowledge of Crystal Reports but who require the use of advanced formulas and formatting, need to access information that is not PC-based, or need to set up reports that other users will access and run. Although no database experience is necessary, some of the concepts may be more meaningful if the user has worked with database applications before. A basic knowledge of relational data concepts is also recommended.

Crystal Reports 7.0/7.0.1 - Advanced

Performance-based objectives
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  • Create formulas with multiple statements and use variables.
  • Understand and control the calculation process used to compile your data.
  • Control the appearance of your report using conditional format statements and multiple sections.
  • Create parameter formulas that allow your users to determine what information they want to see on a report.
  • Enhance the analysis capability of your cross-tabs.
  • Extend your reporting capacity by utilizing sub-reports.
  • Create subtotals, grand totals and summaries for your report data.
  • Access data from SQL/ODBC data sources, and generate queries using Crystal SQL Designer.
  • Create and modify dictionary files to simplify the reporting process for your users.
  • Create and edit graphical representations of your data using the Chart Expert
  • Modify existing graphs with the Chart Analyzer.