Crystal Reports 9.0: Level 1
Course Specifications
Course number: 085513
Software: Microsoft Windows 98, Windows ME, Windows 2000, Windows NT
(version 4.0 or higher), or Windows XP.
Course length: 2.0 day(s)
Course Description
Crystal Reports 9.0 Level
1 is the primary recommended course you
should take if your job responsibilities require you to obtain output from
databases. It is also the first course in the Crystal Reports 9.0 series.
In this course, you will build basic list and group reports that work with
almost any database.
Course Objective: You will build basic list and group reports that work with almost
any database.
Target Student: This course is designed for a person who needs output from a database.
In some cases, database programs have limited reporting tools, and/or they
may not have access to those tools. They may or may not have programming and/or
SQL experience.
Prerequisites: Exposure to a Windows operating system would be helpful and a basic
understanding of database concepts is necessary.
Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Hardware Requirements
- A Pentium or higher processor.
- 60 MB of hard-disk space (full installation 235 MB).
- 32 MB of RAM (64 MB RAM recommended).
- Either a local CD-ROM drive, DVD drive, or access to a networked
CD-ROM drive.
Platform Requirements
- Microsoft Windows 98, Windows ME, Windows 2000, Windows NT (version
4.0 or higher), or Windows XP.
Software Requirements
- Microsoft Windows 98, Windows ME, Windows 2000, Windows NT
(version 4.0 or higher), or Windows XP.
- A Custom installation of Crystal Reports 9.0.
- A default installation of Access 2000 if you plan to complete
the activity, “Exporting to an Access Database.”
- A default installation of Excel 2000 if you plan to complete
the activity, “Exporting to Excel.”
- A default installation of Word 2000 if you plan to complete
the activity, “Adding Bulleted Lists.”
- A valid email address if you plan to complete the practice
activity, “Enhancing a Report.”
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- create a list report by using data from an existing database.
- locate and present data in a specified order.
- create groups to summarize report data.
- build formulas to add non-database data to a report and
display data differently.
- format reports.
- enhance reports by adding and modifying elements in a report.
- create single data series charts.
- distribute report data to other users.
Course Content
- Lesson 1: Creating a List Report
- Topic 1A: Set Default Report Settings
- Topic 1B: Build the Report
- Topic 1C: Preview the Report
- Topic 1D: Add a Report Title
- Topic 1E: Align Fields
- Lesson 2: Displaying Data in a Report
- Topic 2A: Find Data
- Topic 2B: Sort Data
- Topic 2C: Filter Data by Single Criteria
- Lesson 3: Grouping Report Data
- Topic 3A: Insert a Group
- Topic 3B: Add Summaries
- Topic 3C: Change Group Options
- Topic 3D: Add an Additional Group
- Topic 3E: Format a Group Header
- Topic 3F: Filter by Group
- Topic 3G: Create a Top N Sort Group
- Lesson 4: Building Formulas
- Topic 4A: Write a Formula
- Topic 4B: Edit a Formula
- Topic 4C: Group by Formula
- Topic 4D: Delete a Formula
- Topic 4E: Build a Filter by Multiple Criteria
- Topic 4F: Modify a Filter with Multiple Criteria to Create an
OR Condition
- Topic 4G: Create a Parameter Field
- Topic 4H: Write a Formula that Incorporates Null Fields
- Lesson 5: Formatting Reports
- Topic 5A: Remove White Space
- Topic 5B: Insert Page Header/Footer Data
- Topic 5C: Add Borders and Lines
- Topic 5D: Change the Background Color
- Topic 5E: Change the Margins
- Lesson 6: Enhancing Reports
- Topic 6A: Create a Watermark
- Topic 6B: Add Bulleted Lists
- Topic 6C: Modify Format Based on Data Value
- Topic 6D: Conditionally Suppress Data
- Topic 6E: Insert Hyperlinks
- Topic 6F: Hide Report Objects
- Lesson 7: Creating and Modifying Pie Charts
- Topic 7A: Create a Pie Chart with a Drill-down
- Topic 7B: Change the Chart Title
- Topic 7C: Format a Chart
- Topic 7D: Present a Chart by Group
- Lesson 8: Distributing Data
- Topic 8A: Export to Excel
- Topic 8B: Export to an Access Database
- Topic 8C: Create a Report Definition
- Topic 8D: Create Mailing Labels