 |
|
|
|
|
|
|
A celebrity is a person who is known merely for being well known
|
 |
|
|
 |
|
|
|
| |
|
|
|
Crystal Reports 2016 - Introduction
This instructor-led course is designed to provide the foundation skills and knowledge to design and create reports that will help organisations analyse and interpret their operational information.
As a business benefit, delegates will find this course provides a good knowledge basis which covers topics from creating reports from scratch to distribution.
Course Pre-requisites:
Delegates must have a basic knowledge and understanding of databases and database design. |
|
| Overview |
Overview of Crystal Reports
Overview of Database Concepts
Setting the Default Settings for Crystal Reports
|
| Creating Basic Reports |
Creating a New Blank Report
Connecting the Report to the Datasource
Adding Tables to Reports
Adding Fields to Reports
Previewing Reports
Repositioning & Resizing Report Objects
Formatting Reports
Adding Images to Reports
Adding Lines & Boxes to Reports
Adding Hyperlinks to Reports
Saving Reports
|
| Linking |
Overview of Relationships
Overview of Joins
Creating Relationships in Crystal Reports
|
| Selecting Records |
Overview of Selection Criteria
Using the Select Expert
Creating Select Criteria
Using Saved Data vs Refresh Data
Modifying Record Selection Criteria
Applying Multiple Record Selection Criteria
Finding Nulls
|
| Organising Report Data |
Sorting Records
Adding Sort Controls to Reports
Grouping Records
Applying Summary Fields to reports.
Applying Percentage of Summary fields to Reports.
Creating Top N/Bottom N Reports.
|
| Creating Basic Formulas |
Overview of Creating Formulas
Overview of the Formula Workshop
Creating Basic Numeric Formulas
Renaming & Modifying Formulas
Creating String Formulas
Creating Date Time Formulas
Creating If Then Else Formulas
Creating Boolean Formulas
|
| Conditional Formatting |
Overview of Conditional Formatting
Overview of Section Formatting
Using Highlighting Expert
Using Conditional Formatting Formulas
|
| Section Formatting |
Formatting Report Sections
Creating Summary/Drilldown Reports
Applying Conditional Formatting to Sections
|
| Using Charts in Reports |
Overview of Charts
Creating Pie Charts
Modifying & Formatting Charts
Creating Bar Charts
TopN/Bottom N Charts
|
| Distributing Reports |
Overview of Distributing Report Methods
Exporting Reports to different applicatio
Creating a Report Definition
|
|
|
|
