Learn: in:
» back to Search Results

Course rating of 5 Vendor rating of 4


Private Crystal Reports Training Class


 
Course Outline
LESSON 1 - REVIEW
  • The Crystal Reports Steps
  • Grouping and Subtotalling
LESSON 2 €" USING VARIABLES IN FORMULAS
  • What is a Variable?
  • Variable Data types
  • Declaring Variables
  • Discreet, Array, Range and Range Array Variables
  • Variable Scope
  • Referencing Variables
  • Formula Restrictions
LESSON 3 - EVALUATION TIME PROCESS
  • Multiple Pass Processing
  • Evaluation Time Functions
  • Creating your own totals While Printing Records
  • Print Time Functions
LESSON 4 - RUNNING TOTALS
  • Creating a Running Total
  • Conditional Running Totals
  • Resetting Running Totals
LESSON 5 - SUBREPORTS
  • Why use Subreports?
  • Unlinked Subreports
  • Linked Subreports
  • On Demand Subreports
  • Shared Variables
LESSON 6 -  USING SQL COMMANDS (XI/2008)
  • What is SQL?
  • SQL SELECT clauses
  • Basing a report on an SQL Command
  • UNION Joins
  • GROUP BY and HAVING Clauses
  • Top N Keywords
LESSON 7 - ADVANCED FORMULA TECHNIQUES
  • Select Case
  • Loops
  • Dynamic Arrays
  • Custom Functions
LESSON 8 - CONDITIONAL FORMATTING TECHNIQUES
  • Conditional Formatting
  • Highlighting Expert
  • Conditional Formatting Formulas
  • Identifying Odd or Even Records
  • Conditional Suppression
LESSON 9 - PARAMETERS
  • Creating a Parameter
  • Creating Range and Array Parameters
  • Changing Parameter values
  • Changing Parameters in the Preview Pane
  • Dynamic Versus Static Parameters (XI/2008)
  • Dynamic Cascading Parameters (XI/2008)
  • Using Parameters for Selection
  • Grouping and Sorting on a Parameter
  • Using Parameters to Suppress Sections
  • Displaying the Results of a Parameter
LESSON 10 - ADDITIONAL TECHNIQUES
  • Dynamic Graphic Locations (XI/2008)
  • Creating an Interval Report
  • Report Alerts
  • Controlling the Display of Column Heading in a Drill Down Report

Prerequisites & Certificates
Pre-Requisites

Crystal Reports 2008 Level 1

Certificates offered


Cancellation Policy
JN Software Consulting works hard to schedule our training and other services around your life, for your
convenience. With that in mind we have the following cancellation policy for all booked training. 
  •  Less than 48 hours: Full quoted fee 
  •  Less than 5 business days: 20% of quoted fee 
  • NSF Charge Policy
    Clients will incur a $40 charge for any NSF cheques
 PLEASE NOTE: Onsite sessions are subject to a 3 hour minimum charge regardless of the duration of the actual training. For sessions expected to last less than 3 hours we suggest booking a live online training session.

Map & Reviews
JN Software Consulting
[ View Provider's Profile ]

Reviews
 
I think this training need more time, it was a bit short in duration
Reviewed by 2011
Gordon was a great presenter and traininer, I learned a lot and he has inspired me to further my knowledge in this subject.
Reviewed by 2011
Good course, great instructor.
Reviewed by 2011
The instructor was amazing.
Reviewed by 2011
Excellent training - instructor, facility, course content. Thank you.
Reviewed by 2011
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 221 times.