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

Tutorials – SAP BusinessObjects Web Intelligence 4.x


Key Concepts
  • What’s new in Web Intelligence 4.1 SP6 (5:49)      video
  • What’s new in Web Intelligence 4.1 SP5 (1:40)      video
  • What’s new in Web Intelligence 4.1 SP4 (1:10)      video
  • What’s new in Web Intelligence 4.1 SP3 (1:37)      video
  • What’s new in Web Intelligence 4.1 SP2 (3:02)      video
  • What’s new in Web Intelligence 4.1 (5:27)      video
  • What’s new in Web Intelligence 4.0 SP5 (2:04)      video
  • What’s new in Web Intelligence 4.0 Feature Pack 3 (4:20)      video
  • What’s new in Web Intelligence 4.0 (6:25)      video
  • Navigate the interface (6:24)      video
  • Concept: Describe how the semantic layer works (1:35)     video
Getting Started
  • NEW for 4.1 SP5  Scenario: Creating reports with tables, charts and images* (9:35)     video
  • Create a query (1:24)     video
  • Run and save a query (1:30)     video
  • Edit a query (0:59)    video
  • View or change the properties for a query (1:06)    video
  • View the SQL or MDX script for a query (1:00)     video
  • Set up preferences for the Web Intelligence Rich Client interface (1:01)      video
  • View the properties of a document (1:20)    video
  • Drag and drop objects to create a report (1:33)     video
  • Duplicate a report object (1:19)     video
  • Add a report to a document (0:40)     video
  • Add a row or column in a table (0:56)      video
  • View the metadata for objects (0:32)      video
  • Publish a document to the repository (1:22)      video
  • Save a document as other formats (1:51)      video
  • Copy and paste content in Web Intelligence and other documents (2:01)    video
Connecting to Data Sources
  • Add another query to a document (1:22)      video
  • Change the data source on which a query is based (1:27)      video
  • Create a query based on an Excel file (0:58)      video
  • Combine multiple queries (2:20)      video
  • Create a query within a query (1:48)      video
  • Merge dimensions from different universes (1:47)     video
  • Connect to a web service (2:15)      video
  • Create a query based on an OLAP universe (1:45)      video
  • Connect to a BEx query with hierarchical data (1:32)      video
  • Connect to an Analysis view (1:11)     video
  • 4.0 FP3  Work with scaled values in BEx queries (1:59)      video
  • 4.0 FP3  Perform level or prompt member selection on hierarchical data (2:30)      video
  • 4.1  Work with hierarchy and hierarchy node variables in BEx queries (3:11)      video
  • 4.1  Set up query stripping for an SAP HANA data source (2:40)      video
Working with Tables and Crosstabs
  • Create a table (2:07)     video
  • Change the layout of a table (1:24)     video
  • Delete columns and rows from a table (1:05)    video
Working with Charts
  • Create a chart (1:51)      video
  • Turn a table into a chart (1:12)     video
  • Create a chart for hierarchical data (1:22)     video
  • 4.0 FP3  Create charts with hierarchical dimensions (1:31)     video
  • 4.1  Set default chart series colors (1:34)    video
  • 4.1 SP2  Format a data series in a chart (1:03)      video
Setting up   Elements
  • Add a hyperlink to a document (1:03)     video
  • Create a link between documents (DHTML client) (1:33)      video
  • Drill down into a table (2:48)      video
  • Drill down into a chart (2:11)     video
  • Fold and unfold sections in a document (1:09)    video
  • Create an input control for a document (1:46)   video
  • 4.0 FP3  Create an input control on a hierarchy (1:58)    video
Selecting, Sorting, Grouping, and Summarizing Data
  • Select a subset of data based on a predefined filter (1:00)      video
  • Select a subset of data based on a custom filter (1:16)     video
  • Remove a filter from a document (0:45)     video
  • Create a prompt to select a subset of data (1:31)     video
  • Select a subset of data based on multiple filters (2:17)       video
  • Define the order in which multiple filters are applied (2:07)       video
  • Create breaks between groups of data (0:55)     video
  • Calculate totals and subtotals for data (1:10)       video
  • Sort the data in a document (2:05)      video
  • Change the order and format of breaks between groups of data (1:53)     video
  • Select a subset of data in a report (0:59)     video
  • Add a ranking to data (1:01)      video
  • Divide a report into sections (1:22)      video
  • Calculate totals and subtotals for sections in a report (1:08)      video
  • Navigate a document using the Report Map pane (0:51)      video
  • Set a filter on a section or a block in a document (1:53)      video
  • Sort the sections in a document (0:56)     video
  • Create a prompt for hierarchical data (1:24)     video
  • Divide a report with hierarchical data into sections (1:01)      video
  • 4.0 FP3   Apply simple and complex sorting (1:44)    video
  • 4.1 SP2  Group the values of a dimension (1:43)       video
Working with Formulas
  • Create a formula to display a filter selection (1:48)      video
  • Create a formula to calculate a value (1:22)      video
  • Create a variable based on a formula (0:59)      video
Applying Formatting
  • Add text to a document (0:59)      video
  • Change the format of text or numbers in a document (0:54)     video
  • Track changes to data (1:28)     video
  • Conditionally format data based on defined thresholds (1:37)     video
  • Add a background to a document (1:22)     video
  • Add page numbers to a document (0:50)     video
  • Change the formatting for a table (1:50)     video
  • Change the formatting for a cell (2:21)    video
  • Change the formatting for sections (1:59)     video
  • Change the formatting for a chart  (5:04)     video
  • 4.0 FP3  Modify the default style sheet (2:30)     video
  • 4.0 FP3  Format charts (2:11)     video
  • 4.1  Freeze header rows or columns (0:56)      video
  • 4.1  Create a custom color palette (1:27)      video
  • 4.1  Change the locale settings for right-to-left document or interface layout (2:25)     video
Creating Documents for SAP BusinessObjects Mobile
  • Save documents for access in SAP BusinessObjects Mobile (2:09)      video
  • Format sparkline charts to display in SAP BusinessObjects Mobile (2:05)     video
  • Format trend or status icons to display in SAP BusinessObjects Mobile (3:48)      video
  • Format blank cells and images for SAP BusinessObjects Mobile (3:50)     video
  • 4.0 SP4  Select charts for display in SAP BusinessObjects Mobile (3:09)      video
  • 4.0 SP4  Link report elements using input controls (1:58)      video
  • 4.0 SP4  Format microcharts to display in SAP BusinessObjects Mobile (2:23)         video
  • 4.0 SP4  Format bullet charts to display in SAP BusinessObjects Mobile (3:05)    video
  • 4.0 SP4  Format geomaps to display in SAP BusinessObjects Mobile (3:15)     video
  • 4.1 SP3  Format geomap documents to display measure colors or conditional formatting in SAP BusinessObjects Mobile (2:43)     video
  • 4.1 SP3  Set a default view for a geomap document in SAP BusinessObjects Mobile (1:41)     video