Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Don't let today's disappointments cast a shadow on tomorrow's dreams
 
Unknown
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

Crystal Reports 2008 - Level 1

2 days


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
Using Highlighting Expert
Using Conditional Formatting Formulas

Section Formatting
Overview of 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 applications
Creating a Report Definition


If you require a tailored course click here