SAP Crystal Reports complete

Crystal Reports Basics

Crystal Reports Overview - Product Structure - User Interface Overview

Planning Crystal Reports - Understanding Database Concepts - Planning and Creating a Crystal Reports Report Prototype

Creating Reports with Crystal Reports - Connecting to a Data Source - Adding Tables - Inserting Objects - Viewing and Saving - Arranging Objects - Formatting Objects

Selecting records in Crystal Reports - Getting to know the Crystal Reports Record Selection Wizard - Applying saved and updated data - Modifying record selections - Setting time-based record selections

Organizing data with Crystal Reports - Sorting data - Grouping data - Calculating results

Format Crystal Reports - Add Graphical Elements - Combine Text Objects with - Database Fields - Apply Special Formatting - Add Special Fields

Apply Crystal Reports range formatting - Format ranges - Create a summary report

Formulas in Crystal Reports - Learn formulas - Create formulas - Boolean formulas - If-Then formulas - Date calculations - Number calculations - String manipulation

Conditional formatting in Crystal Reports - Crystal Reports Highlighting wizards - Formatting formulas

Visualizing data with Crystal Reports - working with charts - creating charts - formatting charts

Publishing reports in Crystal Reports - Exporting a report - Saving a report in Crystal Enterprise

Crystal Reports Structure

Group sorting in Crystal Reports - Sorting groups - Printing a specific number of items - Troubleshooting group sorting

Creating crosstab reports in Crystal Reports - Crosstab objects - Summarizing a group using a crosstab - Formatting crosstab objects - Changing the width and height of crosstab cells - Suppressing selected crosstab data - Printing crosstabs across multiple pages

Inserting formulas into reports with Crystal Reports - Overview of formulas - Functions - Formula Editor - Formula Wizard - SQL Expression Editor - Selection formulas - Formatting formulas - Formulas - Data types - Range data types - Array data types - Variables in formulas - Declaring variables - Control structures (If-Then-Else, Select Case, For loop, While-Do loop, Do-While loops)

Working with sub-reports in Crystal Reports - Connecting reports - Arranging reports - Drilldown function - Sharing data between reports

Connecting Crystal Reports report elements using OLE - What is OLE? - Static OLE objects - Embedded objects - Linked objects - Embedding or linking a file as an OLE object - Embedding or linking objects from files - Editing OLE objects

OLAP Reports and Data Warehouse Reports at Crystal Reports - What is OLAP? - Creating Multidimensional Views - OLAP Reporting with Crystal Reports - Creating a Multidimensional Report - Updating OLAP Reports

Enhancing reports with charts in Crystal Reports - The different chart types - Different chart layouts for different data types - The chart wizard - Creating a chart - Using the drilldown function in a chart - Positioning chart elements

Adding charts to Crystal Reports - Charts in Crystal Reports - Chart layout - Chart types - Chart positioning - Inserting charts into subreports - Modifying charts

Publishing Crystal Reports reports - Distributing reports - Printing a report - Faxing a report - Exporting a report

Viewing reports online at Crystal Reports - Exporting to an HTML page - Working with hyperlinks - Crystal Launchpad and ePortfolio - Crystal Report Viewer - Crystal Publishing Wizzard - Report components and navigation

Using report templates - Using report templates - Creating a report template - Removing a template from a report

Creating parameterized Crystal Reports - Learning about and creating parameters - Using multiple parameters in a report - Using input masks and descriptions - Creating a parameter for date ranges - Controlling sorting and grouping with parameters

Using variables and arrays in Crystal Reports - Using variables - Using arrays

Windows basic knowledge

We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.

• Implementation guarantee - Implementation guarantee for two or more participants
• Mobile classrooms - the ideal complement for company seminars
• Free support - for questions after the seminar
• Delivery on account - no prepayment required
• Interview with the trainer / quality assurance - get to know and assess the trainer in advance
• Clarify seminar requirements - review your knowledge with the trainer
• Assistance with travel costs - we cover part of the costs of hotel accommodation
• Meals - all day cold / hot drinks and a full lunch in the restaurant
• Location of training centres - always centrally located and easily accessible
• Discount - we have attractive prices, take advantage of our additional discounts
• Remotelabs - rent our Remotelabs for your own seminars or as a complement to your company seminars