SAP Crystal Reports - Beginning

Course Overview

In this module of SAP Crystal Reports - Beginning Level the user will learn how to:

• create a report by using data from an existing database,
• use a report to present specific data in the desired order,
• create groups to summarise report data,
• build formulas to calculate and display data,
• format reports,
• add and modify elements in a report,
• create single data series charts, and
• distribute report data.

Duration:  

Instructor Led Learning – 2 Days

Crystal Reports XI Level 1 Outline:

Lesson 1: Creating a Report

Setting Default Report Settings 
Specifying Fields for a New Report 
Previewing a Report 
Modifying Field Display 
Adding a Report and Page Titles 
Positioning Fields on the Grid
Adding Fields from Other Supporting Tables

 Lesson 2: Displaying Specific Report Data

Finding and Replacing Data 
Sorting Data 
Filtering Data by a Single or Multiple Criteria

Lesson 3: Grouping Report Data

Inserting a Group 
Adding Calculated Summaries 
Formatting Summary Information 
Changing Group Options 
Adding Second-Level Grouping 
Filtering Records by Groups 
Creating a ‘Top 5, Top N’ Sort Group

 Lesson 4: Building Formulas

Creating a Formula 
Editing a Formula 
Combining Fields by Formula 
Deleting a Formula 
Filtering Data by Multiple Criteria 
Modifying  a Filter Using an ‘OR’ Statement 
Creating Parameter Fields for Advanced Filtering 
Accounting for Null Fields in a Formula

Lesson 5: Formatting Reports

Removing White Space in a Report 
Inserting Page Header and Footer Data 
Adding Borders, Boxes, and Lines 
Changing Field Font and Background Colours
Changing the Margins on a Report

 Lesson 6: Using Report Options 

Adding a Watermark 
Inserting Objects Using Object Linking and Embedding 
Modifying Formatting Based on Data Value 
Suppressing Report  and Data Sections 
Inserting Hyperlinks into a Report
Hiding Blank Report Sections

Lesson 7: Creating Bar and Pie Charts

Creating a Bar or Pie Chart with a Drill-Down 
Modifying Chart Text 
Formatting Charts and Utilising Chart Options
Presenting a Chart by Group 

Lesson 8: Distributing Data to Other File Types  

Exporting to a Adobe .pdf File 
Exporting to a Microsoft Excel File 
Exporting to an Access Database File 
Exporting a Report Definition (Criteria)
Creating Mailing Labels from a Report