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