Crystal Reports - Advanced

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 designed to increase delegates report design skills and further enables them to discover the reporting power of Crystal Reports. Along with hands-on practice, the course covers structured Query Language as it relates to Crystal Reports. The course covers formulas using variables and evaluation time functions, parameters, cross-tabs and geographical mapping.

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. It enables power users and developers to integrate their organisation’s data into sophisticated reports and front-end applications for company wide distribution. Crystal Reports lets you transform almost any data into interactive content that can be integrated into .NET, Java and COM applications and efficiently share it via portals, Microsoft Office documents and wireless devices.

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

Group and sort information based on various variables
Create and format sections in reports
Use mathematical operands and formulae in the creation of reports
Understand multi-pass reporting
Define, format and chart using Cross-tabs
Use Sub Reports
Create and Edit Geographical reports
Course Contents
(Course Topics may vary at the Trainer’s Discretion)

Sections
Using sections
Formatting sections
Formulas
Understanding formula language and syntax
Using functions and operators
Using variables
Using an If-Then-Else control structure
Using Case control structures
Using Looping Structures
Parameters
Defining parameter fields
Creating parameter fields
Using parameter fields
Geographical Mapping
Defining Geographical Mapping
Creating a map based on summarized data
Creating a map based on detail or formula fields
Editing a map with the Map Expert
Editing a map on the Analyzer tab
Resolving data mismatches
Cross-Tabs
Defining Cross-Tabs
Creating a Cross-Tab
Formatting Cross-Tabs
Charting on a Cross-Tab summary field
Mapping on a Cross-Tab summary field
Sub Reports
Defining sub-reports
Creating an unlinked sub-report
Creating a linked sub-report
Creating an On-demand sub-report
Using shared variables
Working with Databases
Accessing data sources
Using SQL to process reports
Applying database options
Adjusting to database changes
...''

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 - Advanced training resources.

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

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.
 

Tips: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.