Epic Crystal Reporting/Clarity/SQL
Exam Questions Complete Latest
2025/2026 with Correct Answers and
Rationales GRADED A+
Terms in this set (266) Original
A relational database contains related tables,
and these tables can be linked together based
What is a relational database?
on the relationship between the fields in two or
more tables
Each table in a relational database contains
_______ _______ and contains a _______ of one concept; series
intersecting rows and columns of data
SAP BusinessObject has created
_______________ to report with relational Crystal
databases.
___________ is a relational database used to
store and report on your organization's Epic Clarity
data.
,We use _________ to report off of _________ Crystal; Clarity
What is another name for a row? Record
To store an organization's Epic data purely for
What is Clarity's primary purpose?
reporting purposes
Does EPIC offer its own tools for creating
No. That's why we use Crystal Reports
reports off of Clarity?
A department in CLARITY_DEP is
Row
represented as one ____________.
True/False: In the PATIENT table, different
pieces of information pertaining to one patient True
are stored in different columns
A row contains a complete unit of related
Describe a "row" and a synonym for it information, and they are often called
"records"
A container of data that provides information
Describe a database
for a report and can also be called data sources
, 1. Report Wizard
What are the three different methods for
2. Blank Report Option
creating a new report within Crystal
3. Base a report off of a pre-exsiting report
Reporting?
(My Recent Reports)
What is the first step when creating a new
To specify the data source
report?
We access the Clarity Database through an
ODBC
______ layer
What does ODBC stand for? Open Database Connectivity
An interface that allows Crystal the ability to
What is an ODBC?
retrieve data in database management systems
No. Views are created simply to simplify
reporting on certain types of information. They
Do views hold data? don't hold data, but run queries against other
Clarity tables and present the results in a form
that can be used as a table
Refers to anything you can drag onto your
In Crystal Reports, the term "field" is used to
report. This includes database columns,
refer to what?
formulas, text, as well as special functions
What area will you spend most of your time in
The Design Tab
when creating a Crystal Report?
, This section only shows up on the top of the
Report Header (RH)
first page of a report
This section with show up on the top of every
Page Header (PH)
single page
This section will be repeated for every row of
data returned on your report and will contain Details (D)
the bulk of the report data
This section will only show up on the bottom
Report Footer (RF)
of the last page of the report
This section will show up at the bottom of
Page Footer (PF)
every page
1. Report Header (RH)
2. Page Header (PH)
What are the 5 report sections for Crystal
3. Details (D)
reports?
4. Report Footer (RF)
5. Page Footer (PF)
What is the purpose of the field explorer in It is used to insert, modify, or delete fields on
Crystal Reports? the Design or Preview tabs
In the field explorer, how can you re-arrange
Right-click on the database object name and
fields in alphabetical order for ease of
select "Sort Fields Alphabetically"
searching?
Exam Questions Complete Latest
2025/2026 with Correct Answers and
Rationales GRADED A+
Terms in this set (266) Original
A relational database contains related tables,
and these tables can be linked together based
What is a relational database?
on the relationship between the fields in two or
more tables
Each table in a relational database contains
_______ _______ and contains a _______ of one concept; series
intersecting rows and columns of data
SAP BusinessObject has created
_______________ to report with relational Crystal
databases.
___________ is a relational database used to
store and report on your organization's Epic Clarity
data.
,We use _________ to report off of _________ Crystal; Clarity
What is another name for a row? Record
To store an organization's Epic data purely for
What is Clarity's primary purpose?
reporting purposes
Does EPIC offer its own tools for creating
No. That's why we use Crystal Reports
reports off of Clarity?
A department in CLARITY_DEP is
Row
represented as one ____________.
True/False: In the PATIENT table, different
pieces of information pertaining to one patient True
are stored in different columns
A row contains a complete unit of related
Describe a "row" and a synonym for it information, and they are often called
"records"
A container of data that provides information
Describe a database
for a report and can also be called data sources
, 1. Report Wizard
What are the three different methods for
2. Blank Report Option
creating a new report within Crystal
3. Base a report off of a pre-exsiting report
Reporting?
(My Recent Reports)
What is the first step when creating a new
To specify the data source
report?
We access the Clarity Database through an
ODBC
______ layer
What does ODBC stand for? Open Database Connectivity
An interface that allows Crystal the ability to
What is an ODBC?
retrieve data in database management systems
No. Views are created simply to simplify
reporting on certain types of information. They
Do views hold data? don't hold data, but run queries against other
Clarity tables and present the results in a form
that can be used as a table
Refers to anything you can drag onto your
In Crystal Reports, the term "field" is used to
report. This includes database columns,
refer to what?
formulas, text, as well as special functions
What area will you spend most of your time in
The Design Tab
when creating a Crystal Report?
, This section only shows up on the top of the
Report Header (RH)
first page of a report
This section with show up on the top of every
Page Header (PH)
single page
This section will be repeated for every row of
data returned on your report and will contain Details (D)
the bulk of the report data
This section will only show up on the bottom
Report Footer (RF)
of the last page of the report
This section will show up at the bottom of
Page Footer (PF)
every page
1. Report Header (RH)
2. Page Header (PH)
What are the 5 report sections for Crystal
3. Details (D)
reports?
4. Report Footer (RF)
5. Page Footer (PF)
What is the purpose of the field explorer in It is used to insert, modify, or delete fields on
Crystal Reports? the Design or Preview tabs
In the field explorer, how can you re-arrange
Right-click on the database object name and
fields in alphabetical order for ease of
select "Sort Fields Alphabetically"
searching?
