EPIC CRYSTAL REPORTING/CLARITY/SQL CERTIFICATION TEST STUDY
GUIDE 2026 QUESTIONS BANK AND VERIFIED CORRECT SOLUTIONS
WITH RATIONALES || 100% GUARANTEED PASS RECENT VERSION
Any text strings included in a formula must be____________.
Enclosed in quotation marks
Enclose arguments in ______________.
Parentheses
What is a referenced formula?
Formulas within other formulas
How are reference formulas identified?
Identified with a leading @ sign
Example of a Boolan data type
True/False
What does the cstr() function do?
,Converts numbers, currency, dates, times, and datetime values to
text strings
What does the dateadd(intervaltype, nintervals, startdatetime)
formula do?
Returns a datetime value to which a specified number of time
intervals have been added
What are the most common reasons null values exist?
1. Many fields in Epic workflows are not required to be filled out
2. If your report references more than one database object, the data
may be more update to date in one system and not the other
3. If incorrectly formatted data is added to the Clarity database, it
may be deleted results in nulls
Epic recommends using a __________ in front of a missing record or
name
*
What does the isnull() function do?
It evaluates the field you place within the parentheses and returns
TRUE if the field contains a null value
,_____________ fields are used to manipulate the data to display as
required on the report
Formula Fields
If isnull({TABLE.COLUMN}) then ____________ else
_______________
"Default Text"; {TABLE.COLUMN}
T/F: Formulas are created in the Formula Editor
True
How can you open Crystal Reports online help?
Help (?) Button or Press F1
A _________ is a means of combining fields from two tables by using
values common to each
Join
The columns on which you perform your join are known as
_____________.
, Foreign Keys
When every row in the left table would be matched with every row
from the right table
Cartesian Product
A __________ is usually displayed next to fields that are part of a
table's primary key and allows you to quickly locate that field
Red flag
The _______________ of a table is the column(s) that can uniquely
identify a row
Primary Key
In Crystal Reports, use the __________ to add multiple tables to your
report
Database Expert
What new tab will appear in the Database Expert when you've
selected two or more tables?
Links
GUIDE 2026 QUESTIONS BANK AND VERIFIED CORRECT SOLUTIONS
WITH RATIONALES || 100% GUARANTEED PASS RECENT VERSION
Any text strings included in a formula must be____________.
Enclosed in quotation marks
Enclose arguments in ______________.
Parentheses
What is a referenced formula?
Formulas within other formulas
How are reference formulas identified?
Identified with a leading @ sign
Example of a Boolan data type
True/False
What does the cstr() function do?
,Converts numbers, currency, dates, times, and datetime values to
text strings
What does the dateadd(intervaltype, nintervals, startdatetime)
formula do?
Returns a datetime value to which a specified number of time
intervals have been added
What are the most common reasons null values exist?
1. Many fields in Epic workflows are not required to be filled out
2. If your report references more than one database object, the data
may be more update to date in one system and not the other
3. If incorrectly formatted data is added to the Clarity database, it
may be deleted results in nulls
Epic recommends using a __________ in front of a missing record or
name
*
What does the isnull() function do?
It evaluates the field you place within the parentheses and returns
TRUE if the field contains a null value
,_____________ fields are used to manipulate the data to display as
required on the report
Formula Fields
If isnull({TABLE.COLUMN}) then ____________ else
_______________
"Default Text"; {TABLE.COLUMN}
T/F: Formulas are created in the Formula Editor
True
How can you open Crystal Reports online help?
Help (?) Button or Press F1
A _________ is a means of combining fields from two tables by using
values common to each
Join
The columns on which you perform your join are known as
_____________.
, Foreign Keys
When every row in the left table would be matched with every row
from the right table
Cartesian Product
A __________ is usually displayed next to fields that are part of a
table's primary key and allows you to quickly locate that field
Red flag
The _______________ of a table is the column(s) that can uniquely
identify a row
Primary Key
In Crystal Reports, use the __________ to add multiple tables to your
report
Database Expert
What new tab will appear in the Database Expert when you've
selected two or more tables?
Links
