Official Product Tutorials – SAP Crystal Reports

The following tutorials have been developed to help you get started using the Business Intelligence Suite products. New content is added as soon as it becomes available, so check back on a regular basis.

Are there topics we've missed or things we can improve? Submit new ideas or vote on existing ones to help us better address your learning needs for the BI Suite of products.

Looking for eLearning for the rest of the Business Intelligence Suite? Go to sap.com/LearnBI.

Key Concepts

• NEW  Concept: What's new in SAP Crystal Reports 2011 (2:16)    interactive / video
• Concept: Navigate the interface (6:46)    interactive / video
• Concept: Create a report (2:48)    interactive / video
• Concept: Share report objects with other designers (2:09)    interactive / video
• Concept: Describe how the semantic layer works (2:08)    interactive / video
• Concept: Compare Crystal Reports 2011 and Crystal Reports for enterprise    interactive

Getting Started

• Connect to an ODBC data source (2:13)    interactive / video
• Change the layout of the interface (1:06)    interactive / video
• View the data for a field (1:08)    interactive / video
• Add fields to a report (1:20)    interactive / video
• Preview a report (0:57)    interactive / video
• Refresh the data in a report (0:50)    interactive / video
• Save a report (1:20)    interactive / video
• Save a snapshot of a report (1:21)    interactive / video
• Save a report to the Business Intelligence platform (1:47)    interactive / video
• Export a report (2:24)    interactive / video
• Share report objects using the Repository Explorer (1:46)    interactive / video

Connecting to Data Sources

• Connect to an SAP BW data source (3:29)     interactive / video
• Connect to a universe (2:27)     interactive / video
• Connect to an XML data source (2:51)     interactive / video
• Connect to a web service (3:43)     interactive / video
• Link data source tables (2:03)     interactive / video
• Change the data source location (2:11)     interactive / video
• Connect to an SAP ERP data source (2:58)     interactive / video
• Connect to an Excel spreadsheet or a text file (1:41)     interactive / video
• Connect to an OLAP data source and create an OLAP grid report (4:26)     interactive / video
• Create a connection to SAP HANA using ODBC drivers (2:43)     interactive / video

Working with Charts

• Create a chart for summary data (1:37)    interactive / video
• Create a chart for detail data (2:19)    interactive / video
• Change the formatting of a chart (2:31)    interactive / video

Working with Tables and Crosstabs

• Create a crosstab (2:25)    interactive / video
• Create a crosstab using the Crosstab Wizard (2:24)    interactive / video
• Add a calculation to a crosstab (2:25)    interactive / video
• Change the formatting of a crosstab (1:53)    interactive / video
• Conditionally format cells in a crosstab (2:16)    interactive / video

Selecting, Sorting, Grouping, and Summarizing Data

• Select the data that appears in a report (1:12)    interactive / video
• Edit the formula for record selection (1:46)    interactive / video
• Sort the records in a report (0:54)    interactive / video
• Sort records using a sort control (2:34)    interactive / video
• Group records based on data (1:11)    interactive / video
• Group records based on a custom definition (2:28)    interactive / video
• Change the grouping order (1:13)    interactive / video
• Select groups based on a summary (1:47)    interactive / video
• Calculate totals and subtotals for data (02:00)      interactive / video
• Create a running total (2:03)    interactive / video
• Show the top or bottom N records in a report (1:22)    interactive / video
• Create a summary report (1:31)    interactive / video

Setting up Interactive Elements

• Prompt for a value to select records (2:20)    interactive / video
• Display the prompt value used to select records (1:36)    interactive / video
• Prompt for multiple values to select records (2:56)    interactive / video
• Prompt for a DateTime range to select records (3:14)    interactive / video
• Create a cascading prompt to select records (4:30)    interactive / video
• Group records based on a prompt value (4:05)    interactive / video
• Create an alert (2:11)    interactive / video
• Add a SWF file to a report (1:06)    interactive / video
• Create a hyperlink to open a document in the BI platform (4:48)     interactive / video

Working with Formulas

• Create a formula (2:54)    interactive / video
• Create a Boolean formula (2:04)    interactive / video
• Create a conditional formula (2:36)    interactive / video
• Create a formula to calculate numbers (2:09)    interactive / video
• Create a formula to calculate a time interval (2:40)    interactive / video
• Create a formula to change text (2:36)    interactive / video
• Use variables in a formula (3:19)    interactive / video

Working with Subreports

• Add an existing report as a subreport (1:41)    interactive / video
• Change the formatting of a subreport (1:46)    interactive / video

Applying Formatting

• Resize, move, and align fields in a report (1:30)    interactive / video
• Position objects using guidelines (1:45)    interactive / video
• Add text to a report (1:21)    interactive / video
• Add a graphic to a report (0:49)    interactive / video
• Add a dynamic graphic to a report (2:41)    interactive / video
• Add a hyperlink to a report (1:31)    interactive / video
• Add a watermark to a report (2:18)    interactive / video
• Add document information fields (1:41)    interactive / video
• Add a line or box to a report (1:18)    interactive / video
• Format the fields in a report (2:18)    interactive / video
• Copy the formatting of an object (1:40)    interactive / video
• Conditionally format data using the Highlighting Expert (1:30)    interactive / video
• Conditionally format data using the Format Editor (1:44)    interactive / video
• Customize an existing formatting style (2:03)    interactive / video
• Change the formatting for a report section (0:59)    interactive / video
• Conditionally format a report section (2:09)    interactive / video
• Create a subsection in a report (1:40)    interactive / video
• Embed database fields into a text object (2:12)    interactive / video
• Apply a report template (2:01)    interactive / video
• Create a report template without a data source (5:02)    interactive / video

Distributing Output

• Create a project in the Workbench (1:39)    interactive / video
• Publish an object package to the BI platform (1:54)    interactive / video

To view the full SAP Crystal Reports 2011 playlist on Youtube, click here.

To report a technical issue with a tutorial, send an email to: BI_Suite_eLearning@sap.com.

Additional Recommended Content

• SAP Crystal Reports Introductory Series: Creating a Blank Report
• SAP Crystal Reports Introductory Series: Formatting
• SAP Crystal Reports Introductory Series: Formulas
• SAP Crystal Reports Introductory Series: Sorting, Grouping, and Totalling
• SAP Crystal Reports Introductory Series: The Report Wizard
• Wiki: Comparing Crystal Reports 2011 and Crystal Reports for Enterprise