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