SAP Crystal Reports Advanced

Group sorting in Crystal Reports - Sorting groups - Outputting a specific number of elements - 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 in 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 - Exchanging 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 with 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

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

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

Viewing reports online with 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

Crystal Reports Basics

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