Crystal Reports 2013 Level 1 — A 2 day course

Synopsis

This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, and/or such tools may not be accessible. Organisations use reporting tools to access data sources and generate customised reports. SAP Crystal Reports 2013 enhances report building and report processing techniques with a wealth of features that add value to your presentation. In this course, you will create a basic report by connecting to a database and modifying its presentation.

Students may or may not have programming and/or SQL experience.

Please Note

Crystal Reports has had multiple software versions released over the years. Please check that the version you are using matches to the course you will be attending: v10 and v11 were both released in 2003, thereafter versions 2008, 2011 and 2013 were released in the same year as their name.

Objectives

Delegates will learn how to:-

Explore the Crystal Reports interface

Create a basic report and modify it

Use formulas to calculate and filter data

Build a parameterised report

Group report data

Enhance a report

Create a report using data sourced from an Excel database

Distribute data

Contents

Exploring the SAP Crystal Reports 2013 Interface

Explore Crystal Reports

Use Crystal Reports Help

Customise the Report Settings

Working with Reports

Create a Report

Modify a Report

Display Specific Report Data

Work with Report Sections

Using Formulas in Reports

Create a Formula

Edit a Formula

Filter Data Using a Formula

Work with Advanced Formulas and Functions

Handle Null Values

Building Parameterised Reports

Create a Parameter Field

Use a Range Parameter in a Report

Create a Prompt

Grouping Report Data

Group Report Data

Modify a Group Report

Group by Using Parameters

Create a Parameterised Top N Report

Enhancing a Report

Format a Report

Insert Objects in a Report

Suppress Report Sections

Use Report Templates

Creating a Report from Excel Data

Create a Report Based on Excel Data

Modify a Report Generated from Excel Data

Update Data in a Report Based on Excel Data

Distributing Data

Export Data

Create Mailing Labels

Publicly scheduled dates, locations, and prices

A schedule of dates for this subject is not currently available. Please call 0333 210 0140 or use our contact form to enquire about places and availability.

Suitable For

This course is designed for people who need output from a database.

Follow-on Course

Prerequisites

Use a mouse

Type and use a keyboard

Navigate through Windows, organise folders and files

Work with Windows - Minimise, Maximise, Open, Close

A basic understanding of database principles, including: relationships between tables; joins and primary keys; experience of using data manipulation software, such as Microsoft Access or Microsoft Excel