Tutorials – SAP Crystal Reports 2011 / 2013

Key Concepts

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

Getting Started

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

Connecting to Data Sources

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

Working with Charts

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

Working with Tables and Crosstabs

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

Selecting, Sorting, Grouping, and Summarizing Data

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

Setting up Interactive Elements

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

Working with Formulas

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

Working with Subreports

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

Applying Formatting

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

Distributing Output

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