Epic Crystal Reporting/Clarity/SQL 100% Correct Answers Verified Latest 2024 Version
2 views 0 purchase
Course
TOP CERTIFIES
Institution
TOP CERTIFIES
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 ...
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller hussle. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.49. You're not tied to anything after your purchase.
