Crystal Reports Level 2

Course Overview

During this course delegates will learn how to create advanced formulas, format reports based on calculation results (conditional formatting), use multiple sections, insert sub reports and access data from sources other than PC databases.
Prerequisites

• To ensure your success, we recommend that delegates first take the course Crystal Reports XI Level 1, or have equivalent knowledge.

Objectives

Delegates will be able to :

• Understand and control the calculation process used to compile your data.
• Control the appearance of your report using conditional format statements and multiple sections.
• Create parameter formulas that allow users to determine what data they want to see on a report.
• Enhance the analysis capability of your cross-tabs.
• Create formulas with multiple statements and use variables.
• Extend your reporting capacity by utilizing sub-reports.
• Access data from SQL/ODBC data sources, and generate queries using your own SQL statements.
• Create and edit graphical representations of your data using the Chart Expert or modify existing

Related Courses

• Crystal Reports Level 1 ()

Training Options

• Bespoke course (a course written to your specific needs) at your company office throughout the UK, at our training venue or at an independent location, convenient to you
• Private course at your company office throughout the UK, at our training room or at an independent location, convenient to you
• Scheduled public course at one of our training venues

Whats Included

• 12 Months telephone and email support
• Comprehensive colour course manual and exercises
• Use of a Modern Training suite with 19 inch flat screen monitors
• 1 delegate per computer
• Lunch (When at our training venue)
• Refreshments (When at our training venue)
• Relaxed refreshment area at our training room

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