Jump to course:

Crystal Reports for Windows

Overview

The aim of this course is to produce flexible reports using Crystal reports. Crystal is a powerful reporting tool which is regularly used to report from Access, SQL Server, Oracle, Sybase and other relational databases. This course provides an introduction to reporting from relational databases and explores Crystal Reports’ features for summarising and highlighting data. Attendees will learn how to produce a range of different reports from list oriented reports to those with embedded subforms containing graphs and tabular information.

Learn To

Connect to a database directly and via ODBC
Work with formulae to summarise data into groups
Export reports to Excel and onto the web
Create run-time reports for distribution
Highlight and flag important data in a report

… and much more

Course Content

Introduction to relational databases (tables, fields, relationships)
Setting up a report Field types
Formatting fields
Selecting records
Sorting report data
Grouping report data
Creating custom groups
Summarizing and totalling data
Building formulae
Formula syntax
Adding graphs/charts
Working with OLE objects
Previewing a report
Editing in preview mode
Working with field types
Order of precedence
Useful domain functions (max, min, average etc.)
Calculating with dates
Default Date formats
Report headers and footers
Repeating sections
Refreshing report data
Sub-reports Embedding sub-reports
Changing run-time properties
Highlighting and flagging data
Summary report types
Tabular reports
Creating charts and graphs
Exporting report data
Creating run-time reports

Objectives

To be able to create, manipulate and modify reports. To understand the implications of selection criteria. To be able to group, sort and summarise data in a report. To use formulae, custom group levels and sorting to order data. To work create and insert sub-reports and understand where they are required. To flag, customise and highlight data in a report. To be able to build run-time reports. To be understand the data refresh options.

Audience

New users of Crystal Reports wishing to learn to report from data from a variety of different sources.

Duration

2 Days

Maire Costigan – Bewley’s Limited