Users who need to design, create and analyse reports by connecting to external data sources.
Objectives:
By the end of the course users will be familiar with the Crystal Reports interface and be able to produce reports based on both ‘flat’ and ‘relational’ data sources. Users will be able to extract accurate data and summarise data using formulae and functions.
Prerequisites:
Users must be proficient with a mouse and keyboard and be able to confidently work within a Windows environment - minimise, maximise, open, close. Familiarity of either Microsoft Excel or Microsoft Access is useful, but not essential.
Duration:
2 Days
Cost:
£395 + VAT
Course Date
Location
22/02/2012
Bradford
22/03/2012
Liverpool
08/05/2012
Bradford
18/06/2012
Liverpool
23/08/2012
Bradford
20/09/2012
Liverpool
12/11/2012
Bradford
17/12/2012
Liverpool
Introducing Crystal Reports
What Is Crystal Reports?
The Crystal Reports Interface
Working with the Field Explorer
Getting Assistance
Getting Help in Crystal Reports
Getting Started
Planning & Creating Reports
Exploring the Report Design Environment
Previewing & Navigating Report Pages
Modifying Reports & The Reporting Environment
File & Report Options
Page & Printer Setup
Placing & Positioning Controls
Moving, Sizing & Deleting Controls
Aligning Controls
Working With Text Objects
Combining Text Objects & Fields
Inserting Special Fields, Headers & Footers
Absolute Formatting
Formatting Text Objects
Working with Lines, Boxes & Pictures
Formatting Report Sections
Applying Themes with the Template Export
Organising Records
Sorting by One/Multiple Fields
Finding Records
Filtering Records & Selection Criteria
Filtering Data with Parameters
Grouping & Summarising Data
Creating Running Totals
Formulae & Functions
Working with the Formula Workshop
Creating Calculations using Fields & Mathematical Operators
