Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Intermediate Crystal Reports

Version 2013 • 2016

1 Day, 9:00-4:00, 6 Hours

This instructor-led, hands-on course teaches the basic skills needed to create complex reports using Crystal Reports. It covers how to use advanced string and date functions, insert parameter fields to prompt for values, work with advanced totaling and grouping features, create cross-tab reports and charts to present your data in a more meaningful way, create multiple-section reports, and apply conditional formatting. In order to successfully complete this course, we recommend that you first take Softek’s Introduction to Crystal Reports course or have equivalent knowledge. You should feel comfortable creating basic reports from scratch and using wizards; insert database, text, and special fields; format objects; sort, group, and total data; and write basic formulas to calculate information.

Advanced Grouping Features

  • Sorting Summarized Group Values
  • Identifying the "Top" Groups
  • Creating Custom Groups

Applying Conditional Formatting

  • Understanding If-Then-Else Formulas
  • Applying Conditional Field Formatting
  • Creating a Nested If Statement
  • Applying Conditional Section Formatting

Using String and Date Functions

  • Using String Functions
  • Sorting and Grouping by Date
  • Using Date Functions
  • Using Arrays

Using Parameter Fields

  • Creating a Parameter Field
  • Using the Parameter in a Selection Formula
  • Refreshing Report Data
  • Modifying the Report Title to Include a Parameter Field
  • Creating a Date Parameter Prompt

Charting Data

  • Creating a Chart for a Report
  • Resizing and Moving a Chart
  • Using a Chart for Drill-down
  • Creating a Chart for Groups

 

Creating Cross-Tabs

  • Using the Cross-Tab Wizard
  • Selecting the Data Source
  • Verifying or Establishing Links
  • Selecting Fields for the Cross-Tab Report
  • Applying Record Selection
  • Selecting the Look of the Cross-Tab Report
  • Changing a Summary Field
  • Creating an Additional Summary
  • Pivoting a Cross-Tab
  • Charting a Cross-Tab

Creating Form Letters & Using Multiple Sections

  • Inserting the Date
  • Creating Additional Detail Sections for Each Address Line
  • Printing One Form Letter Per Page
  • Suppressing Blank Sections
  • Creating Detail Sections for the Message
  • Creating a Detail Section for the Closing
  • Setting Conditions on a Section

View Upcoming Schedule or Register for a Class

Is this the right course for you? Please contact our office at (202) 747-5000 if you have any questions.

Back to Agenda

 

Investment

Public Class

$325 per student
Or one voucher

View Schedule or Register

Private Group Classes

Conducted at Your Office

$1400 flat fee for up to 8 students
$1600 flat fee for up to 12 students
$100 per additional student

Conducted at Softek’s Facility

$1550 flat fee for up to 8 students
$1750 flat fee for up to 12 students
$100 per additional student

Have more or fewer students? Or, need to schedule more than one training day? Fill out our quote request form for a price quote based on your training needs. 

Why choose Softek?

  • Live, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee