Avaya CMS Supervisor Release 13.1 Report Designer 07-300743 Release 13.
©2000-2006 Avaya Inc. All Rights Reserved. Notice While reasonable efforts were made to ensure that the information in this document was complete and accurate at the time of printing, Avaya Inc. can assume no liability for any errors. Changes and corrections to the information in this document might be incorporated in future releases. Documentation disclaimer Avaya Inc.
Avaya Call Management System (CMS) Supervisor Release 13 Report Designer Contents Chapter 1: Report Wizard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . About the Report Wizard . . . . . . What is Report Wizard? . . . . . . Report Wizard and Report Designer Facts about Report Wizard . . . . Report Wizard command buttons . . . . . . Overview of Wizard steps . . . . . . . Starting Report Wizard . . . . . . . . Before you begin . . . . . . . . . . Starting with the toolbar icon . . . . .
Contents Select Table Format field descriptions . . . . . . . . . . . . . . . . . . . . . . . . . Example of a row-oriented report . . . . . . . . . . . . . . . . . . . . . . . . . . . Example of a column-oriented report . . . . . . . . . . . . . . . . . . . . . . . . . . The Finish page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Finish page field descriptions . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Contents Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Editing an existing report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 76 Chapter 4: Design mode basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 . . . . . . . . . . . . . . . . 80 81 81 81 82 83 84 85 86 87 88 89 90 90 90 91 Chapter 5: Edit | Inputs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Contents Editing the order of input fields . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Editing the appearance of input fields . . . . . . . . . . . . . . . . . . . . . . . . . . Edit columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Viewing the input window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104 105 105 107 107 107 110 Chapter 6: Edit | Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111 About queries .
Contents Procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 137 Chapter 8: Insert | Field . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141 . . . . Using the Field Assistant window . . . Inserting an ACD Name field . . . . . Inserting Data Item fields . . . . . . . Before you begin . . . . . . . . . . Procedure . . . . . . . . . . . . . Inserting Input Value fields . . . . . . Inserting a Report Data Start Time field .
Contents Data tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Data tab options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Controlling the 3D appearance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170 170 171 172 172 174 175 175 176 177 177 178 179 179 180 181 181 182 183 183 185 186 186 188 Chapter 12: Format | Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Contents Headers tab options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Using the Summary tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200 201 202 202 203 203 203 204 204 205 Chapter 13: Format | Field. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207 The Field Format Options window . . . . . . . . . . . . . . . . . . . . . . . . . . . . Field Format Options field descriptions . . . . . . . . . . . . . . . . . . . . . . . . .
Contents Appendix C: Report Designer examples . . . . . . . . . . . . . . . . . . . . . . . . . 233 Creating an integrated report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Modifying an integrated report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Creating an expanded AUX reason code report . . . . . . . . . . . . . . . . . . . . . 234 236 238 Glossary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 241 Index . . . . . . . . . . . . . .
Preface This section contains the following topics: ● Purpose on page 11 ● Audience on page 11 ● Reasons for reissue on page 11 ● Related documentation on page 12 ● Availability on page 15 Purpose Avaya Call Management System Supervisor Report Designer describes what you need to know to create new reports and to edit existing reports through Report Designer and Report Wizard. Audience This guide is intended primarily for those who use CMS Supervisor.
Preface Related documentation You might find the following Avaya CMS documentation useful.
Related documentation Administration documents For more information about Avaya CMS administration, see: ● Avaya Call Management System Release 13 Administration, 07-300331 ● Avaya Call Management System (CMS) Release 13 Database Items and Calculations, 07-300330 ● Avaya Call Management System Supervisor Release 13 Reports, 07-300334 ● Avaya Call Management System (CMS) Supervisor Release 13 Installation and Getting Started, 07-300333 ● Avaya Call Management System High Availability User Guide, 07
Preface Avaya CMS upgrade documents There are several upgrade paths supported with Avaya CMS. There is a document designed to support each upgrade. This section includes the following topics: ● Base load upgrades on page 14 ● Platform upgrades and data migration on page 14 ● Avaya Call Management System Upgrade Express (CUE) on page 14 Base load upgrades Use a base load upgrade when upgrading CMS to the latest load of the same version (for example, r13ak.g to r13al.k).
Availability For information about CUE upgrade procedures, see: ● Avaya Call Management System Release 13.1 Sun Blade 100/150 Workstation Mirrored and Nonmirrored Systems CMS Upgrade Express (CUE), 07-600763 ● Avaya Call Management System Release 13.1 Sun Fire V880/V890 Computer CMS Upgrade Express (CUE), 07-600764 Documentation Web sites For Avaya product documentation, go to http://www.avayadocs.com.
Preface ● The Avaya Publications Center, which you can contact by: Voice: +1-207-866-6701 +1-800-457-1764 (Toll-free, U.S. and Canada only) Fax: +1-207-626-7269 +1-800-457-1764 (Toll-free, U.S. and Canada only) Mail: GlobalWare Solutions 200 Ward Hill Avenue Haverhill, MA 01835 USA Attention: Avaya Account Manager E-mail: totalware@gwsmail.
Chapter 1: Report Wizard This section describes the Report Wizard windows and provides an overview of the steps.
About the Report Wizard This section includes the following topics: ● What is Report Wizard? on page 18 ● Report Wizard and Report Designer on page 18 ● Facts about Report Wizard on page 18 ● Report Wizard command buttons on page 19 What is Report Wizard? Report Wizard is a supplement to Report Designer and is available only if you have purchased Report Designer. The Report Wizard feature delivers user assistance, by way of a wizard, to quickly and easily generate new customized reports.
- One or two charts - One or two tables - One chart and one table To enter text or fields containing one data item, use Report Designer. ● Report Wizard does not display queries and database table names used to generate a report. If you need to see this type of information, use Report Designer. ● Report Wizard provides access to database item definitions. While in the Select Data Items page of the Report Wizard, you can view the definition of a database item or calculation.
Command button Action Cancel Discards any selections you have made if you have not saved the report, terminates the process, and closes the Report Wizard. If you saved the report before you selected Cancel, the Report Wizard is closed; however, you will be able to run or edit the report in Report Designer. Help Provides information about the page. Data Item Definition Provides a definition for the selected database item or calculation.
Overview of Wizard steps The following chart describes the steps Wizard takes you through.
Starting Report Wizard This section includes the following topics: ● Before you begin on page 22 ● Starting with the toolbar icon on page 22 Before you begin You can access Report Wizard only when Report Designer is activated on the Avaya Call Management System (CMS) server, and when you have the appropriate permissions to access Report Designer. Starting with the toolbar icon If you have purchased Report Designer, a toolbar icon will be displayed on the Controller window’s toolbar.
● The Select Data Items page on page 32 ● Procedures for the Select Data Items page on page 35 ● The Select Chart Format page on page 38 ● The Select Table Format page on page 41 ● The Change Input Captions page on page 44 ● The Preview Option page on page 45 ● The Save Report page on page 46 ● The Finish page on page 48 February 2006 23
The Select a Report Type page Your first task is to select a report type. The report type determines whether the data in the report is real-time, integrated or historical. For example, if you select a real-time report, you will not be able to specify historical data in the report.
Types of reports The following table provides information about each type of report. Report Description Real-Time Reports that refresh in real time. Real-time reports are reports that display current ACD call activity on agents, splits/skills, trunks, trunk groups, vectors, and vector directory numbers (VDNs) for the current interval (15, 30, or 60 minutes). Current intrahour interval real-time reports are periodically updated as data changes during the interval.
The Select a Report Layout page Your second task is to choose a report layout. The layout determines how your data will be represented in the report. Report layouts can be charts, tables, or both. Charts provide a graphical representation of data, and tables provide data in columns and rows. Select on the icon the represents the layout you want.
The Selection Layout page The Selection Layout page lets you choose which section of the report you want to design. Report Wizard will take you to this page only if you selected a report layout that contains a table and a chart, two tables, or two charts.
Defining sections The following table describes the sections of the report. Description A section that is pressed, with an arrow pointing to it, is the section you are about to define. A section that is not pressed, without an arrow, is the section you have not defined.
The Select a Data Group page This section includes the following topics: ● Levels of data groups on page 29 ● Expanding and collapsing categories on page 31 Use the Select a Data Group page to select the data you want for this report. The Select a Data Group page provides only those data groups specific to the type of report you chose earlier, and the current section you want to define.
This section includes the following topics: ● First level on page 30 ● Second level on page 30 ● Third level on page 30 First level The first level is the highest classification level of data. For example, the highest classification levels of data for a real-time table are Agent, Split/Skills (multiple), Trunk Group, VDN (single), VDNs (multiple), and Vectors. Second level The second level is a breakdown of the first classification level of data.
Agents Staffed and No Pre-selection. If there are three levels of data, the individual data groups will be listed under the third level. Expanding and collapsing categories Categories of data and sub-categories of data can be expanded (represented with a plus sign) and collapsed (represented with a minus sign). By default, when the Select a Data Group page of the wizard appears, one category will be expanded with one data group selected.
The Select Data Items page This section includes the following topics: ● Box and button descriptions on page 33 ● Data item column descriptions on page 33 ● About No Pre-selection on page 34 Use the Select Data Items page to select the specific types of data from the CMS databases that you want displayed in your report. Related topic For information on how to perform all the available tasks on this page, see Procedures for the Select Data Items page on page 35.
Box and button descriptions The following table describes the box and buttons on the Select Data Items page. Box or button Description Display Data Group items that contain Use this field to display only specific items in both columns of the Available Data Items box. For more information, see Filtering data group items on page 35. Available Data Items Contains all the data items associated with the data group. This list allows you to add data items to the Selected Data Items box.
About No Pre-selection If you chose the No Pre-selection data group on the Select a Data Group page, the Selected Data Items list view will not be populated with preselected data. However, the Available Data Items list view will contain all the data items available for your report. To select the data items for your report, you need to manually add them from the Available Data Items list view to the Selected Data Items list view.
Procedures for the Select Data Items page From the Select Data Items page, you can do the following tasks: ● Filtering data group items ● Sorting data group items ● Moving data group items from one box to another ● Repositioning data group items ● Creating custom report headings Filtering data group items To filter data group items: 1. In the Display Data Group items that contain box, enter the characters of the data items that you want Report Wizard to display.
Sorting data group items To sort the data group items, select the Item Heading column or the Data Item column. All data group items are sorted alphabetically. Moving data group items from one box to another To move data group items from the Available Data Items box to the Selected Data Items box and vice versa, do the following tasks: To move Then From the Available Data Items box to the Selected Data Items box Select one or more data items in the Available Data Items box, and select the right arrow.
Repositioning data group items You can reorganize data group items through the following methods. To move items Then Up Highlight one or more data group items and then select the up arrow. Down Highlight one or more data group items and then select the down arrow. Report Wizard enables up and down arrows only when data group items are selected in the Selected Data Items box. Creating custom report headings To change the data item heading: 1. Select the specific data item heading. 2.
The Select Chart Format page This section includes the following topics: ● Select Chart Format field descriptions on page 39 ● Available chart formats on page 39 Use the Select Chart Format page to define the format of your chart. The default is a vertical 2D bar chart that displays the data by value.
Select Chart Format field descriptions The following fields are located on the Select Chart Format page. Field Description Show Value Displays your data as a numeric value. Show Percentage Displays your data as a percentage. Display Legend Displays a legend of the data items in the right corner of the chart. Display Data Labels Displays the data labels on your report. The data labels are displayed as either values or percentages.
2D Vertical Stacked Bar Chart 3D Horizontal Stacked Bar Chart 3D Vertical Bar Chart 2D Horizontal Stacked Bar Chart 3D Line Chart 3D Pie Chart 2D Line Bar Chart 3D Stacked Area Chart 3D Vertical Cluster Bar Chart 40 Avaya CMS Supervisor Report Designer
The Select Table Format page This section includes the following topics: ● Select Table Format field descriptions on page 42 ● Example of a row-oriented report on page 42 ● Example of a column-oriented report on page 43 Use the Select Table Format page to define the characteristics of your table layout.
Select Table Format field descriptions The following fields are located on the Select Table Format page. Field Description Fill Table by Row Displays your data items horizontally. See Example of a row-oriented report. Fill Table by Column Displays your data items vertically. See Example of a column-oriented report. Display Grid Lines The report will display grid lines to separate the data. Example of a row-oriented report The following is an example of a row-oriented report.
Example of a column-oriented report The following is an example of a column-oriented report.
The Change Input Captions page When you are finished defining all report sections, the Change Input Captions page is displayed. This page allows you to change the input prompts that will appear in the Report Input window of your new report. Example Input Prompts The number of entries you see displayed in the Change Input Captions page will depend on the data group you assigned to each section of your report.
The Preview Option page The Preview Option page allows you to preview what you have defined for your report and exit the preview. You can use Back to modify the report section. A previewed version of a report contains real data for each completed section; however, if the report is designated as real-time, then there will be no refresh of data. The only option while in a previewed version of a report is to exit the preview.
The Save Report page Use the Save Report page to save your report and define who has permission to access your report. Your report will be saved when you enter a report name and select Next. The report type and data group selections you made for your report will determine the category your report will be saved under. For example, Real-Time. You are not required to save your report at this time. If you do not save your report, Report Wizard will still allow you to advance to the next page.
Save Report field descriptions The following table describes the fields on the Save Report page. Field Description Report Name Allows you to enter a name for your report. If there is an existing report with the same name, and you are not the owner of this report, Report Wizard will not allow you to overwrite the existing report. Report Description Provides a space for you to write a description of your report. Everyone Anyone can run the report and copy the report design.
The Finish page When all the required tasks are completed to create a report, you will have to determine whether you want to run the report, edit the report with Report Designer, or exit without doing anything. Example Finish page field descriptions The following fields are located on the Finish page. ● Run Report for ACD - Allows you to select the ACD for your report.
● Edit Report in Report Designer - When you choose to edit your report from the Finish page, Report Designer starts. All edits to your report are now done through Report Designer. Select the Back button on the wizard pages to edit your report with the Report Wizard. ● Run or Edit report at a later time - Select this option to exit Report Wizard without running your report or editing your report. This option is unavailable if you have not entered a report name for your report.
Avaya CMS Supervisor Report Designer
Chapter 2: Using Report Manager This section describes how to use Report Manager of the Avaya Call Management System (CMS) Supervisor application.
About Report Manager This section includes the following topics: ● What is Report Manager? on page 52 ● The Reports Selector window on page 52 ● Buttons on the Report Selector window on page 53 What is Report Manager? Report Manager is a feature of the Supervisor application that allows you to view report properties, copy reports, and access Report Designer to edit reports or create new reports.
Buttons on the Report Selector window Use the buttons on the Report Selector window to do the following tasks: Button Use to … Script Choose from any number of Windows scripts that you have installed on your PC. Properties Manage the standard CMS and Supervisor reports. Copy Copy reports to the Designer category for editing. Delete Delete reports from the Designer category. You cannot delete standard CMS, CMS custom, and standard Supervisor reports.
Viewing or changing report properties Report Manager gives you the ability to view report properties, such as the report name, description, owner, type, folder, category, permissions; as well as the folder the report is stored in. To view the report properties: 1. Open the Report Selector window. 2. Select the report for which you want to view properties. 3. Select Properties. The Properties window for the report is displayed. 4.
Copying a report to the designer category Use Report Manager to copy a report from any category into the Designer category of any folder. The categories can be Agent, Other, Queue/Agent, Split/Skill, Trunk/Trunk Group, VDN, Vector, Custom, or Designer. Folders can be Real-Time, Historical, or Integrated.
5. Select OK. The Copy Report To Designer window is displayed. This window allows you to define the name, description, folder, and scope of the report. 6. Enter a name for your report in the Name field. The name can have up to 40 alphanumeric characters, including blanks. Because the name you give your report should be unique, you may want to look at existing report names before you enter a name for your report. 7. Move the cursor to the Description field and enter a description of the report.
9. Do one of the following tasks: If … Then … You want your report to be available to everyone Select Everyone. You want your report to be available only to you Select Only Me. It is a good idea to initially make your reports available only to yourself until they have been debugged and run successfully. This prevents the possibility of other users running reports that you have saved but not yet tested. For more information about assigning access, see Who can modify your reports on page 55. 10.
Copying a designer report to a file Use the Copy button on the Report Selector window to copy any designer report that you create to a file that resides on diskette, on your hard drive, or on a network drive. You can use this feature to easily transport designer reports from one PC to another. If a report was created by Avaya Inc. Professional Services, only a user with CMS services permissions can copy the report. To copy a report, do the following steps: 1. Open the Report Selector window. 2.
Copying a designer report from a file Use Report Manager Copy to copy any designer report that has been saved to a file, either on diskette or on a network drive, onto the CMS server. To copy a report from a file to the server: 1. Open the Report Selector window. 2. Select Copy. The Copy Report window is displayed. This window allows you to select where you want to copy the report. You can copy the report to the Designer category, to a PC file, or from a PC file to the CMS server. 3.
Deleting a report from the designer category Report Manager allows you to delete any report that resides in the designer category except reports purchased from Professional Services. You cannot delete any of the standard CMS, CMS custom, or standard Supervisor reports. Standard reports are reports that reside in the Agent, Other, Queue/Agent, Split/Skill, Trunk/Trunk Group, VDN, Vector, and Custom categories. To delete a designer report: 1. Open the Report Selector window. 2.
Opening Report Designer with Edit or New Use one of the following methods to open Report Designer. If you want to open from … Then … Report Manager Select a report from the designer category and do one of the following tasks: ● Select Edit. ● Select New to create a new report. A report output window Select Design from the Report menu on the report. Report Wizard Open from the last page.
Avaya CMS Supervisor Report Designer
Chapter 3: Report Designer basics This section outlines the features of Report Designer and describes its general use.
Report Designer menus This section describes Report Designer menus and includes the following topics: ● Report on page 64 ● Edit on page 65 ● Format on page 66 ● Options on page 67 ● Insert on page 68 ● Help on page 69 Report The following is a description of the Report menu. Menu item Function Run Takes you out of design mode and runs your report. You will use Run to test the changes or additions you have made to a report. Save Saves your report.
Edit The following is a description of the Edit menu. Menu item Function Undo Cut/ Delete Undo a cut or deletion. Undo Align Controls Undo an alignment you made. Cut Remove an item from the report and place it on the Windows clipboard. Copy Copy the items that you have selected on the report and place it on the Windows clipboard. You can copy only entire tables and entire charts, not a portion of a table or chart.
Menu item Function Inputs Start the Select Inputs assistant, which enables you to choose the items that will be included on the report input window for this report. For instructions on how to use the Select Inputs assistant, see Edit | Inputs on page 93. Queries Start the Create a Query assistant, which is where you define the SQL queries that will be used to retrieve the data to be displayed on the report. For instructions on how to use the Create a Query assistant, see Edit | Queries on page 111.
Menu item Function Sort by Opens the Table Format Options window with the Sort by tab active. Use this window to access the General and Sort by tabs to format tables on reports. For more information on the Table Format Options window, see Format | Table on page 189. Text Opens the Text Format Options window when a text item on the report is selected. Use this window to change the font display characteristics for the selected text.
Insert The following is a description of the Insert menu. Menu item Function Chart Opens the Chart Assistant, which is where you define the contents of a chart. A chart is a graphical presentation of the report information. This menu item is unavailable if no queries have been defined. For more information about the Chart Assistant, see Insert | Chart on page 133. Field Opens the Field Assistant, which is where you define the contents of a field to be placed on the report.
Help The following is a description of the Help menu. Menu item Function Contents Opens the Help Topics dialog for Report Designer. Technical Support Opens a window that provides technical support information. About Avaya CMS Supervisor Opens the Supervisor Help About window, which shows the software version number. Other ways to access Help You can access Supervisor Help from all of the windows in Report Designer. You can also use one of the following ways to access Help: ● Press F1.
Accessing online database definitions Report Designer provides access to online database item definitions when you want to add database items and calculations to a query. With this feature, you do not have to refer to hard-copy documentation to learn about database items and calculations. Example Procedure To access the online database item definitions: 1. From a Query Assistant window, highlight the data group item or calculation for which you want a definition. 2.
Starting Report Designer This section includes the following topics: ● About user permissions on page 71 ● Different ways to start Report Designer on page 71 ● Design Mode window on page 72 About user permissions To access Report Designer and to run Designer reports, you must have read and write permissions assigned for Custom Reports. These permissions are set with the User Permissions tool. For more information about user permissions, see the Avaya CMS Administration document.
Design Mode window You can use any method to start Report Designer and go to the Design Mode window. The window will be blank if you want to create a new report or will have report information if you want to edit an existing report.
Exiting Report Designer You can close Report Designer using any of the standard Windows methods: ● Select Exit from the Report menu. ● Double-click System. ● Select Close at the top of the window. If you try to exit Report Designer without first saving the report you have been working on, a warning gives you the opportunity to save the report before you close Report Designer.
Creating a new report Do all of the steps in Create a new report to create a custom report. If you consistently do all of these tasks for each report you create, your reports will run properly and you will be able to create them efficiently.
3. Define report type and rows of data from specific CMS database tables that will supply data for the tables and charts on the report. For more information, see About queries on page 112. 4. Define what data from the queries should appear in each chart, field, or table on the report. For more information, see any of the following chapters: ● Insert | Chart on page 133 ● Insert | Field on page 141 ● Insert | Table on page 153 5.
Editing an existing report Use this procedure to edit an exiting report in Report Designer. If you consistently do all of these tasks for each report you want to edit, your reports will run properly and you will be able to create them efficiently. To edit an existing report: 1. Copy an existing report so that you start the design process with existing report headings, data fields, queries, charts, tables, and other report features.
6. Define which rows of data from specific CMS database tables will supply data for the grids and charts on the report. If you copy a report design, the definitions of that report’s queries are copied. You can then modify the queries, as required. This step is optional. For more information, see About queries on page 112. 7. Define what data from the queries should appear in each chart, field, or table on the report.
Avaya CMS Supervisor Report Designer
Chapter 4: Design mode basics This section describes how to use the basic features of the Report Designer Design Mode window.
Copying an item and pasting the item into the same report To copy an item in a report and paste the copy into the same report: 1. Open the report from which you want to copy. 2. Select one or more items that you want to copy. 3. Press Control+C. 4. Go to where you want to paste the items and press Control+V. The system places items in the upper-left corner of the Design Mode window.
Copying and pasting items This section includes the following topics: ● Copying from a Designer report on page 81 ● Copying from a report that is not a Designer report on page 81 Copying from a Designer report To copy items from one report to another report: 1. Open the report from which you want to copy. 2. Select the items that you want to copy. 3. Press Control+C. 4. Open the report to which you want to paste what you have copied. 5. Press Control+V.
Cutting an item To cut an item from a report and place the information on the Windows clipboard: 1. Select the item. 2. Press Control+X.
Deleting an item Use this procedure to permanently remove the currently-selected items from the report. To delete an item from a report: 1. Select the item. 2. Press Delete. The item is removed from the report and is no longer available to be pasted into the report. Restoring an accidently-deleted item If you accidentally delete an item that you want to keep in the report, you can select Undo from the Edit menu if you have not done anything else.
Dragging and dropping to arrange items To reposition one or more items on a report with the drag-and-drop method: 1. Point the cursor at the item and click one time to select one or more items. To select additional items, hold down Control and click the cursor on the items. You will know when an item is selected because there will be a frame around the item or sizing handles will display on the corners of the item. 2. Hold down the left mouse button. 3.
Resizing an item To resize an item on a report: 1. Select the item. 2. Place the mouse cursor over one of the sizing handles on the item. 3. Press the left mouse button. 4. Drag the mouse cursor until the item is the appropriate size. 5. Release the mouse button.
Selecting multiple items To select multiple items on a report (for instance, to copy more than one item at a time): 1. Select the first item. 2. Hold down Control. 3. Select the second item. Handles are displayed around the items.
Moving multiple items To move the group of items on a report: 1. Place the cursor within the selected items. 2. Hold down the left mouse button and drag the selected items to the desired area. There is a visual indication that your selected items will move as a group with the cursor. As you move the selected items, an outline of the items is displayed and then moves with your cursor. 3. Once the items are in the desired location, release the mouse button.
Changing the width of a column in a table You can quickly and easily change the column widths in your table while in the design mode. To change a column width: 1. Place the mouse pointer on the border between the column heading. The mouse pointer changes to the following shape: 2. Hold down the left mouse button and drag the column border to the left or right. The column width automatically decreases or increases depending on how you move the column border.
Changing the column headings You can quickly and easily change the column headings in your table while in the design mode. To change a column heading: 1. Select the heading name you want to change. A dialog box is displayed with the current heading highlighted. 2. Enter the new name of the heading in the Name text box. 3. Select OK.
Aligning fields This section includes the following topics: ● Align menu items on page 90 ● How to use align on page 90 Align menu items The Report Designer Edit menu has two menu items: ● Align Controls ● Undo Align Controls How to use align You can select multiple fields and align them in various ways. You can undo the alignment if you are not satisfied with the results.The Align Controls dialog box provides six alignment choices.
Scaling to page When you print a report that is too large to fit on one page, you will be prompted with one or more messages. The number of messages will depend on the size of your report. The messages will ask if you want the Scale to Page function to attempt to fit your report onto one page.
Avaya CMS Supervisor Report Designer
Chapter 5: Edit | Inputs This section describes the Edit | Inputs menu option. Use the Edit | Inputs menu option to add, delete, and edit the input fields for a Report Designer report.
The Report Input fields This section includes the following topics: ● The Report Input window on page 94 ● The Define Input window on page 94 ● Example of input window on page 95 ● How CMS stores and retrieves data on page 95 The Report Input window To run a report, you first access a Report Input window. The Report Input window gives you control over which splits/skills, trunks, dates, intrahour intervals, and so on are included in the report.
Example of input window In the example input window that is shown below, the user has entered a split number of 1, a date of 07/01/96, and intrahour intervals of 8:00 a.m. to 11:00 a.m. How CMS stores and retrieves data Because the report this input window is associated with is a Historical Interval report, Avaya Call Management System (CMS) will retrieve the data for the report from the historical database tables, which are designated with an h, such as hagent, hsplit, htrunk, and so on.
Information about how to add input fields This section includes the following topics: ● Why define an input field? on page 96 ● Add only relevant information on page 96 ● Fields you do not define on page 96 Why define an input field? When you define the type of an input field, CMS will be able to do the following when your users run the report: ● Check that user entries are valid system values and are values CMS can use to search the database tables.
Related topic For the procedure, see Adding input fields to the input window on page 102.
Input fields for pattern matching This section includes the following topics: ● What is pattern matching? on page 98 ● Database items that allow search on page 98 ● Using an asterisk on page 99 ● Using a question mark on page 99 ● Using String as an input field on page 99 What is pattern matching? CMS can search for values in certain database items according to wild card search patterns.
In addition, any custom database items that you define as CHAR columns in the CMS database also allow pattern matching. Using an asterisk You can search with an asterisk (*). If an input field is a string type and is associated with the LOGID database item, the user can enter 1*, and CMS will report data for all agents with login IDs that start with 1. Using a question mark You can search with a question mark (?).
Input Types The following table describes the input types and what type of information the user must enter. For this type of input: The user must enter the following information: ACD An ACD number or name. Agent An agent name as defined in the Dictionary or agent login ID. The Agent input field can only be a single-value input for integrated reports. Agent group An agent group name as defined in the Dictionary.
For this type of input: The user must enter the following information: Number A number that may include digits to the right of the decimal point. This type applies if your variable field asks for specific values about ACD performance. For example, use the number of ACD calls or percent within the service level. Split/Skill A split/skill number or name. String A character string.
Adding input fields to the input window This section includes the following topics: ● Before you begin on page 102 ● Procedure on page 102 Before you begin Read the following topics before you do this procedure if you have not done so already: ● Information about how to add input fields on page 96 ● Input fields for pattern matching on page 98 ● Input Types on page 100 Procedure To define the input fields for a report: 1. Select Inputs from the Edit menu. An Edit Inputs window is displayed.
Deleting input fields from the input window This section includes the following topics: ● Before you begin on page 103 ● Procedure on page 103 Before you begin If a field is used in a query, you cannot remove the input until you remove or modify the query. Procedure To delete one of the inputs you have added for a report input window: 1. Select Inputs from the Edit menu. 2. On the Inputs table, select the left-numbered column of the row to highlight the row of the item. 3. Select Remove.
Editing the order of input fields To change the order in which input fields appear on the report input window: 1. Select Inputs from the Edit menu. 2. Add the Input Types that will appear on the input window to the Inputs table. 3. Select the left-numbered column of the row to select the entire row of the input that contains the fields you want changed. 4. Press Up and Down to move the entire row up or down one row at a time. 5.
Editing the appearance of input fields Use the Inputs list to edit the name of the prompt for each input field, control whether multiple values are allowed in the input field, and define the ACD with which the input will be associated. Example Edit columns When you add an item from the Input Types list to the Inputs list, the columns of the Inputs table are populated with the default values for that input item.
Column Function Prompt The prompt column shows the text that will display on the report input window for this input field. To edit the text for the prompt, select the cell in the table and then enter the text that you want to display. If you want to delete the existing prompt text, use backspace to erase the letters. You can enter a name of up to 30 characters long, including blank spaces.
Setting up inputs for a multi-ACD report Use this procedure to create a multi-ACD report. Make sure that you set up the inputs as detailed in this procedure so that the query for the report will work properly.
4. Repeat Steps 2 and 3 three times. The Inputs table will have three more ACD entries that are followed by numbers: 5. Select Split/Skill from the Input Types box. 6. Select Add. 7. Repeat Steps 5 and 6 three times.
8. For the Split/Skill(2) prompt on line 6 of the Inputs table, use the Associated ACD drop-down list to select ACD(2) as the associated ACD. 9. For the Split/Skill(3) prompt on line 7 of the Inputs table, use the Associated ACD drop-down list to select ACD(3) as the associated ACD. 10. For the Split/Skill(4) prompt on line 8 of the Inputs table, use the Associated ACD drop-down list to select ACD(4) as the associated ACD. The Inputs table will have each split/skill matched to the corresponding ACD: 11.
Viewing the input window When to view - To view what the input window will look like, select Run from the Report menu. Returning to design mode - To return to the design mode from the report input menu, select Cancel.
Chapter 6: Edit | Queries This section describes the Edit | Queries menu option. A report consists of fields, charts, and grids that display data that is retrieved from the Avaya Call Management System (CMS) database tables. Use a query to define what data is retrieved for a specific report.
About queries To complete the definition of a report's tables, charts, or fields, you must define the queries that select the rows of the appropriate tables in the CMS database. This section includes the following topics: ● What are queries? on page 112 ● About columns and rows on page 112 What are queries? Queries are values for either database items or calculations.
The Query Assistant window Use the Query Assistant window to define what data is retrieved for a specific report.
Query Assistant input fields The following table describes the Query Assistant input fields. Field Description Database Items Shows a list of all of the available database items, based on the tables you selected on the Select a database and one or more tables for the query window. If you selected more than one historical database table to be used in the query, the table names are appended to the database item names. For example, wsplit.acdtime.
Select a database and one or more tables for the query window The Table list includes the database items you can include in the query. For real-time and integrated reports, you can select only one table name. For historical reports, you can select up to three table names. Note: Note: The calculations that are associated with the database items in the tables you choose will also be available for you to use in your query.
Add the database items and calculations for the SELECT portion of the query window Use this window to add and remove database items and calculations that you want included in the query. This section includes the following topics: ● Tasks on page 116 ● Database Items or Calculations on page 116 Tasks Use the Query Assistant window to do the following tasks: ● Use Move Up and Move Down to change the order of the items in the Query Items box.
Choose functions for the SELECT items window Use the Query Assistant window to assign AVG, MAX, MIN, and SUM aggregate functions to the Query Items. This section includes the following topics: ● Definition of function on page 117 ● Types of functions on page 117 Definition of function A function is a prefix that is attached to a database item, a calculation, parts of a calculation, or a calculation name.
Enter the SQL WHERE criteria window Use this Query Assistant window to define the SQL WHERE clauses that you want to use to retrieve data for the report. The SQL WHERE clause tells the CMS to retrieve the data defined in the SELECT box that matches the criteria defined in the WHERE box. The SELECT box specifies which columns of data to consider in the database tables. The WHERE box species which rows of data to consider in the database tables.
Field descriptions This window includes the following fields: Item Description SELECT box Shows the Query Items that were defined on the previous windows, including the database items and calculations and any associated functions assigned to the items and the database table from which the database items and calculations are to be retrieved. The information displayed in the SELECT box cannot be edited. Operand1 box Lists the database items and calculations that can be used in the WHERE clause.
Specify all field joins for the tables window Use this Query Assistant window to ensure that items between two or three tables are equal in order to be used in the report. Example: You might want to select the ACD item from each agent and make a join clause to ensure that the report is for the same ACD information across the tables.
Create a new query for a real-time report To create a new query for a real-time report: 1. Select Query from the Edit menu. The Query Select window is displayed. 2. Select New. A Query Assistant window is displayed. For more information on this window, see Select a database and one or more tables for the query window on page 115. 3. Select Real-Time Database. 4. In the Table list, highlight the name of the table that include the database items that you want to include in the query.
16. In the Operand2 box, highlight the second database item or calculation that you want considered in the WHERE clause. Example: If you wanted the report to select the data from the table when the number of ACDCALLS is greater than the number of ACWINCALLS, you would select acdcalls in the Operand1 box, the > sign in the Operator box, and ACWINCALLS in the Operand2 box. 17. Select AND or OR, as appropriate. 18. Repeat Steps 14 through 17 until you have completed the query. 19. Select Test.
Create a new query for a historical report To create a new query for a historical report: 1. Select Query from the Edit menu. The Query Select window is displayed. 2. Select New. A Query Assistant window is displayed. For more information, see Select a database and one or more tables for the query window on page 115. 3. Select Historical Database. The tables that are available for the historical database display. 4.
14. Do one of the following tasks: If Then You did not select more than one historical database table for your query Go to Step 20. You selected the Historical Database for your query and you are using more than one table in the query The Specify all field joins for the tables window is displayed. For more information about this window, see Specify all field joins for the tables window on page 120. Go to Step 15. 15. Highlight an item in one of the table lists. 16.
29. Select Done.
Create a new query for an integrated report To create a new query for an integrated report: 1. Select Query from the Edit menu. The Query Select window is displayed. 2. Select New. A Query Assistant window is displayed. For more information, see Select a database and one or more tables for the query window on page 115. 3. Select Database next to Integrated. The tables that are available for integrated reports are displayed. 4.
11. Do one of the following tasks: If you selected Then Select Start Time Now Define the time that the integrated data will always begin accumulating for this report. Input Start Time A Start Time field will be added to the report input window and users can individually define the time that data will begin accumulating for the report. 12. Select Next. A Query Assistant window is displayed. On this window, you can choose the input item that will be used for the query. 13.
Edit an existing real-time or historical query Complete the following steps from the Report Designer Design Mode window. To edit an existing real-time or historical query used in a Designer Report: 1. Select Query from the Edit menu. The Query Select window is displayed. 2. In the Queries box, highlight the name of the query you want to edit. 3. Select Edit. A Query Assistant window is displayed. The Database Items and Calculations that are already included in the query are listed in the Query Items list.
9. In the Operand2 box, highlight the second database item or calculation that you want considered in the WHERE clause. Example: If you want the report to select the data from the table when the number of ACDCALLS is greater than the number of ACWINCALLS, you would select acdcalls in the Operand1 box, the > sign in the Operator box, and ACWINCALLS in the Operand2 box. 10. Select AND or OR, as appropriate. 11. Repeat Steps 7 through 10 until you have completed the query.
Edit an existing integrated query Complete the following steps from the Report Designer Design Mode window. To edit an existing integrated query used in a Designer Report: 1. Select Query from the Edit menu. The Query Select window is displayed. 2. In the Queries box, highlight the name of the integrated query you want to edit. 3. Select Edit. A Query Assistant window is displayed. For more information, see Add the database items and calculations for the SELECT portion of the query window on page 116. 4.
Copy a query To copy an existing query, complete the following steps from Report Designer Design Mode: 1. Select Query from the Edit menu. The Query Select window is displayed. 2. In the Queries box, highlight the name of the query you want to copy. 3. Select Copy. The Copy Query window is displayed. 4. In the To text box, enter the name you want to assign to the copied query. 5. Select OK.
Delete a query ! Important: Important: If you delete a query that is used in the report, the report will not run. Complete the following steps from Report Designer Design Mode. To delete an existing query: 1. Select Query from the Edit menu. The Query Select window is displayed. 2. In the Queries box, highlight the name of the query you want to delete. 3. Select Delete. A message confirming the delete is displayed. 4. Select OK to delete the query.
Chapter 7: Insert | Chart This section describes the Insert | Chart menu option. Once you have defined queries for a report, you can use those queries to add a chart to your report using the Chart Assistant, which is accessed by selecting Chart from the Insert menu. This section includes the following topics: ● Information about how to insert charts on page 134 ● Inserting a chart on page 137 Related topic For more information about defining queries for a report, see Edit | Queries on page 111.
Information about how to insert charts This section includes the following topics: ● About inserting charts on page 134 ● About charts and tables on page 134 ● About fields and text on page 134 ● About adding and removing items on page 135 ● Stacked, % Axis, and Gradiant field descriptions on page 135 ● About the Chart Assistant window on page 136 About inserting charts There are two things to keep in mind when inserting charts onto a report: ● When you insert a chart on a report, the chart is
About adding and removing items The following items should be read and understood about the adding and removing of items: ● Use Move Up and Move Down to arrange the items in the order in which you want them displayed on the chart. ● Items that are added to the Data on Chart box are shown in the chart you want to create. ● The maximum number of columns that can be included on a chart is 16.
About the Chart Assistant window Use this window to define how the data will be displayed on the axis of the chart. Column descriptions There are three columns used to define the category and series for the chart.
Inserting a chart This section includes the following topics: ● Before you begin on page 137 ● Procedure on page 137 Before you begin Read Information about how to insert charts on page 134, if you have not already done so. Procedure To insert a chart in your report: 1. Select Chart from the Insert menu. The first window of the Chart Assistant is displayed. 2. From the Queries drop-down list, select the query from which you want to take data for the chart.
5. Do one of the following tasks: If you want the chart to display in … Then select … Two-dimensional format 2D Three-dimensional format 3D 6. From the Chart Types box, select which type of chart you want to display. If you are not sure what each type of chart will look like, you can highlight the type and an example of the chart displays on the right side of the window. 7. Select Stacked, % Axis, and Gradient, as appropriate.
the first item listed in the Category Available Items box is the item that is used for the chart category. The previous example showed a report with One Data Value per Row selected. Example: This is an example of the same report, using the same Category item (STARTTIME), without One Data Value per Row selected.
Avaya CMS Supervisor Report Designer
Chapter 8: Insert | Field This section describes the Insert | Field menu option. The time or date when a report is run is not stored in any database table. The Avaya Call Management System (CMS), if requested, displays information from the start time specified by the user (for integrated and historical data). Similarly, CMS knows what the currently selected ACD is when you run a report and can display the current ACD name or number on the report.
Information about how to insert fields This section includes the following topics: ● About Field Assistant on page 142 ● Positioning a field on page 142 ● Editing a field on page 142 About Field Assistant The Field Assistant allows you to insert fields in a designer report to display the report's run-time, run-date, current ACD, data, or any of the fields that were specified as being required in the report input window. Select Field from the Insert menu to access the Field Assistant.
Using the Field Assistant window To use the Field Assistant window: 1. Select Field from the Insert menu. The Field Assistant Select a field type window is displayed. 2. Select an item from the Types list. Note: Note: The Report Data Start Time type is available only with an Integrated Report. 3. Do one of the following tasks: If you highlighted … Then … ACD Name, Report Data Start Time, or Time Report Run Go to Step 4. Data Item Select Next.
Inserting an ACD Name field ! Important: Important: Do not position the field over any tables or charts because the table or chart will be displayed over the field so that the field will not be visible. To insert the name of the ACD for which the report was run: 1. Select Field from the Insert menu. The Field Assistant wizard is displayed. 2. Highlight ACD Name in the Types box. 3. Select Done. The ACD name field is placed in the upper-left corner of the report. 4.
Inserting Data Item fields This section includes the following topics: ● Before you begin on page 145 ● Procedure on page 145 Before you begin Before you can insert a data item on a report, the data item must be used in a query that is associated with this report. Procedure ! Important: Important: Do not position the field over any tables or charts because the table or chart will be displayed over the field, and the field will not be visible. To insert data item fields on the report: 1.
Inserting Input Value fields ! Important: Important: Do not position the field over any tables or charts because the table or chart will be displayed over the field, and the field will not be visible. To insert input value fields on the report: 1. Select Field from the Insert menu. The Field Assistant wizard is displayed. 2. In the Types box, highlight the Input Value. 3. Select Next. The Select an input for your field window is displayed. 4.
Inserting a Report Data Start Time field ! Important: Important: Do not position the field over any tables or charts because the table or chart will be displayed over the field, and the field will not be visible. This type of field applies to only integrated reports. To insert the initial start time (the time at which data begins accumulating) for an integrated report: 1. Select Field from the Insert menu. The Field Assistant wizard is displayed. 2. In the Types box, highlight Report Data Start Time. 3.
Inserting a Time Report Run field ! Important: Important: Do not position the field over any tables or charts because the table or chart will be displayed over the field, and the field will not be visible. To insert on the report the time at which the report was run: 1. Select Field from the Insert menu. The Field Assistant wizard is displayed. 2. In the Types box, highlight Time Report Run. 3. Select Done. The Time Report Run field is placed in the upper left corner of the report. 4.
Chapter 9: Insert | Text This section describes the Insert | Text menu option. Report Designer allows you to include text strings with no associated data on your report. You will use the Text option from the Insert menu to add items such as the report name to your designer reports.
Positioning and editing text This section includes the following topics: ● Positioning text on page 150 ● Editing text on page 150 Positioning text Each item is initially inserted in the upper-left corner of the report. You will need to drag-and-drop the text to the location where you want it to be displayed on the report. Editing text To edit text: 1. Select the text. 2. Select Text from the Format menu.
Inserting text ! Important: Important: Do not position the text over any tables or charts because the table or chart will be displayed over the text, and the text will not be visible. To insert a text string on a report: 1. Select Text from the Insert menu. The Text Assistant window is displayed. 2. Enter the text that you want to display on the report in the Text contents field. 3. Do one of the following tasks: If you want to … Then … Select a specific font for the text Go to Step 4.
Avaya CMS Supervisor Report Designer
Chapter 10:Insert | Table This section describes the Insert | Table menu option. Once you have defined the queries that you want to use for a report, you can use those queries to add a table to the report with the Table Assistant. To access Table Assistant, select Table from the Insert menu. This section includes the following procedures: ● Positioning and editing tables on page 154 ● Inserting a table on page 155 Related topic For more information about defining queries, see Edit | Queries on page 111.
Positioning and editing tables This section includes the following topics: ● Positioning a field on a table on page 154 ● Editing a table on page 154 Positioning a field on a table Each item is initially inserted in the upper-left corner of the report. Drag-and-drop the field to the location where you want it to be displayed on the report. Editing a table To edit a table: 1. Select the table. 2. Select Table from the Format menu.
Inserting a table This section includes the following topics: ● Before you begin on page 155 ● Procedure on page 155 Before you begin If the report includes both a chart and a table, place the chart over the table on the report. The reason for this is, if the table spans multiple pages when printed and if the chart is below the table on the report, the table will print over the chart so that you cannot see the chart.
4. Select Next. The Table Assistant window is displayed. Note: Note: You can change any of the options you select in Steps 5 through 10 after you have inserted the table with Format | Table. 5. Select either Horizontal or Vertical to define the orientation of the table. 6. Add a Summary line to the table by doing one of the following tasks: If … Then … You want to place the Totals line at the top of the table as standard CMS reports do Select Top.
10. Choose one of the following tasks: If you want to … Then … Create a new query for the summary line on this table Go to Step 11. Use an existing query for the summary line on this table Go to Step 15. 11. Select Build a New Query. 12. Enter a name for the summary query in the Name field. 13. Edit the table to include the database items and summary information that is appropriate for this summary query. 14. Go to Step 17. 15. Select Select an Existing Query. A Table Assistant window is displayed.
Avaya CMS Supervisor Report Designer
Chapter 11: Format | Chart This section describes the Format | Chart menu option. Report Designer allows you to format report charts after they have been inserted on the report. You will use the Chart option from the Format menu to edit charts on your designer reports.
● Formatting the title on page 182 ● Selecting a chart type on page 185 ● Controlling the 3D appearance on page 188 160 Avaya CMS Supervisor Report Designer
Information about how to format charts This section includes the following topics: ● What are charts? on page 161 ● About the Chart Format Options window on page 162 ● How to access the window on page 162 ● How your changes affect others on page 162 What are charts? Charts provide a graphical representation of data. Values or data points are displayed in formats such as bars, lines, filled areas, and pie charts. These data points are grouped into series that are identified with unique colors.
About the Chart Format Options window The Chart Format Options window gives you access to the General, Axis, Data, Data Labels, Fonts, Series Labels, Legend, Title, Type, and 3D Effects tabs for formatting charts on reports. How to access the window If the report you want to design includes a chart, you can format how the chart is displayed and what is displayed on the chart. Access the Chart Format Options window by doing any of the following tasks: ● Double-click a chart in the report.
General tab Select the General tab to specify several general options that apply to the chart. Example General tab options You can change the following chart parameters: ● Background Color - You can specify whether the backdrop of the chart is a solid color or whether it is displayed as a gradient. The gradient transition can be one of the following options: horizontal, vertical, rectangle, or oval. The quality of the gradient effect will vary depending on what video card is installed in the PC.
Changing general chart parameters To change general chart parameters: 1. In the Background Color box, select Report Background, Solid, or Gradient. If you select … Then … Report Background The background of the report will default to the color you set on the Options Report Colors tab which is accessed from the Controller Tools menu. Solid Select the square next to the Background Color option to set the color of the report background.
Axis tab Use the Axis tab to specify the title that will be displayed on each axis of the chart report. Example Axis tab options You can change the following chart parameters: ● Axis Display on page 165 ● Category on page 166 Axis Display Makes each of the axes visible or invisible. The choices are X Axis, Y Axis, 2nd Y Axis, and Z Axis. The 2nd Y Axis is available only for bar charts. Select this check box to display the y-axis information on the right side of the bar chart.
Category Select the category, or database item, that you want to use as the x-axis on the chart. You can use the drop-down menu to select any of the database items you included in the query for this chart. ● Category for X-Axis - This item is the same as the Available Items box in the Insert Query Chart Assistant. Select the database item that you want to use as the category for the chart. The Category is usually none for real-time charts, or a time database item for historical charts.
data that was retrieved from the CMS database for those splits/skills on the specified date for the specified time period. Also, the Show Value as Name field was not checked.
Example 2 The previous example showed a report with One Data Value per Row selected. Following is an example of the same report, with the same Category item (STARTTIME), without One Data Value per Row selected. In the first example, you can see that the report shows one row of data for the interval beginning at 10:00 AM, one row of data that includes information for each split/skill for the interval beginning at 10:30 AM, and one row of data for the interval beginning at 11:00 AM.
Changing axis titles To change the title that will display on each axis of the chart report: 1. Depending on the type of chart you are formatting, select the appropriate Axis check box. The following are examples of chart types: bar, line, area, step, clustered bar, horizontal bar, or pie as selected on the Type tab. 2. In the appropriate text box, enter the title you want assigned to the axis. 3.
Data tab Use the Data tab to add, remove, or rearrange data items in the chart. The available data items are the data items that are specified in the query that this chart uses. Example Data tab options You can change the following chart parameters: ● Available Data - Lists all of the data items that are available, based on the query you used for the chart or table. ● Data on Chart - Displays the data items that are currently used in the chart.
Adding, removing, or rearranging data items To add, remove, or rearrange data item: 1. Do one of the following actions: To … Then select an item on the Data on Chart list and … Add data items to the chart Select Add. Remove data items from the chart Select Delete. Rearrange the order in which items display on the chart Use Up and Down to move the item to the appropriate place on the list. 2. Select Apply to make the changes and to keep the Chart Format Options window open. 3.
Data Labels tab Use the Data Labels tab to define where the labels of each data point on the chart will be displayed and to define how the labels will be displayed. Example Data Labels tab options You can specify the following parameters: ● None - No labels are displayed. ● Above Point - The label is displayed above the data point. This location is valid only for bar, line, area, and step charts. ● Below Point - The label is displayed below the data point.
● Left - The label is displayed to the left of the related data point. ● Right - The label is displayed to the right of the related data point. If data point labels are displayed, you can specify that they include one of the following display options: ● Value - The value of the data point displays in the label. ● Percent - The value of the data point displays in the label as a percentage. ● Series Name - The series name is used to label the data point.
Defining data labels on data points To define where the labels of each data point on the chart will be displayed, and to define how the labels will be displayed: 1. In the Location box, select the location where you want the data point labels to display on the chart. 2. In the Show Label Text box, select the option that corresponds with how you want the data point labels to display on the chart. 3. Select Apply to make the changes and to keep the Chart Format Options window open. 4.
Fonts tab Use the Fonts tab to edit the fonts of the title, data point labels, legend, axes, and series labels on the chart report. Example Fonts tab options You can specify the following parameters: ● Fonts - Lists all of the available report items for which you can edit the fonts. ● Choose Font - Takes you to the Font selector window, where you can edit the font size and style for each type of text.
Changing fonts To change the fonts: 1. Select Choose font next to the report item for which you want to change the font. The Font window is displayed. 2. Select the Font, Font style, Size, Effects, Color, and Script that you want assigned to the selected text. 3. Select OK. The Chart Format Options window is displayed. 4. Select Apply to make the changes and to keep the Chart Format Options window open. 5. Select OK to make the changes and to close the Chart Format Options window.
Legend tab Use the Legend tab to control the location of the chart legend. Example Legend tab options The available options on the Legend tab are as follows: ● Visible check box - Allows you to display or not to display the report legends. ● Location of legend - If you elect to have report legends visible, you can select where the legend is displayed. The available options are Top Left, Top (center), Top Right, Left, Right, Bottom Left, Bottom (center), and Bottom Right.
Formatting the chart legend To format the chart legend: 1. Select the Visible check box to make the legend of the chart display on the report. 2. Select the Location (Top Left, Top, Top Right, Left, Right, Bottom Left, Bottom, or Bottom Right) where you want the legend to display on the chart. 3. Do one of the following tasks: ● Select Apply to make the changes and to keep the Chart Format Options window open. ● Select OK to make the changes and to close the Chart Format Options window.
Series Labels tab Use the Series Labels tab to edit the labels, or headings, that are assigned to each data item that is used in a chart. Example Series Labels tab option You can specify the following parameters: ● Labels table - Shows the labels that are currently used in the chart. To edit the text, place the cursor in the Label column and type the appropriate information.
Editing data item headings To edit data item headings: 1. Place the cursor in the table cell that contains the heading, or label, you want to modify. 2. Enter the new name or edit the existing name. 3. Do one of the following tasks: ● Select Apply to make the changes and to keep the Chart Format Options window open. ● Select OK to make the changes and to close the Chart Format Options window.
Title tab Use the Title tab to control the location of the chart title. Example Title tab options The following options are available on the Title tab: ● Visible check box - Allows you to display or not to display the report titles. ● Location - If you elect to have report titles visible, you can select where the titles are displayed. The available options are Top Left, Top (center), Top Right, Left, Right, Bottom Left, Bottom (center), and Bottom Right.
Formatting the title To format the title: 1. Select the Visible check box to make the title of the chart display on the report. 2. In the Title text box, edit the content of the chart title. 3. Select the Location as Top Left, Top, Top Right, Left, Right, Bottom Left, Bottom, or Bottom Right where you want the title to be displayed on the chart. 4. Do one of the following tasks: ● Select Apply to make the changes and to keep the Chart Format Options window open.
Type tab Use the Type tab to change the chart type from 2-dimensional to 3-dimensional, and vice versa. You can also use this tab to specify the type of table you want. For example, you can choose a bar chart or a pie chart. Example Type tab options The available options on the Type tab are as follows: ● 2D and 3D - Changes the chart to 2-dimensional or 3-dimensional views. 2D charts update faster than 3D charts, so if the drawing speed seems too slow, you may want to display charts as 2D.
- Clustered Bar Chart (3D only) - Pie Chart (2D and 3D) ● Stacked - Causes the data for all series to be stacked rather than shown separately. This check box is disabled for pie charts. ● % Axis - Causes the value axis (y-axis) to be displayed as percentages rather than as actual data values. This can be combined with the stacked format to produce a percentage stacked chart.
Selecting a chart type To select a chart type: 1. Based on whether you want the report to display two-dimensionally or three-dimensionally, select 2D or 3D. 2. Select the Chart Type. ● The available types for two-dimensional charts are Bar, Line, Area, Step, Horizontal Bar, and Pie. ● The available types for three-dimensional charts are Bar, Line, Area, Step, Clustered Bar, Horizontal Bar, and Pie. 3.
3D Effects tab Use the 3D Effects tab to control the 3D appearance of the chart. If the current chart is a 2D chart, this tab is disabled. Example 3D Effects tab options You can change the following parameters: ● Elevation - This is a number from 0 through 90 degrees, and describes the relative height from which a chart is viewed. An elevation of 90 looks directly down on the top of the chart, while an elevation of 0 looks directly at the side of the chart.
- Oblique: The chart has depth but the X-Y plane does not change when the chart is rotated or elevated. - Orthogonal: Perspective is not applied to the chart, resulting in less of a 3D effect. The advantage of this type of projection is that vertical lines remain vertical, making some charts easier to read. - Perspective: This provides the most realistic 3D appearance. Objects farther away from you converge toward a vanishing point.
Controlling the 3D appearance To control the 3D appearance of the chart: 1. To change the degree of the top to bottom Elevation of the chart, enter a new number in the Elevation box. 2. To change the degree of Rotation of the chart, enter a new number in the Rotation box. 3. To change the type of Projection used for the chart, select a type from the Projection drop-down list. 4. Edit the ratios of width to height and depth to height, as appropriate. 5.
Chapter 12:Format | Table This section describes the Format | Table menu option. Report Designer allows you to format report tables after they have been inserted on the report. You will use the Table option from the Format menu to edit tables on your designer reports.
Information about how to format tables If you are in a report that contains a table, you can format how the table displays and what is displayed in the table. This section includes the following topics: ● About the Table Format Options window on page 190 ● Accessing the Table Format Options window on page 190 ● How your changes affect others on page 190 About the Table Format Options window Use the Table Format Options window to make layout changes to a table.
General tab Use the General tab to make table format changes to gridlines, column and row scrolling, and orientation. Example General tab options You can change the following table parameters: ● Show Gridlines - This specifies whether grid lines are shown in the table. ● Fixed Columns - This specifies the number of columns from the left of the table that are fixed in place and do not scroll. Valid values are in the range of 0 through 99.
Using the General tab To use the General tab: 1. Select the Show Gridlines check box if you want the table to include lines between the columns and rows. 2. In the Fixed Region box, define the number of Columns on the table that will not scroll. You can enter the appropriate number or use the up and down arrows to select a valid number. 3. In the Fixed Region box, define the number of Rows on the table that will not scroll.
Data tab Use the Data tab to add data items to, to remove data items from, and to reorganize the order of data items on the currently-selected table. Example . Data tab options You can specify the following parameters: ● Available Data - Lists all of the data items that are available, based on the query you used for the chart or table. ● Data on Table - Displays the data items that are currently used in the table.
Using the Data tab To use the Data tab window: 1. To add data items to the table, select an item from the Available Data list and select Add. 2. To remove data items from the table, select an item from the Data on Table list and select Delete. 3. To rearrange the order in which items appear on the table, select an item on the Data on Table list and use Up and Down to move the item to the appropriate place on the list. 4.
Fonts tab Use the Fonts tab to edit the fonts of the data, headers, and summary information on the table report. Example . Fonts tab options You can specify the following paramters: ● Fonts - Lists all of the available report items for which you can edit the fonts. ● Choose Font - Takes you to the Font selector window, where you can edit the font size and style for each type of text.
Using the Fonts tab To change the fonts: 1. Select Choose font next to the report item that you want to change the font. The Font window is displayed. 2. Select the Font, Font style, Size, Effects, Color, and Script that you want assigned to the selected text. 3. Select OK. The Table Format Options window is displayed. 4. Do one of the following actions: ● Select Apply to make the changes and to keep the Table Format Options window open.
Format tab Use the Format tab to alter the format of each column that is included in the table. The database items that make up the columns of the table are listed in the Item column in the Table section. For each Item, you can assign a variety of formatting characteristics. Example Format tab options You can specify the following parameters: ● Item - Shows the database item, and table from which the data is retrieved, that is used for this column of the table.
● Show All Formats - You can select the Show All Formats check box to display the formats that are available for all field types. This check box is active only during the current use of the Format Table window. The next time you access the window, the check box will not be active. ● Zeros as Blanks - Select this check box to display cells on the table that contain zeros as blank. If you do not select the check box, the cells that contain zeros will display zeros.
Using the Format tab To edit the formatting on a table: 1. In the Item column of the table, select the data item that you want to edit. 2. In the Show Value As column, use the drop-down list to select how you want to have the data item displayed. The available values vary, depending on the data item. 3. In the Align column, use the drop-down list to select how you want the data item to be aligned on the table. Available values are Left, Right, and Center. 4.
Headers tab Use the Headers tab to turn table headers on and off and to edit the text that appears in each column heading of the table. Example Headers tab options You can specify the following parameters: ● Header Option - Select the Show Headers check box if you want the table report to include the headers. ● Table Header - This table shows the column headings that are currently used on the report.
Using the Headers tab To change the column headings on the table: 1. Place the cursor in the table cell that contains the heading you want to modify. 2. Enter the new name or edit the existing name. 3. Do one of the following tasks: ● Select Apply to make the changes and to keep the Table Format Options window open. ● Select OK to make the changes and to close the Table Format Options window.
Sort tab Use the Sort tab to specify the order in which the information on the real-time table report is displayed. Example Sort By Criteria Drop-Down Lists Sort Order Sort tab options You can specify the following parameters: ● Sort By - When you set up display order for a real-time report, specify the sort column under Sort By and the sort order as Ascending or Descending. The drop-down list for Sort By lists all of the database table and item names used in the report.
Using the Sort tab When you set up display order for a report, specify the sort column under Sort By and the sort order as Ascending or Descending. The drop-down list for Sort By lists all of the database table and item names used in the report. Some examples of sorting are as follows: ● Viewing a list of agents alphabetically on page 203 ● Searching for agents on page 203 Viewing a list of agents alphabetically To view a list of agents alphabetically: 1.
Summary tab Use the Summary tab to include or exclude summary lines from the currently-selected table. You can include a summary line for each query that is used in the report. If this table includes an integrated query, the Summary tab will not display. Example Summary tab options You can specify the following parameters: ● Summary Options - Allows you to include or exclude summary (totals) lines on table reports.
Using the Summary tab To include a summary line: 1. Select Show Summary. 2. Select a query from the Query box. 3. Select Top or Bottom, based on where you want the summary line to be located. 4. Do one of the following tasks: ● Select Apply to make the changes and to keep the Table Format Options window open. ● Select OK to make the changes and to close the Table Format Options window.
Avaya CMS Supervisor Report Designer
Chapter 13:Format | Field This section describes the Format | Field menu option. Use Report Designer to format report fields after they have been inserted on the report. You will use the Field option from the Format menu to edit fields on your designer reports.
The Field Format Options window Use the Field Format Options window to choose the formats for fields defined in queries. To open the Field Format Options window, select Field from the Format menu. Example Field Format Options field descriptions The Field Format window includes the following options: Field Description Visible check box Allows to display or not display report legends.
Field Description Label Enter a brief description of the field. For example, for a field that displays the name of the split/skill for which the report was run, you might label the field Split/Skill. Font (in the Field Label box) Opens the Font window, which allows you to change any of the font attributes for the field label. Format Provides a drop-down list to select the format which you want the value to be displayed. Align Allows you to select the alignment of a field or column in a table.
Creating or changing a label for the field To create or change a label for the field: 1. Select the field on the report. 2. Select Field from the Format menu. The Field Format Options window is displayed. This window allows you to create a label or heading for the field, and to edit the format of the field itself. 3. From the Field Label box, select the Visible check box. 4. Select the location (Above, Below, Left, or Right) where you want the label to appear. 5.
Editing the format of a field To edit the format of a field on your report: 1. Select the field on the report. 2. Select Field from the Format menu. The Field Format Options window is displayed. This window allows you to create a label or heading for the field, and to edit the format of the field itself. 3. From the Format drop-down list, select the format in which the field will display. The options available for the field format will depend on the type of field you want to edit.
Avaya CMS Supervisor Report Designer
Chapter 14:Format | Text This section describes how to use the Format | Text menu option. Report Designer allows you to format the font style and size of text that appears on a report. You will use the Text option from the Format menu to edit text on a report.
The Text Format Options window To open the Text Format Options window, select a text item on the report and then select Text from the Format menu. The Text Format Options window allows you to change the font display characteristics for the selected text. Example Text Format Options parameters You can specify the following parameters: ● Text contents - Enter the word or phrase that you want to insert on the report in this text box.
Formatting text To format text on a report: 1. Select the text on the report. 2. Select Text from the Format menu. The Text Format Options window is displayed. 3. Select Font. The Font selector window is displayed. 4. Select the Font, Style, Point size, Effects, and Script that will apply to the text string you want to edit. 5. Select OK. The Font selector window is closed. 6. Do one of the following tasks: ● Select Apply to make the changes and to keep the Text Format Options window open.
Avaya CMS Supervisor Report Designer
Appendix A: Error messages This section describes Report Designer error messages and what to do to resolve the error messages. The errors described in this section usually are the result of a problem in the query that you want to test.
Phase 1 error messages This section contains information about Phase 1 error messages. The following table lists the phase 1 error messages alphabetically, and includes a cause and a recommended solution for each message. Message Cause Solution $ not defined The WHERE clause contains a variable that is not defined. Define the variable using the define input action or remove the variable from the row search criteria.
Message Cause Solution Avaya CMS system error Updating translations CMS cannot test the row search criteria while CMS is receiving the set of configuration data from the communication server. Wait until configuration data has been sent. Then rerun the test of report design. keyword invalid in where clause You cannot use the specified keyword in a row search criteria. Remove the specified keyword from the row search criteria.
Phase 2 historical report error codes This section contains the CMS database error codes that are most likely to appear for CMS historical reports. This section includes the following topics: ● Format on page 220 ● List of phase 2 error codes on page 220 Format These errors are reported in the following format: INFORMIX error: In addition, a circumflex (^) may appear to mark the location of an error.
Error Description Solution 203 An illegal integer has been found in the statement. Integers must be whole numbers from -2,147,483,647 to 2,147,483,647. Verify that you have not included a number with a fractional portion or a number outside the acceptable range. Verify also that you have not inadvertently entered a letter in place of a number (for example, 125p3 instead of 12503). 204 An illegal floating-point number has been found in the statement.
Error Description Solution 300 There are too many GROUP BY columns (maximum is eight). Reduce to eight or fewer the number of nonaggregate database items that are assigned the same row search ID as that assigned to an aggregate function. 301 The total size of the GROUP BY columns exceeds 120 characters. The total number of characters in all columns listed in the GROUP BY list exceeds 120 characters.
Error Description Solution 1205 Invalid month in date. Months must be represented as the number of the month (01 through 12). Verify the value entered in the date field. 1206 Invalid day in date. Days must be represented as the number of the day (01 through 31). Verify the value entered in the date field. 1226 Decimal or money value exceeds maximum precision. Increase the precision of the DECIMAL or MONEY field.
Phase 3 real-time report error codes Phase 3 real-time report error codes contains the Real-Time Database Manager error codes. Each code includes a description of the error and a recommended solution. This section includes the following topics: ● Format on page 224 ● List of phase 3 error codes on page 224 Format These errors are reported in the following format: Avaya CMS Database Manager error: In addition, a circumflex (^) appears to mark the location of an error.
Error Description Solution 5 A mixture of aggregates and nonaggregates are being selected, and this is not allowed in real-time reports. (This error code can also mean mismatched types in comparison.) Create two identical row search conditions, and apply one to the aggregate columns and one to the nonaccredited columns. 6 Bad column in the order by clause.
Avaya CMS Supervisor Report Designer
Appendix B: How CMS stores and retrieves data The most important and difficult part of designing a report is defining the data that goes into the report. To define report data, you must first understand how the Avaya Call Management System (CMS) stores and retrieves data.
How CMS stores data This section includes the following topics: ● Table on page 228 ● Database items on page 228 ● Row on page 228 ● Index on page 228 Table CMS stores data in a CMS database that is divided into 52 different tables.
value in an index column, the remaining values in the corresponding row are related to that value.
How CMS retrieves data This section includes the following topics: ● Three types of information on page 230 ● How to tell CMS to retrieve data on page 230 ● Identify rows on page 230 ● Indexes for search on page 231 ● About creating new database tables on page 231 Three types of information CMS retrieves data from the database based on the following types of information that you supply when you design a report: ● The name of the table ● The database items in the table ● The rows of data in th
The data that CMS reports is the data found in the intersection of the selected database items and rows. Therefore, the report shows data that is similar to the data shown in this figure.
Next, you must identify the appropriate rows that supply data. You might want data for the following items: ● Split 1, which means you must identify rows that have the value 1 for the SPLIT database item. ● The date 07/02/02, which means you must identify rows with the value 070202 for the ROWDATE database item. ● The intrahour intervals 8:00 a.m. to 11:00 a.m., which means you must identify rows with the values 0800 through 1100 for the one database item. CMS then finds the appropriate rows of data.
Appendix C: Report Designer examples This section provides examples to help you create and modify reports with Report Designer.
Creating an integrated report The following procedure shows how to create an integrated report in Report Designer that displays agent states. To create an integrated report that displays agent states: 1. From the toolbar, select Reports. The Select a Report window is displayed. 2. Select New. The Design Mode window is displayed. 3. From the Edit menu, select Inputs. The Edit Inputs window is displayed. 4. From the Input Types list, select Split/Skill, and select Add. 5. Select OK. 6.
18. Name your report status, and select Only Me. 19. Select OK. Notice that your report is now displayed in the Integrated Designer Category. 20. From the Insert menu, select chart. The Chart Assistant window is displayed. 21. From the Queries drop-down list, select chart. 22. Select Add All. All data are added to the Data on Chart list. 23. Select Next. 24. Select 2D. 25. Select Bar Graph for your chart type, and select Next. 26. Select (none) in the Available Data list, and select Done. 27.
Modifying an integrated report This section describes how to modify an existing report with Report Designer. To modify an existing report: 1. From the Select a Report window, select the Integrated tab. 2. In the Category list, select Designer. 3. In the Report list, select the report you just created, and select Edit. 4. From the Edit menu, select Queries. A Query Assistant window is displayed. 5. Select New. 6. In the Database frame, select Integrated. 7.
19. From the Insert menu, select Table. The Table Assistant window is displayed. 20. From the Queries drop-down list, select table, and select Add All. 21. Select Next. 22. In the Orientation frame, select Vertical. 23. In the Options frame, select Headers On and Grid Line On. 24. Select Done. Your report now has a chart and a table. 25. Move the table so that you can see both the chart and table. By default, the second section (your table) will overlay the first section (your chart). 26.
Creating an expanded AUX reason code report The standard CMS Supervisor reports for R13 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.
● TI_AUXTIME ● TI_AUXTIME0 through ● TI_AUXTIME99 16. Select Next. The system displays the Query Assistant window. 17. Select Next. The system displays the Query Assistant window. 18. Locate the Operand1, Operator, and Operand2 lists. 19. Scroll through the lists and select: ● LOGID as Operand1 ● = as the Operator ● [Agent] as Operand2 20. Select the AND button. 21. Scroll through the lists and select: ● ROW_DATE as Operand1 ● = as the Operator ● [Date] as Operand2 22.
34. Select the Done button. 35. Select from the menu bar Report > Run. 36. Save the report when you exit. Select from the menu bar Report > Exit.
Glossary ACD See Automatic Call Distribution. Actions menu A menu in the upper-left corner of the Avaya CMS Supervisor Operations windows. The menu lists the actions available for that particular user window (for example, add, modify, and delete). You select an action after entering the necessary data in the user window. Add An Avaya CMS Supervisor action that adds the data entered in the given window to the Avaya CMS database.
Automatic Call Distribution (ACD) A communication server feature that uses software to channel high-volume incoming and outgoing call traffic to agent groups (splits or skills). Also an agent state where the extension is engaged on an ACD call. Automatic script An Avaya CMS Supervisor feature that launches a new Avaya CMS Supervisor session that logs into Avaya CMS and runs the requested tasks in the background. Actions do not display on the PC. See also Interactive Script and Script.
Database table Avaya CMS uses these tables to collect, store, and retrieve ACD data. Standard Avaya CMS items (database items) are names of columns in the Avaya CMS database tables. Data points Points of historical data. A data point should include data for each interval of the working day. Delete An Avaya CMS Supervisor action that removes the entry on the window from the Avaya CMS database. Designer reports Customized reports that can be created with Avaya CMS Supervisor’s Report Designer feature.
Historical reports Display past ACD data for various agent, split/skill, trunk, trunk group, vector, or VDN activities. A report summary of call data into daily, weekly or monthly totals HTML See HyperText Markup Language. Hypertext A linkage between related text. For example, if you select a word in a sentence, information about that word is retrieved if it exists, or the next occurrence of the word is found. HyperText Markup Language A standard for defining documents with hypertext links.
Log A file that contains a record of computer activity as well as backup and recovery data. Maintenance An Avaya CMS subsystem that is used for doing routine maintenance of the Avaya CMS, such as backing up data, checking on the status of the connection to the communication server, and scanning the error log.
Scripting An Avaya CMS feature that lets you automate actions such as changing an agent’s skills, running reports, exporting report data, and many other Avaya CMS functions. For example, you can create a script to run a specified report and export the data on schedule. Scroll To use the bar on the side of the report window to move forward, backward, up, or down within a window.
Terminal emulator An Avaya CMS Supervisor software application that emulates a 615 Color (615C) terminal. Toolbar A row of controller buttons used to activate various functions of the Avaya CMS Supervisor application. Tooltips Brief descriptions that display when the mouse pointer is over a toolbar button. Trunk group report Displays the status of each trunk in a selected trunk group. User ID The login ID for an Avaya CMS user. VDN See Vector Directory Number.
Avaya CMS Supervisor Report Designer
Index Symbols % Axis check box . . . . . . . . . . . . . . . . . 184 Numerical 100 AUX reason codes, creating reports 2D field . . . . . . . . . . . . . . . . 2D Horizontal Bar Chart . . . . . . . . 2D Horizontal Stacked Bar Chart . . . . 2D Line Bar Chart . . . . . . . . . . . 2D Pie Bar Chart . . . . . . . . . . . 2D Stacked Area Bar Chart . . . . . . 2D Vertical Bar Chart . . . . . . . . . 2D Vertical Stacked Bar Chart . . . . . 2D, change to 3D . . . . . . . . . . . 3D appearance, control . . . . . . .
C Calculations field . . . . . . . . . . . . . . . . . .114 call record data . . . . . . . . . . . . . . . . . . 56 call work code data . . . . . . . . . . . . . . . . . 56 Call Work Code field . . . . . . . . . . . . . . . 100 Cancel button on Report Wizard. . . . . . . . . . . 20 category . . . . . . . . . . . . . . . . . . . . . 166 Category Name field . . . . . . . . . . . . . . . 173 Center field . . . . . . . . . . . . . . . . . . . 172 change axis titles . . . . . . . . . . . . . . . . . . .
Left . . . . . . . . . . . . . . . . . . None . . . . . . . . . . . . . . . . . Outside . . . . . . . . . . . . . . . . Percent . . . . . . . . . . . . . . . . Right . . . . . . . . . . . . . . . . . Series Name . . . . . . . . . . . . . . Value . . . . . . . . . . . . . . . . . data on chart . . . . . . . . . . . . . . . data on table . . . . . . . . . . . . . . . data retrieval . . . . . . . . . . . . . . . data storage . . . . . . . . . . . . . . . . Data tab about . . . . . . . . . . . . . . . . .
Format . . . . . . . . . . . . . . . . . . . . 209 format . . . . . . . . . . . . . . . . . . 207, 210 Input Values . . . . . . . . . . . . . . . . . 146 Label (format) . . . . . . . . . . . . . . . . 209 Location on Field Format Options window . . . 208 Location on Legend tab . . . . . . . . . . . . 177 Multi-value . . . . . . . . . . . . . . . . . . 105 New Input . . . . . . . . . . . . . . . . . . .119 pattern matching . . . . . . . . . . . . . . . . 98 Prompt . . . . . . . . . . . . . . . . . . . .
chart on a report . . . . . . . . . . . . data item fields on the report . . . . . . Input Value fields on the report . . . . . Report Data Start Time field on the report table on the report . . . . . . . . . . . text on the report . . . . . . . . . . . . Time Report Run field on the report . . . Insert | Chart . . . . . . . . . . . . . . . Insert | Field . . . . . . . . . . . . . . . . Insert | Table . . . . . . . . . . . . . . . Insert | Text . . . . . . . . . . . . . . . . Insert menu . . . . . . . . . .
query copy . . . . . . . . . create historical . . . . create integrated . . . create real-time . . . . define . . . . . . . . delete . . . . . . . . Edit | Queries menu . . edit historical . . . . . edit integrated . . . . edit real-time . . . . . Query Assistant input fields . . . . . . window . . . . . . . . Query Items field . . . . . query select . . . . . . . QUEUED trunk state name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Save Report page in Report Wizard. . . . . . Save the report being copied as button . . . . Script button on Report Selector window . . . SEIZED trunk state name . . . . . . . . . . select chart type . . . . . . . . . . . . . . . . field type . . . . . . . . . . . . . . . . . multiple items on the report . . . . . . . . Select a Data Group page . . . . . . . . . . Select a Data Group page in Report Wizard . . Select a Report Layout page in Report Wizard. Select a Report Type page in Report Wizard .
U undo alignment. . . . . . . . . . . . cuts or deletions . . . . . . . . Undo Align Controls field . . . . . . Undo Cut/Delete field . . . . . . . . update rate in seconds . . . . . . . Use First data item as chart title field user permissions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 65 65 65 96 39 71 . . . . . . . . 173 101 101 191 V Value field . . . . . . . VDN field . . . . . . . Vector field . .
