Creating an expanded AUX reason code report

Last Updated : May 01, 2015 |
Prolog information
Metadata
Keywords:
The standard CMS Supervisor reports for CMS include a new field for the Expanded AUX feature. The field contains the combined calculated time for AUX reason codes 10 through 99. This field will be in any reports that display time in AUX. If you need your report to include specific AUX reason codes, you should create a custom report or modify an existing standard report.
The following report is an example of the type of custom report you can create with Report Designer when you use the following procedure.
  1. Open the CMS Supervisor interface and locate the Commands option on the menu bar.
  2. Select CommandsReports.
    STEP RESULT:
    The system displays the Report Selector window.
  3. Select New.
    STEP RESULT:
    The system displays a prompt to run the report wizard.
  4. Select No.
    STEP RESULT:
    The system displays the Report Designer window.
  5. Select from the menu bar EditInputs.
    STEP RESULT:
    The system displays the Edit Inputs window.
  6. Select Agent in the Input Types list, and then select the Add button.
  7. Select Date in the Input Types list, and then select the Add button.
  8. Select the OK button.
    STEP RESULT:
    The system returns to the Report Designer window.
  9. Select from the menu bar EditQueries.
    STEP RESULT:
    The system displays the Query Select window.
  10. Select the New button.
    STEP RESULT:
    The system displays the Query Assistant Window.
  11. Locate the Database section, and select Historical.
  12. Locate the table section, and select Agent Daily.
  13. Select the Next button.
  14. Locate the Database Items list.
  15. Select each of the following database items, and add the item to the Query Items list by selecting the Add button.
    ADDITIONAL INFORMATION:
    • TI_AUXTIME
    • TI_AUXTIME0 through
    • TIAUXTIME99
  16. Select Next.
    STEP RESULT:
    The system displays the Query Assistant window.
  17. Select Next.
    STEP RESULT:
    The system displays the Query Assistant window.
  18. Locate the Operand1, Operator, and Operand2 lists.
  19. Scroll through the lists and select:
    ADDITIONAL INFORMATION:
    • LOGID as Operand1
    • = as the Operator
    • [Agent] as Operand2
  20. Select the AND button.
  21. Scroll through the lists and select:
    ADDITIONAL INFORMATION:
    • ROW_DATE as Operand1
    • = as the Operator
    • [Date] as Operand2
  22. Select the AND button.
  23. Select Next.
  24. Enter a name for the query, or accept the default query name.
  25. Select Done.
    STEP RESULT:
    The system displays the Query Select window.
  26. Select Close.
    STEP RESULT:
    The system redisplays the Report Designer window.
  27. Select from the menu bar InsertTable.
    STEP RESULT:
    The system displays the Table Assistant window.
  28. Select your query in the Queries drop down list.
  29. Select the Add all button.
  30. Select Next.
  31. Right-click on the table, and then select Format table.
  32. Select Vertical in the Orientation section.
  33. Select Grid Lines on in the Options section.
  34. Select the Done button.
  35. Select from the menu bar ReportRun.
  36. Save the report when you exit. Select from the menu bar ReportExit.