sss

Crystal Reports Courses

Crystal Reports is used to design and generate business reports from practically any data source.  It transforms data into meaningful information and allows stakeholders to make better business decisions.  Our Crystal Reports training courses will teach you the report building/processing skills needed to connect to databases, retrieve raw data, format it and create and present reports for widespread distribution.

We train on ALL versions of Crystal Reports, please call for older course outlines.

Crystal Reports 2020 Advanced course

2 days

This Crystal Reports 2020 Advanced course is designed to increase report design skills and discover the reporting power of Crystal Reports.  Topics covered include grouping options and sub reports, formulas such as variables and functions, querying using SQL reporting and charting.

Download PDF

What will you learn?

At the end of this Crystal Reports 2020 Advanced course, delegates will have learned how to:
  • Use advanced formula techniques including variables
  • Create running totals in a report
  • Understand and optimise the three stage processing of reports
  • Learn basic SQL and ODBC techniques to expand data source capabilities
  • Create data dictionaries for use as report sources
  • Use advanced parameter techniques and create “alerting” reports
  • Use advanced section techniques and create sophisticated paging reports
  • Use sub –reports (active and passive)
  • Use advanced cross-tab techniques in reports.
  • Graph single and multiple data series

Audience?

Report designers who want to further develop their basic report design skills using Crystal Reports.

Course Contents


Recap

  • Course Files & Report Types reviewed
  • Default Options & Settings

Formulas

  • Understanding formula language & syntax
  • Using functions and operators
  • Using variables
  • Creating, Declaring, & Assigning Formula Variables
  • Using control structure
  • Creating Running Totals

Multi-pass Reporting

  • Multi Pass Explained
  • Evaluation Time Functions
  • Using Multiple Variables

Parameters

  • Defining parameter fields
  • Referencing a parameter
  • Responding to a parameter
  • Using values
  • Deleting parameters
  • Using Parameter Fields to select records
  • Parameter Fields – to sort records & set conditional formats

Advanced Formatting (Conditional)

  • Conditional On/Off Formatting
  • Conditional Attribute Formatting

Grouping

  • Applying specified order grouping
  • Using the Group Sort Expert
  • Creating a group selection based on summary
  • Information
  • Grouping data hierarchically

Cross-tabs

  • Create a Cross-tab – using the Expert
  • Filter Cross-tab by group
  • Format Rows and Columns
  • Multi-Level Cross Tabs
  • Cross Tab Summary Operations
  • Cross Tabs & Parameter Fields / Formula Fields / Group Headers

Subreports

  • Insert & Edit a Subreport
  • Linked/Unlinked Subreports
  • Format a Subreport Object
  • Share Formulas Between Main and Subreports
  • Create an On-demand Subreport
  • Adding captions to subreports
  • Updating subreports
  • Using shared variables in a subreport

SQL/ODBC & SQL Designer

  • SQL Introduction & SQL Statements
  • ODBC Data Source Introduction
  • SQL Designer Introduction
  • Create a SQL Expression
  • Select Records on the Server
  • Write/Edit a SQL Query
  • Build a Report on a SQL Query
  • Create SQL Commands in the Crystal Report Environment

Crystal Dictionaries

  • Create a Crystal Dictionary

Charting Data

  • Modify/Format a Chart
  • Create a Top N Chart
  • Create a chart Template
  • Chart Data, Text and Calculations
  • Charts from Cross Tabs

Report Alerts

  • What Are Report Alerts
  • Creating, Modifying and using Alerts

Multiple Sections

  • Manipulating multiple sections, and general uses for multiple sections
  • General section formatting (Reviewed)

Course Materials

Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable. These may be either paper based or in Adobe pdf format or a combination thereof.

“Very good – trainer had a real mix of abilities in group & managed to engage everyone and ensure everyone went away having learnt plenty.”Very good – trainer had a real mix of abilities

Additional Information

NOTE: We only offer the SAP Crystal Reports 2020 Advanced course on a private in-house basis. For pricing and availability just pick up the phone and call us on 0845 1085481.

Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.

The suggested course duration is a guideline. Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.

Contact us to discuss your training needs...

0845 108 5481 0845 108 5481
info@enliten-it.com info@enliten-it.com