AUCKLAND (09) 378-0411       HAMILTON (07) 838-0700       WELLINGTON (04) 472-4830      CHRISTCHURCH (03) 365-5020      |      
Home Courses Crystal Reports Essential Skills 9-14

Courses


Crystal Reports Essential Skills 9-14

Length: 2 Days    Cost: $1,245 + GST    Version: Crystal Reports 9-14

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreJunJulAugSep
Auckland----
10
--
Hamilton--------
Christchurch--
24
----
Wellington--
10
----

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.


 Print this page