Alpha Training Developing your people to grow your business

Telephone 020 8658 6994
Request a call back
Email us This email address is being protected from spambots. You need JavaScript enabled to view it.
Follow us on  Facebook   Twitter   LinkedIn

Information Technology

Learn how to use Crystal Reports to view, design, and deliver consolidated reports from virtually any data source. Lay out reports with flexible web viewing and pre-built graphs. And, embed reports into Microsoft and other applications to share information quickly.

Print

Crystal Reports 10 Advanced

Course length

2 days

Why come on this course?

In this course you’ll learn how to use Crystal Reports 10 to create more sophisticated reports in like subreports and cross-tabs, and you’ll also learn how to increase the speed and efficiency of your reports by using SQL queries and dictionaries.

Who is it for?

This course is designed for people who know how to create a 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. You may also need to build tools to make it easier for other people to create reports. You should first attend the Crystal Reports 10 Introduction or have similar knowledge and experience.

What will I learn?

By the end of this course you will be able to:

  • Create running totals in a report
  • Build cross-tabs in your report
  • Add subreports to a report
  • Design a report that uses a drill-down
  • Improve processing speed in your reports
  • Chart single and multiple data series
  • Report from Excel data

Course contents

Creating Running Totals

  • Create a Running Total Field
  • Modify a Running Total Field
  • Create a Manual Running Total on Detail Data
  • Create a Manual Running Total on Summary Data

Building Cross-tabs in Your Report

  • Create a Cross-tab
  • Create a Specified Group Order
  • Filter a Cross-tab by Group
  • Change the Cross-tab Format
  • Conditionally Format Rows and Columns
  • Keep Groups Together

Adding Subreports

  • Insert a Subreport
  • Link a Subreport to Data in a Primary Report
  • Edit a Subreport
  • Format a Subreport Using the Format Editor
  • Share Formulas Between Main and Subreports
  • Create an On-demand Subreport

Creating Drill-downs

  • Create a Drill-down
  • Create Separate Headings for Drill-down Data

Enhancing Report Processing Using SQL

  • Create a Report Using SQL Queries
  • Summarise Report Data Using SQL Aggregate Functions
  • Create Joins Using SQL
  • Create Subqueries
  • Create an SQL Expression Field to Promote Server-side Processing

Charting Data

  • Create a Bar Chart
  • Modify a Chart
  • Create a Top N Chart
  • Format a Chart
  • Create a Chart Template

Reporting on 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
Print

Crystal Reports 10 Introduction

Course length

2 days

Why come on this course?

In this course you will learn how to use Crystal Reports 10 to build a basic list and group reports that work with almost any database.

Who is it for?

This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, and/or they may not have access to those tools. You must be able to use Windows and have a basic understanding of database principles, experience of using data manipulation software such as Microsoft Access or Microsoft Excel.  Prior knowledge of SQL is desirable, but not essential.

What will I learn?

By the end of this course you will be able to:

  • Create a report by using data from an existing database
  • Locate and present data in a specified order
  • Create groups to summarise report data
  • Build formulas to add non-database data to a report and display data differently
  • Format reports
  • Enhance reports by adding and modifying elements in a report
  • Create single data series charts
  • Distribute report data to other users

Course contents

Creating a Report

  • Set Default Report Settings
  • Specify Fields for a New Report
  • Preview the Report
  • Modify Field Display
  • Add a Report Title
  • Position Fields
  • Add Fields from Additional Tables

Displaying Specific Report Data

  • Find Data
  • Sort Data
  • Filter Data by Single Criteria

Grouping Report Data

  • Insert a Group
  • Add Summaries
  • Format Summary Information
  • Change Group Options
  • Add an Additional Group
  • Filter by Group
  • Create a Top N Sort Group

Building Formulas

  • Write a Formula
  • Edit a Formula
  • Group by Formula
  • Delete a Formula
  • Build a Filter by Multiple Criteria
  • Modify a Filter with Multiple Criteria to Create an OR Condition
  • Create a Parameter Field
  • Write a Formula that Incorporates Null Fields

Formatting Reports

  • Remove White Space
  • Insert Page Header/Footer Data
  • Add Borders and Lines
  • Change the Background Colour
  • Change the Margins

Enhancing Reports

  • Create a Section to Contain a Watermark
  • Insert Objects Using Object Linking and Embedding
  • Modify Format Based on Data Value
  • Conditionally Suppress Data
  • Insert Hyperlinks
  • Hide Blank Report Sections

Creating and Modifying Pie Charts

  • Create a Pie Chart with a Drill-down
  • Modify Chart Text
  • Format a Chart
  • Present a Chart by Group

Distributing Data

  • Export to PDF
  • Export to Excel
  • Export to an Access Database
  • Create a Report Definition
Print

Crystal Reports 11 Advanced

Course length

2 days

Why come on this course?

Now that you have completed the first course, or are familiar with the basics of building and modifying reports, you’re ready to move ahead to create complex reports and data sources using Crystal Reports’ tools. In this course, you’ll not only learn how to create more sophisticated reports including subreports and cross-tabs, but you’ll also learn how to increase the speed and efficiency of your reports by using SQL queries.

Who is it for?

  • Create a basic report
  • Create a connection to a data source
  • Make simple modifications to an existing report
  • Use basic formatting techniques
  • Create Groups in a Report
  • Create Sub-Totals & Grand Totals in a Report
  • Create basic formulas
  • Perform simple filters & sorts

