Crystal Reports Certification | Crystal Reports Courses
Course
In Cardiff
Description
-
Type
Course
-
Location
Cardiff (Wales)
-
Duration
2 Days
-
Start date
Different dates available
The Knowledge Academy Courseware Book Experienced Instructor Certificate Refreshments
Facilities
Location
Start date
Start date
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 8 years
Subjects
- Programming
- Data Management
- Image
- Crystal Reports
- IT
- SQL
Course programme
Students will learn how to create advanced formulas and functions, format reports based on calculation results, use multiple sections, insert subreports, use data management features and advanced data access techniques.
Course Objectives
Create automatic and manual running totals
Work with cross-tab reports
Add subreports
Create drill-downs in a report
Use SQL statements in report processing
Create complex formulas
Add charts to reports
Enhance report functionality
Who Should Attend
This course is designed for people who know how to create basic list and group reports, and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience.
Pre-Requisites
Knowledge of the modules and concepts covered in the Crystal Reports 2011 Introduction course is required.
Course Outline
Creating Running Totals
- Create a Running Total Field
- Modify a Running Total Field
- Create a Manual Running Total
Working with Cross-Tabs
- Create a Cross-Tab Report
- Format a Cross-Tab Report
- Create Groups in Cross-Tab Reports
Adding Subreports
- Insert a Subreport
- Edit a Subreport
- Share Variables
- Creating Drill-Downs in a Report
- Create a Drill-Down
- Create Headings for Drill-Down Data
Using SQL Statements in Report Processing
- Create a Report Using SQL Queries
- Summarise Report Data
- Create Joins Using SQL
- Create Subqueries
- Create a SQL Expression Field
Creating Complex Formulas
- Work with Loops
- Work with Arrays
Adding Charts to Reports
- Create Charts
- Create a Chart with a Drill-Down
- Create a Top N Chart
- Create a Cross-Tab Chart
- Create Charts for Grouped Data
- Format a Chart
- Create a Chart Template
Enhancing Report Functionality
- Organise Data Based on a Hierarchy
- Create a Dynamic Image
- Create a Report Alert
- Create a Geographic Map
Additional information
- Welcome to the world's largest Crystal Reports training company
- Learn how to design & create powerful user-friendly business reports
- GUARANTEED LOWEST PRICE IN THE INDUSTRY
- Crystal Reports training includes course materials & course certificates
- Small class sizes for optimum delegate-trainer interaction
- Courses delivered by world class Crystal Reports instructors
- Enhance your knowledge by creating interactive dashboards using charts and graphs to improve your business performance
- Book Online or Call 01344 203999 to speak to a Crystal Reports training advisor today
Crystal Reports Certification | Crystal Reports Courses