Introduction : Crystal Reports Training:  

 

 

Synopsis:

Delegates will learn how to use Crystal Reports to build basic list and group reports that work with almost any database.

Pre-Requisites:

None – you will require a PC with a version of Crystal Reports pre-loaded for each delegate.

Course Outline:

This two-day course is designed for people who need output from a database, where their database programs have limited reporting tools, and/or they may not have access to those tools. They may or may not have programming and/or SQL experience, but must be familiar with basic database concepts, such as those covered in the Microsoft Access Introduction course.

Course Content:

Day 1 -

Reports:

  • Creating a List Report
  • Set Default Report Settings
  • Build the Report
  • Preview the Report
  • Add a Report Title
  • Align Fields

Data:

  • Displaying Data in a Report
  • Find Data
  • Sort Data
  • Filter Data by Single Criteria
  • Grouping Report Data

Groups:

  • Insert a Group
  • Add Summaries
  • Change Group Options
  • Add an Additional Group
  • Format a Group Header
  • Filter by Group
  • Create a Top N Sort Group

Formulas:

  • Building Formulas
  • Write a Formula
  • Edit a Formula
  • Group by Formula
  • Delete a Formula

Filters:

  • Build a Filter by Multiple Criteria
  • Modify a Filter with Multiple Criteria to Create an OR Condition Day 2

Day 2 -

Formatting:

  • Formatting Reports
  • Remove White Space
  • Insert Page Header/Footer Data
  • Add Borders and Lines
  • Change the Background Colour
  • Change the Margins

Enhanced Reports:

  • Enhancing Reports
  • Create a Watermark
  • Add Bulleted Lists
  • Modify Format Based on Data Value
  • Conditionally Suppress Data
  • Insert Hyperlinks
  • Hide Report Objects

Charts:

  • Creating and Modifying Pie Charts
  • Create a Pie Chart with a Drill-down
  • Change the Chart Title
  • Format a Chart
  • Present a Chart by Group

Report Distribution:

  • Distributing Data
  • Export to Excel
  • Export to an Access Database
  • Create a Report Definition
  • Create Mailing Labels

Learning Outcomes;

By the end of this 2 day Crystal Reports training course delegates will be able to:

  • Display, find, sort and filter data
  • Work with groups
  • Build, write and edit formulas
  • Work with filters
  • Understand formatting
  • Enhance reports
  • Create charts
  • Distribute reports

Duration:

2 Days

No of Delegates – The Total Number of delegates that can sit this is course is a maximum of 12 to uphold the quality of our training and to ensure the course is properly embedded to achieve the companies/individual goals.

Prices – £849 (ex VAT)  Per day for up to 12 delegates trained onsite

(An additional charge for travel will be applied at 40p per mile from Sequence HQ to your premises)