Crystal Reports 11 Boot Camp

"This was a great opportunity for those in the IT field that need to get certifications for career advancement."

-Richard Barriault, Martinez, GA

Custom Training Quote

• Jun 10 - Jun 13, 2013

• Includes roundtrip airfare and lodging
  
  (Atlanta and Fort Lauderdale boot camps only)
• Hands-on instruction by a certified instructor
• Includes all course materials
• Breakfast and Lunch provided each day

Can't travel or you want to stay with your family or business. No problem! Stay in your own city and save the additional expenses of roundtrip airfare, lodging, transportation, and meals and receive the same great instruction live from our instructors in our Live Instructor-Led Remote Classroom Training.

Remote Classroom Training

Our Remote Classroom Training is a live class with students observing the instructor and listening through your computer speakers. You will see the instructor's computer, slides, notes, etc., just like in the classroom. You will be following along, doing work, labs, and individual assignments.

Crystal Enterprise is a common architecture for data access, reporting, and information delivery that allows you to respond quickly to any reporting or application development need. Crystal Enterprise is designed to integrate seamlessly with your existing data, web, and application investments without imposing a new set of standards and processes.

• Crystal Reports 11.0 - Introduction
• Crystal Reports 11.0 - Advanced

Crystal Reports 11.0 - Introduction

Crystal Reports XI: 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 XI series. In this course, 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. Students may or may not have programming and/or SQL experience.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• create a report by using data from an existing database.
• use a report to present specific data in the desired order.
• create groups to summarize report data.
• build formulas to calculate and display data.
• format reports.
• add and modify elements in a report.
• create single data series charts.
• distribute report data.

Course Content

Creating a Report

• Set Default Report Settings
• Specify Fields for a New Report
• Preview a Report
• Modify Field Display
• Add a Report Title
• Position Fields
• Add Fields from Other Tables

Displaying Specific Report Data

• Find Data
• Sort Data
• Filter Data by a Single Criterion

Grouping Report Data

• Insert a Group
• Add Summaries
• Format Summary Information
• Change Group Options
• Add a Second-Level Grouping
• Filter Records by Group
• Create a Top N Sort Group

Building Formulas

• Create a Formula
• Edit a Formula
• Combine Fields by Formula
• Delete a Formula
• Filter Data by Multiple Criteria
• Modify a Filter Using an OR Operator
• Create a Parameter Field
• Account for Null Fields in a Formula

Formatting Reports

• Remove White Space
• Insert Page Header/Footer Data
• Add Borders, Boxes, and Lines
• Change Field Background Color
• Change the Margins

Enhancing Reports

• Add a Watermark
• Insert Objects Using Object Linking and Embedding
• Modify Formatting Based on Data Value
• Suppress Report Sections
• Insert Hyperlinks
• Hide Blank Report Sections

Creating Pie Charts

• Create a Pie Chart with a Drill-Down
• Modify Chart Text
• Format a Chart
• Present a Chart by Group

Distributing Data

• Export to a PDF File
• Export to a Microsoft Excel File
• Export to an Access Database File
• Export a Report Definition
• Create Mailing Labels

[ back to top ]

Crystal Reports 11.0 - Advanced

You will create complex reports using Crystal Reports' tools.

Target Student: This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools to make it easier for other people to create reports.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• create running totals in a report.
• build cross-tabs in your report.
• add subreports to a report.
• design a report that uses a drill-down.
• improve processing speed in your reports.
• chart single and multiple data series.
• report from Excel data.
• implement report prompts.
• enhance report functionality.

Course Content

Creating Running Totals

• Create a Running Total Field
• Modify a Running Total Field
• Create a Manual Running Total on Detail Data
• Create a Manual Running Total on Summary Data

Building Cross-tabs in Your Report

• Create a Cross-tab
• Create a Specified Group Order
• Filter a Cross-tab by Group
• Change the Cross-tab Format
• Conditionally Format Rows and Columns
• Keep Groups Together

Adding Subreports

• Insert a Subreport
• Link a Subreport to a Primary Report
• Edit a Subreport's Structure
• Format a Subreport Using the Format Editor
• Share Variables Between Subreports and Primary Reports
• Create an On-demand Subreport

Creating Drill-downs

• Create a Drill-down
• Create Separate Headings for Drill-down Data

Enhancing Report Processing by Writing SQL Statements

• Create a Report Using SQL Queries
• Summarize Report Data Using SQL Aggregate Functions
• Create Joins Using SQL
• Create Subqueries
• Create a SQL Expression Field

Charting Data

• Create a Bar Chart
• Modify a Chart
• Format a Chart
• Create a Chart Template
• Create a Top N Chart
• Create a Cross-tab Chart

Reporting on Excel Data with Crystal Reports

• Create a Report Based on Excel Data
• Modify a Report Generated from Excel Data
• Update Data in a Report Based on Excel Data

Working with Prompts

• Create a Static Prompt
• Create a Dynamic Prompt

Enhancing Report Functionality

• Group Data Hierarchically
• Create a Dynamic Image
• Create a Report Alert
• Create a Geographic Map

[ back to top ]

CED Solutions is your best choice for Crystal Reports XI, Crystal Reports XI training, Crystal Reports XI certification, Crystal Reports XI boot camp, Crystal Reports XI certification training, Crystal Reports XI certification course, Crystal Reports XI course, Crystal Reports XI class.