Reports Type
Formulas
Miscellaneous
Report Features I
Report FeaturesI
100
The total number of report types
What is 8?
100
Name this formula: HDATE(Date_Opened,’YYMD’)
What is Date Field Conversion?
100
The three types of Analytics Users
What is Consumers, Authors, Publishers?
100
These are the two types of filters
What is Simple and Advanced?
100
The feature that allows you to create calculations is what button?
What is Detail (Define)?
200
This type of report will allow users to make edits to the report, but unable to save them.
What is Active Report?
200
Originator.FirstName | ‘ ‘ | Originator.LastName
What is Combine first and last name?
200
The Number of standard reports provided by Sparta
What is 7?
200
These are the two ways you can add a field to a report
What is Drag and Drop & Double-Click?
300
This type of report will protect it from being edited by other users
What is PDF?
300
This mask character acts as a wildcard search
What is % (ex. Smi%)?
300
The type of user that can only edit reports
What is Author?
300
This filtering feature will allow the user to manipulate a report after it has been run as well as allow them to set the operator to “not equal to”
What is Slicers?
400
From the Home tab, you cannot see this type of report
What is Info Mini?
400
This formula is what type Virtual Field: IF AssignedTo.LastName EQ Originator.LastName THEN ‘Self Assigned’ ELSE ‘’
What is Conditional?
400
The folder that will show the last 20 reports run by the user
What is Recent Items?
400
These are the four types of aggregates
What is Print, Count, List, & Sum?
500
The default report type when creating a new report
What is HTML?
500
This type of formula will show what output: 1.Common_Attributes.Division | ‘ / ‘ | 1.Common_Attributes.Project
What is Division / Project?
500
The Report Templates folder contains these types of reports
What is Crystal Multi-Record Reports?
500
This feature will allow you to see all of the values on a report so no blank spaces will appear
What is Repeat Sort Value?
M
e
n
u