Information Technology

Crystal Reports 2016 - Part 2

Instructor-Led 9 Agenda

Description

In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency.

Course Overview

Course Objective

In this course, you will create complex reports using tools in Crystal Reports 2016. 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.

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.

Creating Running Totals Lesson Id 1

Creating Running Totals

Working with Cross-Tabs Lesson Id 2

Working with Cross-Tabs

Adding Subreports Lesson Id 3

Adding Subreports

Creating Drill-Downs in a Report Lesson Id 4

Creating Drill-Downs in a Report

Using SQL Statements in Report Processing Lesson Id 5

Using SQL Statements in Report Processing

Creating Complex Formulas Lesson Id 6

Creating Complex Formulas

Adding Charts to Reports Lesson Id 7

Adding Charts to Reports

Enhancing Report Functionality Lesson Id 8

Enhancing Report Functionality

Appendix Lesson Id 9

Appendix

Lesson Id	Title	Description
1	Creating Running Totals	Topic A: Create a Running Total Field<br />Topic B: Modify a Running Total Field<br />Topic C: Create a Manual Running Total
2	Working with Cross-Tabs	Topic A: Create a Cross-Tab Report<br />Topic B: Format a Cross-Tab Report<br />Topic C: Create Groups in Cross-Tab Reports
3	Adding Subreports	Topic A: Insert a Subreport<br />Topic B: Edit a Subreport<br />Topic C: Share Variables
4	Creating Drill-Downs in a Report	Topic A: Create a Drill-Down<br />Topic B: Create Headings for Drill-Down Data
5	Using SQL Statements in Report Processing	Topic A: Create a Report Using SQL Queries<br />Topic B: Summarize Report Data<br />Topic C: Create Joins Using SQL<br />Topic D: Create Subqueries<br />Topic E: Create an SQL Expression Field
6	Creating Complex Formulas	Topic A: Work with Loops<br />Topic B: Work with Arrays
7	Adding Charts to Reports	Topic A: Create Charts<br />Topic B: Create a Chart with Drill-Down<br />Topic C: Create a Top N Chart<br />Topic D: Create a Cross-Tab Chart<br />Topic E: Create Charts for Grouped Data<br />Topic F: Format a Chart<br />Topic G: Create a Chart Template
8	Enhancing Report Functionality	Topic A: Organize Data Based on a Hierarchy<br />Topic B: Create a Dynamic Image<br />Topic C: Create a Report Alert<br />Topic D: Create a Geographic Map
9	Appendix	Appendix A: Managing Reports<br />Appendix B: Processing Data on the Server<br />Appendix C: Detecting and Fixing Problems