SAP Crystal Reports XI - Level 1

 

Duration:  Instructor Led Learning – 2 Days

At Course Completion:


Upon successful completion of this course, delegate(s) will be able 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
  • Distribute report data

 

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
Export
ing
to a Microsoft Excel File
Export
ing
to an Access Database File
Export
ing a Report Definition (Criteria)

Creat
ing Mailing Labels from a Report

View Crystal Reports XI Advanced Outline

Crystal Reports XI Level 1 Outline.pdf Crystal Reports XI Level 1 Outline.pdf
Size : 183.892 Kb
Type : pdf