Lucent Technologies Centrevu Report Designer Version 8 User Guide

							  Format | Table CentreVu Report Designer Version 8 User Guide
Fonts Tab13-7
Using the Fonts 
Ta b
13
To change the fonts, complete the following steps:
1. Select the Choose font button next to the report item for which you 
would like to change the font.
2. The Font window, which is a standard 
Windows* window, appears.
3. Select the Font, Font style, Size, Effects, Color, and Script which 
you want assigned to the selected text.
4. Select the OK button.
The Table Format Options window appears.
5. Select the Apply button to make the changes and to keep the Table 
Format Options window open.
Select the OK button to make the changes and to close the Table Format 
Options window.
*Windows is a registered trademark of Microsoft Corp. 
						

							  Format | Table CentreVu Report Designer Version 8 User Guide
Format Tab13-8
Format Tab13
The Table Format tab allows you 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 of the Table table. For each Item, 
you can assign a variety of formatting characteristics.
Format Tab 
Options
13
lItem — Shows the database item (and table from which the data is 
retrieved) that is used for this column of the table.
lShow Value As — Use the drop-down list to select the format in 
which you would like the value to be displayed. The Show Value As 
formatting applies only to data types that can be defined in the 
Dictionary.
lAlign — Allows you to select the alignment of a field or column in a 
table. Available options for alignment are Left, Right, and Center.
lFormat — The options available for the format will depend on the 
type of item you are editing. For instance, a field that displays time 
will allow you to choose from a variety of time formats. A field that is 
a number will allow you to choose from a variety of number formats.
lShow All Formats — You can select the Show All Formats check 
box to display the formats that are available for all field types. Note 
that the selection of 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 selected. 
						

							  Format | Table CentreVu Report Designer Version 8 User Guide
Format Tab13-9
lZeros 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.
lMerge with Next — Select the check box to merge this column with 
the column to the right on the table.
Using the Format 
Ta b
13
To use the Format tab, complete the following steps:
1. In the Item column of the table, select the data item for which you 
would like to edit the formatting on the table.
2. In the Show Value As column, use the drop-down list to select how 
you would like to have the data item displayed in the table. The 
available values will vary, depending on the data item.
3. In the Align column, use the drop-down list to select how you would 
like the data item to be aligned on the table. Available values are 
Left, Right, and Center.
4. In the Format column (if available), select the time format or the 
number format (as appropriate) in which you would like the data item 
displayed. The available choices reflect the specific data item you 
are formatting.
5. In the Show All Formats column, select the check box if you would 
like the Format column to display all of the available data formats, 
regardless of the type of data item that you are working with.
6. In the Zeros as Blanks column, select the check box if you would 
like 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.
7. In the Merge with Next column, select the check box to merge this 
column with the column to the right on the table. 
						

							  Format | Table CentreVu Report Designer Version 8 User Guide
Headers Tab13-10
Headers Tab13
The Headers tab allows you to turn table headers on and off and to edit 
the text that appears in each column heading of the table.
Headers Tab 
Options
13
lHeader Option — Select the Show Headers check box if you would 
like the table report to include the headers.
lTable Header — This table shows the column headings that are 
currently used on the report.
Using the 
Headers Tab
13
To change the column headings on the table, complete these steps:
1. Place the cursor in the table cell that contains the heading you 
would like to modify.
2. Type the new name or edit the existing name.
3. Select the Apply button to make the changes and to keep the Table 
Format Options window open.
Select the OK button to make the changes and to close the Table Format 
Options window. 
						

							  Format | Table CentreVu Report Designer Version 8 User Guide
Sort Tab13-11
Sort Tab13
The Sort tab allows you to specify the order in which the information on 
the real-time table report is displayed. 
Sort Tab Options13lSort by — When you are setting up display order for a real-time 
report, specify the sort column (Sort By) and the sort order 
(Ascending or Descending). The drop-down list for the Sort By lists 
all of the database table and item names used in the report.
Sort By CriteriaSort OrderDrop-Down Lists 
						

							  Format | Table CentreVu Report Designer Version 8 User Guide
Sort Tab13-12
Using the Sort 
Ta b
13
When you are setting up display order for a report, specify the sort 
column (Sort By) and the sort order (Ascending or Descending). The 
drop-down list for the Sort By lists all of the database table and item 
names used in the report.
Some examples of sorting are as follows:
lViewing a list of agents alphabetically — select “Name” from the first 
Sort By drop-down list, select Ascending as the sort order, and leave 
the other two Sort By boxes set to “(none)”.
lSearching for agents who have been in a certain state for too long 
— select “WORKMODE” from the first Sort By drop-down list, then 
select “TIME” from the second Sort By drop-down list, and then 
select Descending as the sort order for the second Sort By.
Sorting may cause the report to take longer to refresh. If you wish to 
speed up the refresh rate, turn off the sort options by selecting “(none)” 
for all of the Sort By criteria. 
						

							  Format | Table CentreVu Report Designer Version 8 User Guide
Summary Tab13-13
Summary Tab13
Use the Table Format Summary tab to include or exclude summary lines 
from the currently select table. You can include a summary line for each 
query that is used in the report.
If this table includes an integrated query, then the Summary tab will not 
display.
Summary Tab 
Options
13
lSummary Options — Allows you to include or exclude summary 
(totals) lines on table reports.
Select the check box to include a summary line on the table, then select 
the query for which you would like to include a summary. 
						

							  Format | Table CentreVu Report Designer Version 8 User Guide
Summary Tab13-14
Using the 
Summary Tab
13
To include a summary line, complete the following steps:
1. Select the Show Summary check box.
2. Select a query from the Query box.
3. Select the To p or the Bottom radio button, based on where you 
would like the summary line to be located.
4. Select the Apply button to make the changes and to keep the Table 
Format Options window open.
Select the OK button to make the changes and to close the Table Format 
Options window. 
						

							  Format | Field CentreVu Report Designer Version 8 User Guide
Introduction14-1
14  Format | Field
Introduction14
The Report Designer allows you 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. 
This chapter teaches you how to use the Format | Field menu option. The 
sections of this chapter are as follows:
lField Format Window Elements
lUsing the Field Format Window. 
						

							  Format | Field CentreVu Report Designer Version 8 User Guide
Field Format Window Elements14-2
Field Format Window Elements14
Selecting Field from the Format menu opens the Field Format Options 
window. The Field Format Options window is where you will choose the 
formats for fields defined in queries.
The Field Format window includes the following options:
lField Label Location frame — the Field Label Location frame 
provides the following options:
—Visible check box — allows you to display or not display 
report legends.
—Location of legend — if you elect to have report legends 
visible, you can select where the legend displays. The available 
options are Top left, Top (center), Top right, Left, Right, Bottom 
left, Bottom (center), and Bottom right.
lLabel box — Type a brief description of the field. For instance, for a 
field that displays the name of the split/skill for which the report was 
run, you might label the field “Split/Skill.”
lFont box — Opens the Font window, which allows you to change 
the Font, Font style, Size, Effects, Color, or Script box; or the OK, 
Cancel, or Help button to access quick definitions of the window 
elements.
lField Content Format box — Shows the query and the database 
item that this field is associated with.
lAlign box — Allows you to select the alignment of a field or column 
in a table. Available options for alignment are Left, Right, and 
Center.