Crystal Reports XI - Level 1

Skills covered:

Overview

In this course, students will build basic list and group reports that work with almost any database.

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.

Audience

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.

Syllabus

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

Training provider

Teaching mode:
Online - Self paced
Classroom - Instructor Led
Online - Instructor Led
Duration: 2 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Crystal Reports
Worldwide
This skill has an average salary of
US$73,589
and is mentioned in
0.12%
of job ads.
Database
Worldwide
This skill has an average salary of
US$75,146
and is mentioned in
10.37%
of job ads.