The Region Leader in Professional Hands-On IT TrainingProfessional Hands-On IT TrainingYour Trusted Onsite Training Partner
Computer Training at Your Site
IT Training and Certification Guru
Computer Training. CSS Training. Adobe Training
You Are Here: You Are Here-->  Home >> Courses >> Crystal Reports


The most effective way to get real world experience through hands-on training!

 FOR CRYSTAL REPORTS 11 VIDEO TRAINING CLICK HERE

  Prerequisite to the course
 Who should attend
Information Professionals or business users who need to quickly become proficient in creating and modifying reports within their organization.

 Prerequisites for Introductory Report Design
Students must have a working knowledge of Windows applications. Basic knowledge of database concepts such as tables, fields and records is also necessary.

 Prerequisites for Intermediate Report Design
Students must have completed the Introductory Report Design course and/or have a proven working knowledge of Crystal Reports features including record selection, sorting, grouping and summarizing and formulas.

  Introductory Report Design

 Overview
This two-day course is designed for beginner to intermediate Seagate Crystal Reports users who need to quickly become proficient in creating and modifying reports. Some of the topics include creating a basic report, record selection, sorting, grouping and summarizing, basic queries, exporting to other formats, and formulas.Intermediate part of the course has a goal to increase report design skills and discover the advanced reporting power of Crystal Reports. Along with hands-on practice, the course covers architecture, Structured Query Language as it relates to Crystal Reports, advanced formula creation, Dictionaries, and Queries

 Who should attend
Currently the course is offered to organizations and corporate employees. If you are an individual who want to learn Crystal Reports on your own, make sure you have basic programming skills and at least 1 year of previous programming experince. Please contact our Office for no-obligation consultation.


Report Design
  • Exploring the Report Design window
  • Starting a new report
  • Exploring the Design Tab
  • Placing objects on your report
  • Previewing your report
  • Positioning and sizing objects
  • Formatting objects
  • Using Text Objects
Record Selection
  • Using the Select Expert
  • Using the Select Record options
  • Defining the Select Expert's features
  • Understanding saved vs. refreshed data
  • Applying Record Selection
  • Using the Format Editor to modify the Record Selection statement
  • Applying Record Selection on Date Fields
Sorting, Grouping and Summarizing
  • Sorting Records
  • Grouping Records
  • Working with groups
  • Summarizing
  • Using Grand Totals
Presentation Quality Reports
  • Using Special Fields
  • Applying lines and boxes
  • Inserting a picture
Text Objects
  • Combining Text Objects with Database Fields
  • Combining Text Objects with Special Fields
  • Formatting individual elements of a Text Object
Linking
  • Defining linking concepts
  • Adding/removing databases from a report
  • Using Smart Linking
  • Working with links
Formula Basics
  • Using formulas
  • Using the Formula Editor
  • Using basic calculations
  • Using string manipulation
  • Applying basic date calculations
  • Applying If Then Else formulas
  • Applying Boolean formulas
Section Formatting
  • Changing the size of a section
  • Formatting sections with the Section Expert
  • Creating a Summary report
Conditional Reporting
  • Using Conditional Formatting
  • Using the Highlighting Expert
Charting
  • Using the Graph/Chart Expert
  • Graphing on Summary information
  • Graphing Detail or Formula fields
  • Drilling down on a graph
  • Customizing a graph
Geographical Mapping
  • Understanding Geographical Mapping
  • Mapping summarized data
  • Customizing a map
Basic Report Distribution

  Intermediate Report Design

Report Creation Review
  • Reviewing Report Creation
  • Reviewing Advanced Record Selection
  • Reviewing Advanced Grouping
  • Reviewing Conditional Formatting
  • Reviewing Linking
Sections
  • Exploring sections
  • Formatting sections
Advanced Formulas
  • Exploring Functions
  • Using multi-condition If Then Else formulas
  • Using Variables
  • Using Running Total Fields
  • Using Date/Time Functions
  • Understanding UFLs
Parameter Fields
  • Defining Parameter Fields
  • Creating Parameter Fields
  • Using Parameter Field
Subreports
  • Defining Subreports
  • Creating an unlinked subreport
  • Creating a linked subreport
  • Creating an On demand subreport
  • Passing information from a subreport to the main report
Cross-Tab Objects
  • Defining Cross-Tab Objects
  • Creating a Cross-Tab
  • Formatting Cross-Tabs
Report Design and SQL
  • Using Seagate Crystal Reports and SQL
  • Defining the SQL Query
  • Enabling Server side processing
  • Editing the SQL Query
  • Using SQL Expressions
  • Applying SQL Options
Queries
  • Understanding the Crystal Query Designer
  • Using the Crystal Query Designer
  • Viewing the query as a report on the web
Advanced Report Distribution
  • Understanding Compiled Reporting
  • Understanding the Report Distribution Expert
Send your comments and questions through our Feedback Form. Designed by 800-webdesign.com