/ Browse / Learning Journeys / Discovering SAP Crystal Reports / Sorting, Grouping, and Summarizing Data in a Report

Identifying Crystal Report Concepts

Describing Reporting Concepts
29 mins
Quiz

Creating a Report

Formatting Objects and Data in a Report

Sorting, Grouping, and Summarizing Data in a Report

Applying Record Selection

Formatting Sections

Using Basic Formulas

Using Charts

Using Functions and Formulas

Creating If-Then-Else Formulas
8 mins
Creating Boolean Formulas
7 mins
Creating Formulas with Dates
9 mins
Formatting Data Conditionally
20 mins
Quiz

Using Parameters

Using Advanced Grouping Techniques

Manipulating Multiple Sections

Knowledge quiz

It’s time to put what you’ve learned to the test, get 4 questions right to pass this unit.

How do you sort records on two different fields (for example, first by City, then by Sales)?

Choose the correct answer.

Combine both fields with Bind Sort Control

Sort on the primary field, then add a secondary sort

Sort on the secondary field first, then the primary field

Use Bind Sort Control on each field individually

Which types of summaries are only available for fields with a numeric data type?

There are two correct answers.

Count

Maximum

Average

Mode

Sum

What happens when you add a group based on an existing field in the details section?

There are two correct answers.

Records are sorted by the grouped field first

The Field object is removed from Details section

The Field Heading is removed from the Page Header

A Group Header with a Group Name is created

A Group Footer with subtotals is created

In which sections can you place a grand total summary field?

Choose the correct answer.

Page Header or Footer

Report Header or Footer

Group Header or Footer

Details

What happens to objects in the Group Header when you delete a group in the Group Expert?

Choose the correct answer.

All objects are moved to Details section

All objects are moved to the Page Header

They are deleted from the report

Field objects are moved to the Details, Text objects are moved into the Page Header

Learning