Crystal Reports 2011: Level 1
Course Specifications
Course number: 085172
Course length: 2.0 day(s)
Course Description
Course Objective: You will connect to a database to extract data and present it as a report.

Target Student: This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or such tools may not be accessible. Students may or may not have programming or SQL experience.

Prerequisites: Before taking this course, students should be familiar with the basic functions such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files in Microsoft® Windows®. In addition, students should have taken the Microsoft® Office Access 2010: Level 1 course or have equivalent experience with basic database concepts. 
Hardware Requirements
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware configuration: 
•	1 GHz Pentium®-class processor or faster.
•	A minimum of 1 GB of RAM is recommended.
•	20 GB hard disk or larger if you use Windows XP Professional as your operating system. You should have at least 1 GB of free hard disk space available for Office 2010 installation. 
•	Access to one of the following: a local CD-ROM drive, a local DVD drive, or access to a networked CD-ROM drive.
•	A keyboard and mouse or other pointing device.
•	A 1024 x 768 resolution SVGA monitor is recommended.
•	Network cards and cabling for local network access.
•	Internet access (check with your local network administrator).
•	A printer (optional) or an installed printer driver.
•	A projection system to display the instructor's computer screen.
Software Requirements
Each computer requires the following software:
•	Microsoft® Windows® XP SP2 or Vista
•	Custom installation of Crystal Reports 2011
•	Default installation of Microsoft® Office 2010
•	Printer driver (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.)
•	Adobe® Reader® 9.0 and above
Course Objectives
Upon successful completion of this course, students will be able to: 
•	identify the elements of the Crystal Reports interface.
•	create and modify a basic report.
•	use formulas to calculate and filter data.
•	build a parameterized report.
•	group report data.
•	enhance a report.
•	create a report using data from an Excel workbook.
•	distribute data.
Course Content
Lesson 1: Exploring the SAP Crystal Reports 2011 Interface

Topic 1A: Explore Crystal Reports 
Topic 1B: Use Crystal Reports Help 
Topic 1C: Customize the Report Settings 

Lesson 2: Working with Reports

Topic 2A: Create a Report 
Topic 2B: Modify a Report 
Topic 2C: Display Specific Report Data 
Topic 2D: Work with Report Sections 

Lesson 3: Using Formulas in Reports

Topic 3A: Create a Formula 
Topic 3B: Edit a Formula 
Topic 3C: Filter Data Using a Formula 
Topic 3D: Work with Advanced Formulas and Functions 
Topic 3E: Handle Null Values 

Lesson 4: Building Parameterized Reports

Topic 4A: Create a Parameter Field 
Topic 4B: Use a Range Parameter in a Report 
Topic 4C: Create a Prompt 

Lesson 5: Grouping Report Data

Topic 5A: Group Report Data 
Topic 5B: Modify a Group Report 
Topic 5C: Group Using Parameters 
Topic 5D: Create a Parameterized Top N Report 

Lesson 6: Enhancing a Report

Topic 6A: Format a Report 
Topic 6B: Insert Objects in a Report 
Topic 6C: Suppress Report Sections 
Topic 6D: Use Report Templates 

Lesson 7: Creating a Report from Excel Data

Topic 7A: Create a Report Based on Excel Data 
Topic 7B: Modify a Report Generated from Excel Data 
Topic 7C: Update Data in a Report Based on Excel Data
 
Lesson 8: Distributing Data

Topic 8A: Export Data 
Topic 8B: Create Mailing Labels 

Appendix A: Setting Up and Configuring Data Sources

Appendix B: Using Report Processing Techniques

Appendix C: Using Functions in Formulas