Courses
Crystal Reports Essential Skills 9-14
Length: 2 Days Cost: $1,245 + GST Version: Crystal Reports
= Scheduled class 
= Guaranteed to run 
= Fully booked| Centre | Apr | May | Jun | Jul |
|---|---|---|---|---|
| Auckland | -- | -- | -- | -- |
| Hamilton | -- | -- | -- | -- |
| Christchurch | -- | -- | -- | -- |
| Wellington | -- | -- | -- | -- |
| Virtual Class | -- | -- | -- | -- |
Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.
About this Course
This two day hands-on basics course covers the skills required to analyse data and produce reports in the report designer. Reports can be produced from a wide range of third party software and databases.
Prerequisites
Ideally attendees should be familiar with using Windows applications like Word and Excel. Exposure to Access or any database is an advantage but not essential.
Course Outline
Basic Concepts and Getting Started
Key Concepts, Terminology, Crystal Fields and Objects, Loading Crystal, Report Experts, Report Sections, Fields, Text Objects, Field Attributes, Selecting Objects
Designing a New Report
Creating a Custom Report, Guidelines, Resizing Objects, Report Title, Text, Numeric and Date Properties, Mapping Fields, Summary Info.
Record Selection
Select Expert, Complex Selections, Date Selection
Summarised Reports
Saving Reports, Grand Totals, Highlight Expert, Merging Text and Data Objects
Sorting and Grouping
Sorting and Grouping of Data, Group Tree, Subtotals, Page Breaks, Sort Order
Totals and Summaries
Summaries and Subtotals, Percentage Summaries, Summary Reports, Hide and Suppress Sections
Printing and Exporting Reports
Printing, Saving, and Exporting Reports, Create a Crystal Report with the Excel Spreadsheet add-in.
Special Fields
Pages Numbers and Counts, Print Date & Time, File Path & Name, File Author.
Introduction to Formulas and Functions
Formulas in Reports, Conditional Formatting and Selection Formulas, Truncate & Round Functions, Using IFThenElse
Linking Tables
Database Concepts, Linking Two Tables, Table Relationships, Accessing Data Directly, Linking Two Tables through Direct Access, Visual Linking Expert.
