Crystal Reports

Silicon Beach Training Ltd.
Brighton, East Sussex, United Kingdom

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

Course Description:

'' This Crystal Reports training course will teach Students the basics of report creation including sorting, grouping, linking, basic formula creation, working with report experts and how to distribute reports to other users.

This Crystal Reports training course is designed for users with little or no experience with Crystal Reports but who have the need to generate reports based on data available to them.

Crystal Reports Training Course Objectives
Upon successful completion of this crystal reports training course, students will be able to:

Plan the needs for your report including data as well as appearance.
Become familiar with components of the Crystal Reports application window.
Create reports based directly on database information, use a report expert or create a copy of an existing report.
Add, modify and remove report objects such as data fields, text objects, file information, graphics or decorative lines and boxes.
Format the appearance of your report using font, colour, border and number choices.
Change the selection criteria and sort order of your data.
Create subtotals, grand totals and summaries for your report data.
Create, edit and delete formulas. Understand Crystal’s formula language.
Understand linking concepts then create and modify your own links.
Identify and control Crystal’s report sections.
Distribute your reports to those who need the information through a variety of methods.
Crystal Reports Training Course Content
Overview
Examine the application’s capabilities
Think about the steps necessary to create reports
Review reports and databases to be used in class
Modify the program default settings
Use help
Creating Simple Reports
Identify the sections of the report
Create a new report
View your report as it will print
Format your report by changing the size and position of the fields
Enhance your report by adding a report title and changing the font attributes of your labels
Add page numbers and other document information as well as a company logo or other graphics in your report
Save your report
Sorting and Selecting Records
Sort records
Use the Select Expert to limit records
Add an additional selection criterion using the "And" statement
Modify composite formulas and the selection criteria statement
Grouping and Summarizing
Define a single level group
Define a multiple level group
Modify grouping options
Insert subtotals and grand totals
Insert summary fields
Insert percent of the total fields
Insert grand total summary fields
Use Top N/Sort Group Expert
Parameter Fields
Understand Parameter fields
Creating Parameter fields �Free Text Entry
Creating Parameter fields –To Select Records
Using the Report Expert
Create new reports using the Standard Report Expert
Create new reports using the Mailing Labels Report Expert
Edit a report created using an Expert
Linking
Understand relational database basic concepts
Create links using the Visual Linking Expert
Examine Link Options
Look at the difference between PC and SQL links
Creating Formulas
Understand Formula Components
Create new formulas using the Formula Editor
Make changes to formulas
Create and use String formulas
Create and use Date functions
Work with summary formulas
Create and use If-Then-Else functions
Formatting Sections
Review sections
Resize sections in Design view
Use the Section Expert
Create Summary and Drill Down reports
Distributing Data
Identify exporting options
Export a report into office suite applications
Create a report using spreadsheet data
Discuss Web browser options to view reports on-line
...''

Elements of this syllabus are subject to change.

Phone:+44 (0)1273 622272

School Address/Venue(s):

86 Gloucester Road
Brighton
East Sussex
BN1 4AP
UK

Jobs & Resumes: Brighton
Houses & Roommates: Brighton

Search other schools for Crystal Reports training resources.

Project
Excel
VBA For Excel
Access
Outlook
Word
Powerpoint
Mac
PC and the Internet
Visio
Sage Instant Accounting
Sage Line 50
VBA For Access
Access API
ACT
Publisher
FrontPage
Ruby on Rails
SQL

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: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.