• 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

FAQs

  • Desk distancing complies with guidelines
  • Hand sanitising on arrival
  • Facemasks available
  • In the office all training equipment and furniture sanitised thoroughly after use
  • Stationery used by the delegates during training to be taken away with the delegate or disposed of at the end of the day
  • The building cleaning staff regularly disinfect all of all of the doors, handles, stair hand rails, etc.

Our online training is designed to re-create the classroom experience as closely as possible. It is a live training session using Zoom or Teams and the trainer is there throughout. The training is still hands-on so you do need to have the software installed on your own computer. The trainer shares their screen to demonstrate techniques and there is also the option of being able to share your screen if you are really stuck! Depending on the class size, which we still keep to a maximum of 8, questions can be asked at any time or at set points throughout the day.

The trainers like to see you! They much prefer it if you have a camera on so they can see you as well as you them.

We provide everything that you will need for a fun, productive day of training.

Everyone has their own computer to work on in a comfortable, bright, air-conditioned room.

We provide plenty of tea, coffee & biscuits.

We provide 6 months of post-course support as well.

If you get stuck on anything relating to the course simply get in touch and explain the issue.

We will make sure your trainer contacts you as soon as possible to help you out.

We don’t want to be the biggest training company but we are trying to be the best.

We have now won the Feefo Gold Award for customer service for 6 years in a row.

We always limit our classes to a maximum of 8 delegates but try to keep them smaller. During 2018 our average class size was 4 people.

To back up our promise of great training we offer a 100% money back guarantee.

Our focus is on you being a faster, more capable Crystal Reports user when you return to work.

Our courses combine traditional teaching to explain new concepts and tools with hands-on exercises.

The exercises ensure that you get plenty of time to try out what you have just been taught and make sure that you really understand it.

We also make sure that there is plenty of time for you to ask questions in case there is anything you are unsure of.

We aim to use the most recent version of Crystal Reports available for our training.

If you use an older version that’s usually no problem. Simply let us know and we can usually organise a laptop for you with that version of Crystal Reports on it.

We provide everyone who attends one of our courses with a certificate of attendance.

This means that you can prove to people that you are a capable user of the software as you have attended a professionally run training course on how to use it.

We provide support for the 6 month period after you attend one of our courses.

If you get stuck on something covered during your course simply clearly let us know what the problem is and we’ll get your trainer to call you with the fix as soon as they are able to.

Our focus is on you returning to work a much faster and more confident Crystal Reports user.

To do this we believe that you need to be both shown how to use new techniques and tools and then practise using them.

This means that we are strong believers in hands-on training.

During your course you will work independently on a number of exercises. These are carefully designed to reinforce what you have just learnt.

They also mean that you have plenty of time to ask questions if you’re unsure of anything as our trainers are on-hand throughout.

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.

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 ->