Crystal Reports Training Course, Business Objects, Reporting Software

FlareCo

Crystal Reports Training Course. Versions 8.5, 9.0, 10 and XI Level 1

Course Description

Crystal Reports is an industry standard for reporting from databases including SQL Server, Oracle, MS Access and many other ODBC databases.

Crystal Reports Training Course Level 1 is the primary recommended training course you should take if your job requires you to obtain output from databases. In this training course you will build basic list and group reports that work with almost any database. This instructor led course is designed from a person who needs output from a database, whether it be a SQL database, a desktop system such as Microsoft Access, or a spreadsheet such as Microsoft Excel.

Upon successful completion of the Crystal Reports Training Course Level 1, students will be able to:

Create a report using data from an existing database
Locate and present data in a specified order
Create groups to summarize report data
Build Formulae to add non-database data to a report and display data differently
Format reports
Enhance reports by adding and modifying elements in a report
Create single data series charts
Distribute report data to other users

Duration: 2 days

Creating a report

Set default report settings
Specify fields for a new report
Preview the report
Modify field display
Add a report title
Position fields
Add fields from additional tables

Displaying specific report data

Find data
Sort data
Filter data by single criterion

Grouping report data

Insert a group
Add summaries
Format summary information
Change group options
Add another group
Filter by group
Create a Top N sort group

Building formulae

Write a formula
Edit a formula
Group by formula
Delete a formula
Build a filter by multiple criteria
Modify a filter with multiple criteria
Create a parameter field
Write a formula that handles NULLs

Formatting reports

Remove white space
Insert page header/footer data
Add borders and lines
Change background colour
Change the margins

Enhancing reports

Create a section to contain a watermark
Insert objects using OLE
Modify format based on data value
Conditionally suppress data
Insert hyperlinks
Hide blank report sections

Creating and modifying charts

Create a pie chart with drill-down
Modify chart text
Format a chart
Present a chart by group

Distributing data

Export to PDF
Export to Excel
Export to Access
Create a report definition
Create mailing labels