Crystal Reports 2013 Level 1 — A 2 day course

Enquire about this 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

Suitable For

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

Follow-on Course

• Crystal Reports 2013 Level 2

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
• Prior knowledge of SQL is desirable, but not essential