Crystal Reports

Oak Tree Management & Training Ltd.
Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' This course is intended to familiarise the delegate with the skills required to create and modify reports that extract and analyse data.

Crystal Reports is basically a report writing tool that can output data from various sources such as Microsoft Access, Microsoft SQL Server or Oracle in order to generate reports. Delegates learn to design and create basic reports from scratch by using Crystal Report’s Report Experts, then to customize those reports by adding/deleting fields and formatting data. Delegates will also practice creating sections, sorting, grouping and summarizing data, creating formulas and selecting records.

Course Objectives
By the end of the course the delegate will be able to:

Navigate the window
Create, format and save reports
Sort, group and summarise data
Use formulae within reports to analyse or summarise data
Use Smart linking
Create and modify charts
Format sections
Export reports to a number of different media
Course Contents
(Course Topics may vary at the Trainer’s Discretion)

Report Design Concepts
Planning the content of the report
Manipulating the data
Determining printing area characteristics
Developing a prototype on paper
Report Design
Creating a new report
Exploring the report design environment
Placing objects on your report
Previewing and saving your report
Record Selection
Using the Select Expert
Understanding saved vs. refreshed data
Setting additional selection criteria
Modifying record selection with the Formula Editor
Applying record selection on Date fields
Sorting, Grouping, and Summarizing
Sorting and grouping records
Modifying groups
Creating nested or multiple groups
Reordering groups
Summarizing
Using Grand Totals
Applying specified order grouping
Using the Top N/Sort Group Expert
Creating a group selection based on summary information
Grouping on Date or Date/Time fields
Grouping data hierarchically
Formatting for Presentation Quality
Importing pre-formatted data
Inserting lines, boxes and pictures
Text objects
Linking
Defining linking concepts
Using Smart Linking
Formula Basics
Working with the Formula Editor
Applying basic date calculations
Applying Boolean formulas
Applying If-Then-Else formulas
Using Running Totals
Parameters
Introduction to Parameters
Conditional Reporting
Using the Highlighting Expert
Using Report Alerts
Section Formatting
Formatting sections with the Section Expert
Creating a summary report
Charting
Creating a chart using the Chart Expert
Customizing a chart
Report Distribution
Export reports to a number of different media ...''

Elements of this syllabus are subject to change.

Phone:(01284) 763040

School Address/Venue(s):

Park Farm Business Centre
Fornham St Genevieve
Bury St Edmunds
Suffolk
United Kingdom
IP28 6TS

Jobs & Resumes: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Houses & Roommates: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Newcastle, Nottingham
Travel Agencies: Birmingham, Bristol, Cambridge, Edinburgh, London, Manchester, Nottingham

Search other schools for Crystal Reports training resources.

Access Intermediate
Access VBA
Access Working with Queries
Acrobat
Illustrator CS
InDesign CS
PageMaker 7
Photoshop CS2
Crystal Reports - Advanced
Excel - Formulae and Functions
Excel Advanced
Excel Intermediate
Excel Foundation
Excel VBA
FrontPage Advanced
FrontPage
MapPoint

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.