Introduction to Crystal Reports Training - 22:37 hoursThis Crystal Reports course is intended for students who have little to no experience with Crystal Reports. The course will provide students with a general overview of the basic functionality and a general understanding of report design, including the need to provide quality reports in various presentation formats. Students will gain practical experience through hands-on exercises.
Class Prerequisites
Experience in the following is required for this Crystal Reports class:
Basic computer skills
Experience in the following would be useful for this Crystal Reports class:
Familiarity with relational database concepts (tables, fields, and records)
Goals
Explore the Crystal Reports interface.
Learn to create a basic report and modify it.
Learn to format reports..
Learn to filter reports.
Learn to group report data.
Learn to create reports from data in multiple tables.
Learn to use formulas..
Learn to use conditional formatting.
Learn to create summary reports and charts.
Learn to export reports to Excel and PDF.
Learn to use Report Wizards.
Outline
Getting Acquainted with Crystal Reports
Report Writing Process
Opening Crystal Reports
The Database Expert
Review the Toolbars
The Standard Toolbar
The Formatting Toolbar
The Insert Toolbar
The Experts Toolbar
The Navigation Toolbar
The External Command Toolbar
The Report Sections in the Design Tab
Report Header
Page Header
Details
Page Footer
Report Footer
The Field Explorer
Preview the Report
Adding Multiple Tables to Reports
Formatting Reports
Formatting Fields
The AdventureWorks Database
The Format Painter
Working with Objects
Text Objects
Field Titles
Using Fields in Text Objects
Aligning and Sizing Objects
The Section Expert
Images
Filtering Reports
Create a Filter Based on a Single Criterion
Create a Filter for Multiple Selection Criteria
Sorting and Grouping Reports
Using the Sort Expert
Using the Group Expert
Summarizing Records within Groups
Using Basic Formulas
String Formulas
Numeric Formulas
Date/Time Formulas
Running Totals
Conditional Formulas
Advanced Formatting
Using Multiple Sections
Summary Reports
Lines and Boxes
The Highlighting Expert
Exporting and Distribution
Exporting to Excel
Exporting to PDF
Exporting to Word
Crystal Reports Viewer
crystalreports.com |
Intermediate Crystal Reports - 21:52 hoursThis intermediate Crystal Reports training class is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of intermediate report writing along with a good amount of hands on practice. In addition, you will cover professional design, techniques, sub-reporting and advanced formulas.
Goals:
Review the basics.
Learn to use Sections to improve formatting.
Learn to keep running totals.
Learn to work with parameters.
Learn features of advanced formulas.
Learn to create Sub reports.
Learn to create and work with custom Groups.
Learn to work with Cross Tab Reports.
Learn to create Report Alerts.
Outline:
Crystal Reports Review
Creating a Report
Using Parameters
Creating Parameters
Adding a Parameter Field
Optional Parameters
Making a Parameter Optional
Using a List of Parameter Values
Creating a Parameter Value List
Dynamic List of Values
Creating a Dynamic Value List
Cascading List of Values
Creating a Cascading Value List
Multivalue Parameters
Creating a Dynamic Value List
Range Parameter
Creating a Dynamic Value List
Using Subreports
Unlinked Subreports
Creating an Unlinked Subreport
Linked Subreports
Adding a Linked Subreport
Charts
Adding a Chart to a Report
Adding a Chart
Cross-Tabulation Reports
Creating a Cross-Tab Report
Creating a Cross-Tab Subreport
Advanced Techniques
Special Fields
Adding Special Fields to a Report
Using the If Statement
Using the If Statement
Using the Select Case Statement
Using the Select Case Statement
Conditional Formatting
Using Conditional Formatting
Alternating Row Formatting
Formatting Rows by Alternating the Colors
Report Alerts
Using Report Alerts |
Advanced Crystal Reports - 11:22 hoursThis advanced Crystal Reports training class is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover professional design, techniques, sub-reporting and advanced formulas.
Class Prerequisites
Experience in the following is required for this Crystal Reports class:
Intermediate Crystal Reports experience.
Prerequisite Courses
Courses that can help you meet these prerequisites:
Introduction to Crystal Reports Training
Intermediate Crystal Reports
Outline
Crystal Reports Review
Review of Basic Report Building
Working with SQL
The SELECT Statement
Working with SELECT Statements
The WHERE Clause
Filtering with a WHERE Clause
The ORDER BY Clause
Using ORDER BY Clauses
Joins
Joining Tables Together
SQL Commands
Using a SQL Command
SQL Expressions
Using a SQL Expression
Advanced Functions
Evaluation Time Functions
Working with Variables
For Loops
While Do Loops
Working with Variables and Loops
Geographic Mapping
Geographic Maps
Map Basics
Adding a Geographic Chart |