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