Course not currently available

Crystal Reports 2013 Advanced

Activia Training

Short course

In London ()

Price on request

The best Other Database courses

See all

See all

Description

  • Type

    Short course

  • Duration

    2 Days

Upon successful completion of this course, students will be able to:

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

About this course

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. Note: Knowledge of the modules and concepts covered in the Crystal Reports 14 (2011) Introduction course is required.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2018

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 15 years

Subjects

  • Crystal Reports
  • SQL
  • Cross-tab report
  • Subreport
  • Variables
  • Drill-down
  • Database
  • Charts
  • Dynamic image
  • Report alert

Course programme

MODULE 1: Creating Running Totals

Topics covered:
  • Create a Running Total Field
  • Modify a Running Total Field
  • Create a Manual Running Total
MODULE 2: Working with Cross-Tabs

Topics covered:
  • Create a Cross-Tab Report
  • Format a Cross-Tab Report
  • Create Groups in Cross-Tab Reports
MODULE 3: Adding Subreports

Topics covered:
  • Insert a Subreport
  • Edit a Subreport
  • Share Variables
MODULE 4: Creating Drill-Downs in a Report

Topics covered:
  • Create a Drill-Down
  • Create Headings for Drill-Down Data
MODULE 5: Using SQL Statements in Report Processing

Topics covered:
  • Create a Report Using SQL Queries
  • Summarise Report Data
  • Create Joins Using SQL
  • Create Subqueries
  • Create a SQL Expression Field
MODULE 6: Creating Complex Formulas

Topics covered:
  • Work with Loops
  • Work with Arrays
MODULE 7: Adding Charts to Reports

Topics covered:
  • 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
MODULE 8: Enhancing Report Functionality

Topics covered:
  • Organise Data Based on a Hierarchy
  • Create a Dynamic Image
  • Create a Report Alert
  • Create a Geographic Map

See related categories

Crystal Reports 2013 Advanced

Price on request

The best Other Database courses

See all

See all