Crystal Reports Training – Advanced

This advanced Crystal Reports training course will teach you how to create advanced formulas and functions, format reports based on calculation results, use multiple sections, insert subreports, use data management features and advanced data access techniques.

This course is instructor led, and involves working on a number of practical, hands on examples and exercises in a workshop environment. Led by highly experienced Crystal Reports trainers with many years of experience our hands-on courses mean that you will leave with lots of practical Crystal Reports experience as well as useful tips and tricks.

You should have attended the Crystal Reports Introduction training course or have a working knowledge of Crystal Reports to an equivalent level. You will also preferably have some hands-on experience using Crystal Reports in a working environment.

Our courses run from 9.30 am to approximately 4.15pm. While you are with us we are focused on offering you a relaxed and productive learning environment. When you book a course with use you get the following:

  • A full colour training manual/book.
  • The exercises that you have worked on during your course to allow you to practice afterwards.
  • USB stick to take the exercises away.
  • Certificate of attendance
  • Freshly prepared lunch.
  • Refreshments throughout the day.
  • Training in fully air conditioned facilities from an experienced instructor.
  • Adding and deleting report sections
  • Hiding sections
  • Closing drill down tab
  • Showing sections
  • Suppressing sections
  • Dont suppress section
  • Suppressing sections conditionally
  • Parameter fields options Wildcard, Edit masks
  • Static, dynamic and cascading parameter fields
  • Formula workshop
  • Variables, types and scope
  • Multi-pass reporting
  • Evaluation Time functions
  • For & While Loops
  • Range variables
  • Built-in running total options; summary, evaluate and reset
  • Creating built-in
  • Modifying built-in
  • Delete
  • Manual
  • Types, layout and expert
  • Creating and modifying
  • Changing chart options
  • Formatting Individual chart elements
  • Group chart custom changes
  • Working with chart templates
  • Deleting charts
  • Inserting an unrelated sub-report
  • Inserting a linked sub-report
  • Edit
  • Format options
  • Using shared variables
  • Working with on-demand sub-reports
  • Creating custom on-demand captions
  • Creating
  • Working with
  • Editing
  • Enabling and disabling
  • Deleting
  • Types and layouts
  • Creating and working with maps
  • Modifying and deleting maps
  • Report Performance Information
  • Server-side processing
  • Verify database
  • Mapping fields
  • Working with the workbench
  • Overview
  • SQl Queries; server side processing, clauses, statements, rules
  • Creating a report using a SQL qurey
  • Editing a SQL command
  • Working with the Group By clause
  • Creating, editing and deleting a SQL expression field