Crystal Reports Level 2

     

Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.

You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.

We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.

Please contact us to discuss this further on 0191 377 8377.

Review Exercises

Formatting sections for summary/drill-down
Creating formulas
Selecting, grouping and summarizing
Adding and linking databases
Creating a basic report

Conditional Formatting

Removing conditional formatting
Using the highlighting expert
Assigning conditional attribute formatting
Applying and removing conditional on/off formatting
Understanding the difference between absolute and conditional formatting

Advanced Formulas / Variables

Creating formulas using multiple variables
Using evaluation time functions
Understanding multiple pass reporting
Creating running totals
Using variables in formulas

SQL and Commands

Adding parameters to your own SQL statement
Defining your own SQL as the data source
Introduction to standard query language (SQL)

Parameter Fields

Using parameter fields to set conditional formats
Using parameter fields to specify sort criteria
Understand edit masks

Report Alerts

Viewing record sets created by use of alerts
Creating and using report alerts

Multiple Sections

Working with multiple sections and conditional formats
Moving, splitting and merging sections
Inserting and deleting sections

Subreports

Using variables to pass data from a sub report to the main report
Creating on-demand subreports
Formatting subreports
Inserting unlinked and linked subreports
Identifying when subreports are needed

Basic & Advanced Cross-Tabs

Using formula fields & parameter fields with cross tab reports
Formatting cross Tab components
Inserting multiple rows, columns and summarized fields
Creating basic and advanced cross tab reports

Charting

Creating basic, calculating and cross tab related charts
Formatting existing graphs
Chart types, layout options and using the Chart Expert

Training Options

What's Included