For training call +44(0)1273 6222 72

Your basket is empty View Cart shopping cart

MAKE AN ENQUIRY Download Course Outline

What is Crystal Reports Masterclass?

Crystal Reports Masterclass training course elevates a delegate's knowledge of how to optimise the most recent and up-to-date Crystal Reports software to create comprehensive business reports with statistical support. Delegates will learn the fundamentals of reader-friendly report writing - from sorting, grouping, and transforming variables using algebraic formulas to distributing the report to stakeholders.

The training course also instructs delegates on how to implement SQL query writing and geographic mapping skills within their report writing, in order to create highly complex and stakeholder/business specific business reports. This training course provides delegates with an elevated appreciation of the Crystal Reports Software, including how to utilise all of its specialised functions such as complex data analysis, group and elemental list reports, subreports, cross-tabs, and content inclusion - enabling the development of comprehensive business reports. This Crystal reports course is very hands-on and focuses on developing transferable skills that individuals can incorporate in their business writing. The course is led by experienced Crystal Reports instructors, and consists of practical activities, allowing delegates to gain much hands on experience.

What’s included?

  • Certificate
  • Tuition from a highly experienced and engaging instructor
  • Crystal Reports Coursework Book
  • Refreshments

Crystal Reports Masterclass Course Content

Introduction to Crystal Reports

  • Overview of Crystal Reports
  • Reports and Databases
  • Utilise Crystal Reports Help function
  • Adapting and personalising settings

Report Utilisation and enhancement

  • Construct a Report including utilising dedicated Report sections and presenting distinct data
  • Make Report adjustments including formatting, embedding objects, and containing report sections
  • Utilise Report pre-arrangements and templates

Embedding Formulas in Reports

  • Generate and revising a Formula
  • Data filtration utilising a Formula
  • Utilising Advanced Formulas
  • Demonstrate and develop competency with Formula functions including treatment of Null variables and values

Development of Parameterised Reports

  • Develop a Parameter Field and employ a Range Parameter within a Report
  • Compose a Prompt

Collating and Grouping Report Data

  • Group Data and devising a Group Report
  • Group utilisation of Parameters
  • Develop a Parameterised Top N Report

Report development utilising Excel Data Sets

  • Generate, edit, and renovate a Report compiled of Excel Data

Developing Running Tabs

  • Devising, editing, and utilising a Running Total Field
  • Generating a Manual Running Total

Utilising Cross-Tabs

  • Developing and formatting a Cross-Tab Report, including the development of Groups in relation to Cross-Tab Reports

Supplementing Sub-reports

  • Developing and modifying Subreports
  • Dispensing Variables
  • General development of Drill-Downs including the overall construction of Drill-Downs with headings in a Report

Report Processing - Utilising SQL Statements

  • Developing: Sub-queries joins using SQL and SQL Expression Fields
  • Producing a report utilising SQL queries and commands
  • Demonstrating the ability to draw conclusions from Report data
  • Report Alterations through the utilisation of SQL Statements
  • Producing sophisticated Formulas
  • Developing and producing complex formulas
  • Engaging with Loops and Arrays

Report content and components

  • Categorise data in a hierarchical structure
  • Utilising visual representations such as graphs, charts, and diagrams
  • Produce report notifications
  • Develop Dynamic Images
  • Reviewing content

Booking

* Required

For in-company or private training please request a quote

 
 

Course Details

  1. Course Title

    Crystal Reports Masterclass

  2. Duration

    1 Day

  3. Price Starting From

    £548.00 + VAT

Upcoming Dates

Onsite Training

This course can be run in-company anywhere in the world & we can tailor the content to focus on your requirements.

We regularly provide training in London, Manchester, Bristol and all over the United Kingdom.

Who is this course for?

Crystal Reports Masterclass Training is ideal for the:

  • Individuals who need database outputs
  • Individuals that are required to write reports in their work
  • Individuals that wish to improve upon or clarify their data analysis knowledge
  • Delegates who want to gain a recognised qualification in report writing
  • Managers needing to write business reports
  • Office staff involved in data analysis
  • Avid business writers
  • Business managers with report writing duties
  • Project Managers
  • Data analysis office staff
  • Individuals that aspire to develop a comprehensive and thorough insight of the Crystal Reports Software

Related Courses