R-09 : Advanced Reporting: Custom Expressions And Criteria
11 Questions
| Attempts: 329
Questions and Answers
- 1.Where is a custom expression built?
- A.
The custom expression module
- B.
In the text box at the bottom of the Edit Dialog of a display field
- C.
On the advanced tab of the Report Setup
- D.
The Report Details
- 2.What are custom expressions used for? (Select all that apply)
- A.
To modify the format of a field
- B.
To calculate the square root of 64
- C.
To perform calculations on reports
- D.
To add new work orders to a report.
- 3.How many times can a field be used on a report?
- A.
3
- B.
10
- C.
One Hundred Billion
- D.
1
- 4.Custom expressions are not case sensitive.
- A.
True
- B.
False
- 5.What are some commonly used Custom Expressions? (Select all that apply)
- A.
DATEDIFF
- B.
DOWORK
- C.
GETDATE
- D.
CONVERT
- E.
BEAMUP
- 6.You can select the Indicator even after entering a Custom Expression, and this will be applied to the report.
- A.
True
- B.
False
- 7.Where does defined Fixed Criteria show on the Report Criteria Window?
- A.
The very bottom
- B.
The left side under the first line
- C.
As a watermark behind the report criteria text
- D.
All of the above
- E.
None of the above
- 8.If you are using a Custom Expression to calculate the number of days open since the Work Order was Requested, you would want to use what field?
- A.
WO.IsOpen
- B.
WO.Reason
- C.
WO.Time
- D.
All of the above
- E.
None of the above
- 9.What custom expression can be used to make a field show in ALL CAPS?
- A.
ALLCAPS
- B.
ALLDAY
- C.
UPPER
- D.
DOWNER
- E.
None of the above
- 10.Fixed Criteria should be entered into the SQL Join box of the report.
- A.
True
- B.
False
- 11.Custom Expressions can be used to perform calculations on fields.
- A.
True
- B.
False
Back to top