lynda.com » lynda.com library » SAP » Crystal Reports 2011 Essential Training

Richard Downs

Crystal Reports 2011 Essential Training

with Curt Frye

This course shows business analysts how to use SAP Crystal Reports 2011 to analyze and summarize data to make better decisions. Author Curt Frye teaches how to maximize the power of Crystal Reports and import and analyze data from a variety of places, including Excel, Access, HTML/XML files, and more. The course also shows you how to define and manage reports, summarize data, visualize data using charts, focus analysis by selecting which data a report summarizes, export report data, and connect to external data sources.

Topics include:

Navigating within a report
Creating a report
Linking to a data source
Adding fields to a report
Creating sections in a report
Sorting, grouping, and summarizing data
Applying a template
Applying formats to date fields and other report controls
Managing images and drawing objects
Creating charts
Selecting records
Using formulas
Adding subreports
Working with cross-tabs
Exporting report data

show more show less

author: Curt Frye
subject: Business, Charts + Graphs, Data Analysis
software: Crystal Reports 2011
level: Beginner

duration: 3h 25m
released: May 31, 2012

Share this course

Learn more about lynda.com

Ready to join? get started

Members who watched this also viewed

Excel 2010 Essential Training

SQL Server 2008 Essential Training

Access 2010 Essential Training

SQL Essential Training

JavaScript Essential Training

HTML Essential Training

Foundations of Programming: Databases

PHP with MySQL Essential Training (2007)

WordPress Essential Training

Foundations of Programming: Fundamentals

expand all | collapse all

viewed duration

Introduction 2m 10s

Welcome 1m 9s

Using the exercise files 1m 1s

1. Getting to Know Crystal Reports 2011 20m 2s

Exploring the Crystal Reports user interface 3m 2s

Setting program options 2m 45s

Setting report options 2m 1s

Assigning report properties 2m 9s

Navigating within a report 2m 5s

Adding page numbers and printing 2m 47s

Changing page layout 2m 48s

Getting help in Crystal Reports 2011 2m 25s

2. Creating a Report 15m 54s

Using the Standard Report Creation Wizard 4m 35s

Linking to a data source 2m 26s

Linking to a source with multiple tables 3m 29s

Adding fields to a report 2m 15s

Saving a report 3m 9s

3. Managing Report Sections 12m 47s

Creating a section 1m 42s

Resizing a report section 1m 25s

Merging report sections 1m 42s

Managing section order 1m 52s

Hiding report sections 2m 15s

Creating multiple columns in a report 2m 23s

Deleting a section 1m 28s

4. Sorting and Grouping Data 23m 3s

Sorting data 3m 30s

Defining a group 2m 29s

Grouping data based on dates and times 2m 0s

Reordering and deleting groups 1m 54s

Changing group options 3m 17s

Creating a summary 2m 55s

Defining statistical summaries 1m 59s

Creating a drill-down report 2m 40s

Sorting by group 2m 19s

5. Formatting Reports and Report Elements 23m 45s

Applying a report template 1m 52s

Formatting a report control 3m 16s

Applying number formats to report controls 2m 39s

Applying formats to date fields 2m 37s

Resizing, aligning, and reordering objects 4m 1s

Managing images and drawing objects 3m 8s

Highlighting records 6m 12s

6. Adding Charts to a Report 16m 59s

Introducing available chart types 4m 59s

Creating a chart 2m 25s

Creating a chart using the Group layout 3m 15s

Creating a chart using the Cross-Tab layout 2m 10s

Formatting chart elements 4m 10s

7. Selecting Records in a Report 13m 45s

Selecting records within a single field 3m 9s

Selecting records using multiple fields 2m 14s

Creating selection rules using the Or operator 2m 3s

Selecting records based on dates 4m 1s

Selecting records using formulas 2m 18s

8. Managing Reports Using Parameter Fields 16m 11s

Creating a parameter field by entering a list of values 5m 3s

Defining default parameter values 1m 55s

Defining multi-value parameter fields 2m 37s

Allowing dynamic parameters 3m 55s

Editing and deleting parameter fields 2m 41s

9. Summarizing Data Using Formulas 18m 15s

Introducing the Formula Workshop 4m 20s

Using functions in formulas 2m 56s

Adding if-then logic to formulas 3m 22s

Adding case statements to formulas 4m 26s

Correcting formula errors 3m 11s

10. Adding Subreports 14m 30s

Creating an unlinked subreport 3m 39s

Creating a linked subreport 3m 29s

Creating an on-demand subreport 3m 32s

Formatting subreports 3m 50s

11. Summarizing Data Using Cross-Tabs 16m 32s

Creating and manipulating a cross-tab 4m 35s

Sorting cross-tab group values 3m 10s

Adding summary fields to a cross-tab 2m 20s

Adding a formula field to a cross-tab 3m 6s

Formatting a cross-tab 3m 21s

12. Exporting Report Data 11m 1s

Exporting to Excel 2m 32s

Exporting a report to Word using an RTF file 1m 33s

Exporting a report to a CSV file 2m 36s

Exporting a report to a web file 2m 16s

Exporting a report to an XML file 2m 4s

Conclusion 53s

Additional resources 53s

Suggested courses to watch next:

Access 2010 Essential Training (3h 30m)
Alicia Katz Pollock

SQL Server 2008 Essential Training (6h 54m)
Simon Allardice

Excel 2010 Essential Training (6h 21m)
Bob Flisser

Access 2010 Power Shortcuts (3h 43m)
Alicia Katz Pollock

You must be a lynda.com member to watch this video.

Every course in the lynda.com library contains free videos that let you assess the quality of our tutorials before you subscribe—just click on the blue links to watch them. Become a member to access all 104,069 instructional videos.

get started

learn more

If you are already an active lynda.com member, please log in to access the lynda.com library.

Get access to all lynda.com videos

You are currently signed into your admin account, which doesn't let you view lynda.com videos. For full access to the lynda.com library, log in through iplogin.lynda.com, or sign in through your organization's portal. You may also request a user account by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.

Get access to all lynda.com videos

How to access this video.

If this course is one of your five classes, then your class currently isn't in session.

If you want to watch this video and it is not part of your class, upgrade your membership for unlimited access to the full library of 2,024 courses anytime, anywhere.

learn more upgrade

You can always watch the free content included in every course.

Questions? Call Customer Service at 1 1 (888) 335-9632 or email cs@lynda.com.

Crystal Reports 2011 Essential Training

with Curt Frye

Share this course

table of contents

exercise files

transcript

author

preferences

FAQs

Suggested courses to watch next:

Bookmark this Tutorial

Name

Description

Tags

bookmark this course

Create new playlist

You must be a lynda.com member to watch this video.

Get access to all lynda.com videos

Get access to all lynda.com videos

Access to lynda.com videos

How to access this video.

You don't have access to this video.

Need help accessing this video?

Try our new course pages

name:
description:
	save cancel