R-09 : Advanced Reporting: Custom Expressions And Criteria

11 Questions | Total Attempts: 285

SettingsSettingsSettings
Please wait...
R-09 : Advanced Reporting: Custom Expressions And Criteria

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 Back to top