What will I learn?

By the end of this course you will:

  • Create running totals in a report.
  • Build cross-tabs in your report.
  • Add subreports to a report.
  • Design a report that uses a drill-down.
  • Improve processing speed in your reports.
  • Chart single and multiple data series.
  • Report from Excel data.
  • Implement report prompts.
  • Enhance report functionality.

Course contents

Creating Running Totals

  • Create a Running Total Field
  • Modify a Running Total Field
  • Create a Manual Running Total on Detail Data
  • Create a Manual Running Total on Summary Data

Building Cross-tabs in Your Report

  • Create a Cross-tab
  • Create a Specified Group Order
  • Filter a Cross-tab by Group
  • Change the Cross-tab Format
  • Conditionally Format Rows and Columns
  • Keep Groups Together 

Adding Subreports

  • Insert a Subreport
  • Link a Subreport to a Primary Report
  • Edit a Subreport’s Structure
  • Format a Subreport Using the Format Editor
  • Share Variables Between Subreports and Primary Reports
  • Create an On-demand Subreport 

Creating Drill-downs

  • Create a Drill-down
  • Create Separate Headings for Drill-down Data

Enhancing Report Processing by Writing SQL Statements

  • Create a Report Using SQL Queries
  • Summarise Report Data Using SQL Aggregate Functions
  • Create Joins Using SQL
  • Create Subqueries
  • Create a SQL Expression Field

Charting Data

  • Create a Bar Chart
  • Modify a Chart
  • Format a Chart
  • Create a Chart Template
  • Create a Top N Chart
  • Create a Cross-tab Chart 

Reporting on Excel Data with Crystal Reports

  • Create a Report Based on Excel Data
  • Modify a Report Generated from Excel Data
  • Update Data in a Report Based on Excel Data

Working with Prompts

  • Create a Static Prompt
  • Create a Dynamic Prompt 

Enhancing Report Functionality

  • Group Data Hierarchically
  • Create a Dynamic Image
  • Create a Report Alert
  • Create a Geographic Map
Print

Crystal Reports 11 Introduction

Course length

2 days

Why come on this course?

In this course you will learn how to use Crystal Reports 11 to build basic list and group reports that work with almost any database.

Who is it for?

This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, and/or they may not have access to those tools. You must be able to use Windows and have a basic understanding of database principles, experience of using data manipulation software such as Microsoft Access or Microsoft Excel.  Prior knowledge of SQL is desirable, but not essential.

What will I learn?

By the end of this course you will:

  • Create a report by using data from an existing database
  • Use a report to present specific data in the desired order
  • Create groups to summarise report data
  • Build formulas to calculate and display data
  • Format reports
  • Add and modify elements in a report
  • Create single data series charts
  • Distribute report data

Course contents

Creating a Report

  • Set Default Report Settings
  • Specify Fields for a New Report
  • Preview a Report
  • Modify Field Display
  • Add a Report Title
  • Position Fields
  • Add Fields from Other Tables 

Displaying Specific Report Data

  • Find Data
  • Sort Data
  • Filter Data by a Single Criterion 

Grouping Report Data

  • Insert a Group
  • Add Summaries
  • Format Summary Information
  • Change Group Options
  • Add a Second-Level Grouping
  • Filter Records by Group
  • Create a Top N Sort Group 

Building Formulas

  • Create a Formula
  • Edit a Formula
  • Combine Fields by Formula
  • Delete a Formula
  • Filter Data by Multiple Criteria
  • Modify a Filter Using an OR Operator
  • Create a Parameter Field
  • Account for Null Fields in a Formula 

Formatting Reports

  • Remove White Space
  • Insert Page Header/Footer Data
  • Add Borders, Boxes, and Lines
  • Change Field Background Color
  • Change the Margins 

Enhancing Reports

  • Add a Watermark
  • Insert Objects Using Object Linking and Embedding
  • Modify Formatting Based on Data Value
  • Suppress Report Sections
  • Insert Hyperlinks
  • Hide Blank Report Sections 

Creating Pie Charts

  • Create a Pie Chart with a Drill-Down
  • Modify Chart Text
  • Format a Chart
  • Present a Chart by Group

Distributing Data

  • Export to a PDF File
  • Export to a Microsoft Excel File
  • Export to an Access Database File
  • Export a Report Definition
  • Create Mailing Labels
Print

Crystal Reports 2008 Advanced

Course length

2 days

Why come on this course?

In this course you will learn how to use the advanced functionality of Crystal Reports to generate reports in the format you desire. You will create complex reports and data sources using Crystal Reports tools. You will not only create more sophisticated reports including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries.

Who is it for?

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. You may also need to build tools that make it easier for other people to create reports. You should first attend the Crystal Report 2008 Introduction or have similar knowledge and experience.

What will I learn?

By the end of this course you will:

  • 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

Course contents

  • Creating Running Totals
  • Working with Cross-Tabs
  • Adding Subreports
  • Creating Drill-Downs in a Report
  • Using SQL Statements in Report Processing
  • Creating Complex Formulas
  • Adding Charts to Reports
  • Enhancing Report Functionality 

Appendix A: Managing Reports

Appendix B: Processing Data on the Server

Appendix C: Detecting and Fixing Problems