/
Browse/
Courses/
Exploring Advanced Reporting Strategies in SAP Crystal Reports/
Using Functions and Formulas

/Home/Browse/Courses/ Exploring Advanced Reporting Strategies in SAP Crystal Reports/Using Functions and Formulas

Using Functions and Formulas

Creating If-Then-Else Formulas9 min
Creating Boolean Formulas8 min
Creating Formulas with Dates10 min
Formatting Data Conditionally29 min
Quiz

Using Parameters

Filtering Report Data with Parameters17 min
Filtering Data Range Using Parameters12 min
Enhancing Parameter Usability7 min
Manipulating Parameter Properties16 min
Quiz

Using Advanced Grouping Techniques

Managing Multiple Groups12 min
Sorting Groups Using Specified Order19 min
Grouping on Time-based Data8 min
Quiz

Manipulating Multiple Sections

Dividing a Report into Sections27 min
Using Advanced Section Formatting11 min
Quiz

Using Functions and Formulas

Creating If-Then-Else Formulas9 min
Creating Boolean Formulas8 min
Creating Formulas with Dates10 min
Formatting Data Conditionally29 min
Quiz

Using Parameters

Filtering Report Data with Parameters17 min
Filtering Data Range Using Parameters12 min
Enhancing Parameter Usability7 min
Manipulating Parameter Properties16 min
Quiz

Using Advanced Grouping Techniques

Managing Multiple Groups12 min
Sorting Groups Using Specified Order19 min
Grouping on Time-based Data8 min
Quiz

Manipulating Multiple Sections

Dividing a Report into Sections27 min
Using Advanced Section Formatting11 min
Quiz

Knowledge quiz

It's time to put what you've learned to the test, get 3 right to pass this unit.

1.

Which type of formula do you use with on/off formatting attributes?

Choose the correct answer.

Boolean

Nested If-Then-Else

Print State

Alphanumeric

2.

What is the default format for Boolean field?

Choose the correct answer.

Y/N

Yes/No

T/F

True/False

0/1

3.

Which functions do you use in a formula to calculate an employee’s years of service from their hire date?

There are two correct answers.

DatePart()

DateAdd()

DateDiff()

DateSerial()

CurrentDate()

4.

What should you remember when using If-Then-Else logic in formulas?

There are two correct answers.

The Else part of the syntax is mandatory

All result data types must match

The condition must be a Boolean expression

The result must be Boolean data type