Lucent Technologies Centrevu Report Designer Version 8 User Guide

							  Format | Field CentreVu Report Designer Version 8 User Guide
Field Format Window Elements14-3
lFormat — Use the drop-down list to select the format which you 
would like the value to be displayed.
lShow Value as Name — Shows the field as name.
lFont box — Opens the Font window, which allows you to change 
the Font, Font style, Size, Effects, Color, or Script box.
Under field content, Effects and Color are not available. 
						

							  Format | Field CentreVu Report Designer Version 8 User Guide
Using the Field Format Options Window14-4
Using the Field Format Options Window14
To format a field on your report, complete the following steps:
1. Select the field on the report.
2. Select Field from the Format menu.
The Field Format Options window appears. This window allows you 
to create a label (heading) for the field and to edit the format of the 
field itself.
3. To create or change a label (heading) for the field, complete the 
following steps in the Field Label box:
a. Select the Visible check box.
b. Select the Location (Above, Below, Left, or Right) where you 
would like the label to appear in relation to the field by selecting 
the appropriate radio button.
c. In the Label field, type the word(s) that you would like the label 
to display.
d. To change the font of the label, select the Font button to 
access the Font window.
4. To edit the format of the field, complete the following steps in the 
Field Content box:
a. Select the format in which the field will display from the Format 
drop-down list.
The options available for the field format will depend on the 
type of field 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.
You can select the Show All Formats check box to display the 
formats that are available for all field types.
b. Select the alignment of the field from the Align drop-down list.
The options available for alignment are Left, Right, and Center. 
						

							  Format | Field CentreVu Report Designer Version 8 User Guide
Using the Field Format Options Window14-5
c. Select the Show Value as Name check box if you are editing a 
field that displays a CMS entity (split/skill, agent, and so on) 
that can be named in the Dictionary and you would like the 
Dictionary name for the field to display instead of the number.
d. To change the font of the field, select the Font button to access 
the Font window.
5. Select Apply to make the changes but to keep the Field Format 
Options window open for additional changes.
Select OK to apply the font changes and to close the Field Format 
Options window. 
						

							  Format | Field CentreVu Report Designer Version 8 User Guide
Using the Field Format Options Window14-6 
						

							  Format | Text CentreVu Report Designer Version 8 User Guide
Introduction15-1
15  Format | Text
Introduction15
The 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. 
This chapter teaches you to use the Format | Text menu option. 
						

							  Format | Text CentreVu Report Designer Version 8 User Guide
Text Format Options Window Elements15-2
Text Format Options Window Elements15
Selecting Text from the Format menu when a text item on the report is 
selected opens the Text Format Options window. The Text Format 
Options window allows you to change the font display characteristics for 
the selected text.
lText contents — Type the word or phrase that you would like to 
insert on the report in this text box.
lText font — 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. 
						

							  Format | Text CentreVu Report Designer Version 8 User Guide
Formatting Text on the Report15-3
Formatting Text on the Report15
To format text on a report, complete these steps:
1. Select the text on the report.
2. Select Text from the Format menu.
The Insert Text window appears:
3. Select the Font button. 
The Font selector window, which is a standard 
Windows* window, 
appears.
4. Select the Font, Style, Point size, Effects, and Script that will 
apply to the text string you are editing.
5. Select the OK button.
The Font selector window closes.
6. On the Text Format Options window, select the OK button to accept 
the font changes and to close the window.
Select the Apply button to apply the changes you have made and to 
keep the window open.
*Windows is a registered trademark of Microsoft Corp. 
						

							  Format | Text CentreVu Report Designer Version 8 User Guide
Formatting Text on the Report15-4 
						

							  Error Messages CentreVu Report Designer Version 8 User Guide
Introduction16-1
16  Error Messages
Introduction16
This chapter describes the kinds of error messages that Report Designer 
displays and tells you what to do when error messages appear. 
Test design error messages are divided into three categories:
lPhase 1 Error Messages
lPhase 2 Historical Report Error Messages
lPhase 2 Real-Time Report Error Messages.
The errors described in this chapter usually are the result of a problem in the 
query that you are testing. 
						

							  Error Messages CentreVu Report Designer Version 8 User Guide
Phase 1 Error Messages16-2
Phase 1 Error Messages16
This section contains Phase 1 error messages. The following table lists 
the messages alphabetically, and includes a cause and a recommended 
solution for each message. 
Message: $ not defined
Cause:The WHERE clause contains a variable that is not 
defined.
Solution:Define the variable using the define input action or 
remove the variable from the row search criteria.
Message: Cannot mix aggregates and nonaggregates in the 
select
Cause:You cannot specify both aggregate columns and 
nonaggregate columns in the same select for real-time 
reports.
Solution:Create two identical row search conditions and apply one 
to the aggregate columns and one to the nonaggregate 
columns.
Message: Cannot use the SYN function for order by
Cause:You cannot use a synonym to sort the output in the query.
Solution:Remove the aggregate from the Order by 
field. Use 
grid sorting to order the item.
Message: CMS system error - Check the error log
Cause:A 
CentreVu®  CMS system error occurred while the select 
executed. The error should be recorded in the error log.
Solution:Check the error in the error log to initiate corrective action.
If you run a report that merges data from two tables 
(particularly tables with large amounts of data) into a 
single field and your Select rows where 
statement is 
not specific enough, you may get this error message. The 
specific cause may be that the number of selected rows is 
very large, and 
CentreVu CMS does not have enough 
space to create temporary files. If this is the case, you 
should add additional “where” clauses to the row search 
criteria.
Message: CMS system error - Data collection off