• Moneyback Guarantee
    -
    100% Peace of mind
  • Expert Trainers
    -
    >12 years experience
  • Happy Customers
    -
    92% book again
  • Rated Outstanding
    -
    11 years in a row

Our Crystal Reports Courses

Crystal Reports Training – Introduction / Intermediate

Crystal Reports Introduction & Intermediate

CPD Certified
4.93 / 5
2 days.
Client Site Courses Available.
Live Online & Client Site.

This beginners course will give you a thorough grounding in the basics.

  • Introduction to Crystal Reports
  • Creating basic Reports
  • Sorting, selecting & grouping records
  • Creating formulas & linking
  • Using Report Expert & sharing data

Overview

This beginners course will give you a thorough grounding in the basics.

  • Introduction to Crystal Reports

  • Creating basic Reports

  • Sorting, selecting & grouping records

  • Creating formulas & linking

  • Using Report Expert & sharing data

Full Syllabus

  • Examining the application’s capabilities
  • Reports and databases
  • Modifying the program default settings
  • Using help
  • Identify the sections of the report
  • Create a new report
  • View your report as it will print
  • Format your report by changing the size and position of the fields
  • Enhance your report by adding a report title and changing the attributes
  • Add page numbers, logos or other graphics in your report
  • Save your report
  • Sort records
  • Use the Select Expert to limit records
  • Add an additional selection criterion using the “And” statement
  • Modify composite formulas and the selection criteria statement
  • Define a single and multiple level group
  • Modify grouping options
  • Insert subtotals and grand totals
  • Insert summary fields
  • Insert percent of the total fields
  • Use Top N/Sort Group Expert
  • Understanding cross-tab reports
  • Use the Cross-Tab Expert
  • Edit your cross-tab report
  • Modify cross-tab layout options
  • Format your cross-tab report
  • Understand relational database concepts
  • Use the Visual Linking Expert
  • Examine Link Options
  • Difference between PC and SQL links
  • Understand Formula Components
  • Create formulas using the Formula Editor
  • Make changes to formulas
  • Create and use String formulas
  • Create and use Date functions
  • Work with summary formulas
  • Create and use If-Then-Else functions
  • Review sections
  • Resize sections in Design view
  • Use the Section Expert
  • Create Summary and Drill Down reports
  • Identify exporting options
  • Export a report into office applications
  • Create a report using spreadsheet data
  • Discuss Web browser options to view reports online

Am I Ready?

This is a beginners’ course. We do not assume that you have used Crystal Reports before.

This course assumes that you have a basic understanding of working with computers, so you’re comfortable working with multiple windows, navigating the desktop and have an understanding of computer file storage (i.e. drives, files and folders). So long as you’re happy with that you’ll be fine.

Instructor

CPD Accreditation

Dates, Prices & Booking

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £695.00 (+VAT)

Book Now
Crystal Reports Training – Advanced

Crystal Reports Advanced

CPD Certified
4.93 / 5
2 days.
Client Site Courses Available.
Live Online & Client Site.

Become a Crystal Reports expert on this advanced course!

  • Using parameters & formulas
  • Working with charts & maps
  • Creating sub-reports
  • Report processing
  • SQL Queries

Overview

Become a Crystal Reports expert on this advanced course!

  • Using parameters & formulas

  • Working with charts & maps

  • Creating sub-reports

  • Report processing

  • SQL Queries

Full Syllabus

  • Adding and deleting report sections
  • Hiding sections
  • Closing drill down tab
  • Showing sections
  • Suppressing sections
  • Don’t 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
  • 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 query
  • Editing a SQL command
  • Working with the Group By clause
  • Creating, editing and deleting a SQL expression field

Am I Ready?

As this is an advanced course it assumes that you understand the basics of working in Crystal Reports.

To attend this course you should have:

  • Attended our 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.

Instructor

CPD Accreditation

Dates, Prices & Booking

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £795.00 (+VAT)

Book Now

Easy booking & payment

Money back guarantee

Post-course support

Crystal Reports FAQs

We will send you an invoice after receiving your booking, so please book a course as normal.

If you need an invoice to generate a PO number please book as normal and then contact us when you have a PO number which we will be happy to add to your invoice and reissue you the update invoice.

Please send supplier set-up requests to [email protected]

Yes. We frequently run courses at our clients’ offices.

Our courses run from 9.30 to approximately 4.30, with coffee breaks at 11am and 3pm and a longer break for lunch at 12.30.

Yes. Our trainers are present through-out our online courses to lead you through the material and answer questions just as they are on an in-person course.

Yes. We provide a certificate of completion for all courses and can supply a CPD certificate on request.

No. We run separate online and face-2-face training courses to maximise our trainers’ attention on course delegates.

Please see here for our full terms and conditions.

No. We provide everything you need for the training including pens, pads and chocolate biscuits.

Yes and no!

Software on Macs is usually laid out a little differently, has different shortcuts, and occasionally has slightly different functionality.

99% of what our courses cover is applicable to Macs so we often have Mac users attend our courses, but to avoid confusion, we do not use Macs in our training centres, and they are not suitable for attending our online training.

Where Do Your Courses Run?

London Training Venue & Course Details

St Clements House, 27 Clements Lane
London, EC4N 7AE
Tel: 0203 603 0150

Guildford Training Venue & Course Details

Surrey Technology Centre, 40 Occam Road
Guildford, GU2 7YG
Tel: 01483 688 488

Online Courses

We run a full schedule of remote courses over Zoom.
We also deliver private courses over Teams, if requested.

What Do Previous Delegates Say

Getting To Know You

Letting us know before the course which areas you would like to focus on is very helpful.

Tell Us What You Are Looking For From Your Course ->