$950.00 CAD / 2 DAYS

1) Select Location for Dates in Your City:


Choose Date

  • No available dates.

Notify me Click on date to Register Now or click Notify Me to receive an email notification when course is Guaranteed to Run. once the following courses become Guaranteed to run.

No available dates.
Canada
,
Canada
,
Canada
,
Canada
,

Jump to Shopping Cart Continue shopping

CRPT11L1: Crystal Reports (2008, 2011, 2013): Level 1

 

Duration: 2 Days

Course Description

Learn how to connect to a database to extract data and present it as a report.

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.

Course Content

Getting Started

  • Explore Crystal Reports
  • Use Crystal Reports Help
  • Customize the Report Settings 

Working with Reports

  • Create a Report
  • Modify a Report
  • Display Specific Report Data
  • Work with Report Sections 

Using Formulas in Reports

  • Create a Formula
  • Edit a Formula
  • Filter Data Using a Formula
  • Work with Advanced Formulas and Functions
  • Handle Null Values

Grouping Report Data

  • Group Report Data
  • Modify a Group Report
  • Group Using Parameters
  • Create a Parameterized Top N Report 

Report Wizards

  • What are the Report Wizards?
  • Create a Report Using the Standard Report Creation Wizard
  • The Data Dialog Box
  • The Fields Dialog Box
  • The Grouping Dialog Box
  • The Summaries Dialog Box
  • The Group Sorting Dialog Box
  • The Chart Dialog Box
  • The Record Selection Dialog Box The Template Dialog Box 

Enhancing a Report

  • Format a Report
  • Insert Objects in a Report
  • Suppress Report Sections
  • Use Report Templates 

Conditional Formatting

  • Formatting Sections
  • Formatting Sections Conditionally
  • Conditionally Formatting Fields
  • Challenge Exercise – Section Formatting and Conditional Formatting
  • Summary Reports and Charts 

Creating a Summary Report

  • Applying the Drill Down Feature
  • Applying the DrillDownGroupLevel
  • Producing Charts
  • Editing Charts
  • Formatting Charts
  • Using the Chart Options
  • Modifying Individual Objects in the Chart
  • Applying Chart Templates 

Exporting Reports

  • Export Data
  • Use PDF Format for Crystal Reports