Crystal Reports Intro / Intermediate Training Course Information
Duration: Two Day Price: $1150
| Software and Version | Course Length | January 2021 | February 2021 | March 2021 | April 2021 | May 2021 | June 2021 |
|---|---|---|---|---|---|---|---|
| Crystal Reports Intro / Intermediate | 2 Day Course | 7 & 8 January | 25 & 26 February | 4 & 5 March | 6 & 7 April | 19 & 20 May | 29 & 30 June |
Course Booking
Target Audience & Purpose
Crystal Reports Introduction is for people new to report design using Crystal Reports, and for self-taught users to enhance their knowledge. It is a pre-requisite for the Advanced course.
Objectives
By the end of this course participants should be able to:
- Plan, create, format and distribute a report
- Organise data on a report
- Select records
- Apply section formatting
- Create basic formulas
- Apply conditional reporting
- Present data visually
Course Inclusions
- Comprehensive learning materials incl. exercise files
- Post course telephone support
- ‘Certificate of Attendance’
on completion of course - Morning & afternoon tea
Course Prerequisites
Participants should already:
- Be competent in using a mouse and keyboard
- Have an understanding of Windows
- Have basic database concepts
Crystal Reports 11 Intro / Intermediate Training Course Content
Getting Started
- Planning a report
- Understanding the Crystal Reports Environment-Design Tab, Toolbars, Preview Tab
- Connecting to the data source – using the Database Expert
- Placing objects on the report using the Field Explorer
- Report Titles using Summary Info & Text Box
- Previewing & saving reports
- Modifying reports – Resizing fields, Arranging Fields, Field Alignment
Organizing Records
- Sorting
- Record selection including:
- Understanding the Select Expert Features
- Determining the record selection criteria
- Applying record selection on string, number & date fields
- Using multiple section criteria
- Modifying record selection with the formula editor
Grouping including:
- Creating groups with different data types
- Modifying groups
- Nested Groups
- Specified groups
Summarizing including:
- Inserting summaries for different data types
- Creating percentage summaries
- Inserting Grand Totals
- Using the Group Sort Expert
Formatting including:
- Using the Format Editor
- Formatting String Fields
- Formatting Number Fields
- Formatting Date Fields
- Adding Lines & Boxes
Formatting
- Using section expert features to format sections
- Creating summary reports
Formulas & Functions
- Formula basics including:
- Formula Components & Syntax
- Using the Formula Workshop
- Creating basic formulas
Modifying formulas
- Editing formulas
- Deleting formulas
Functions including:
- Basic Calculations using summary functions
String Manipulation - Basic Date Functions
- Boolean Formulas
- Applying If Then Else formulas
- Using Nested if then else statements
Conditional formatting including:
- Using the Highlight Expert
- Formatting fields conditionally
Wizards
- How to use the report wizards
- Creating a cross tab report using the wizard
- Creating a cross tab report in an existing report
- Formatting cross tabs
Report Distribution
- Exporting the report in various formats
- Distributing the reports
Forrest Training
Roving one-on-one trainer
Microsoft Office Courses
- Windows 10 Training
- Computer Fundamentals Course
- Microsoft Access Training
- Microsoft Excel Training
- Microsoft Office Training Schedule
- Microsoft Office Upgrade Training
- Microsoft OneNote Training
- Microsoft Outlook Training
- Microsoft PowerPoint Training
- Microsoft Project Training
- Microsoft Publisher Training
- Microsoft Visio Training
- Microsoft Word Training
Microsoft Training & Certification
Desktop – Non Microsoft Courses
Professional Development Courses
- Business Etiquette Training
- Change Management Training
- Creative Problem Solving Training
- Customer Service Training
- Effective Business Writing Training
- Effective Communication Skills Training
- Leadership and Influence Training
- Management Fundamentals Training
- Negotiation Skills Training
- Presentation Skills Training – Presenting with Confidence
- Project Management Training
- Time Management Training