Lucent Technologies Centrevu Report Designer Version 8 User Guide

							  Insert | Field CentreVu Report Designer Version 8 User Guide
Inserting Time Report Run Field on the Report9-7
Inserting Time Report Run Field on the Report9
Do not position the field on top of any grids or charts because the 
grid/chart will display on top of the field and the field will not be visible.
To insert on the report the time at which the report was run, complete the 
following steps:
1. Select Field from the Insert menu.
The Field Assistant wizard opens.
2. Highlight Time Report Run in the Types box.
3. Select the D
one button.
The Time Report Run field is placed in the upper left-hand corner of 
the report.
4. Click on the item and drag-and-drop it to the location where you 
would like it displayed in the report. 
						

							  Insert | Field CentreVu Report Designer Version 8 User Guide
Inserting Time Report Run Field on the Report9-8 
						

							  Insert | Table CentreVu Report Designer Version 8 User Guide
Introduction10-1
10  Insert | Table
Introduction10
Once you have defined queries (see Chapter 7, “Edit | Queries”) to be used 
for a report, you can use those queries to add a table to the report using the 
Table Assistant, which is accessed by selecting Table from the Insert menu.
This chapter teaches you to use the Insert | Table menu option. The 
sections of the chapter are as follows:
lInserting a table on the report
lUsing the Table Assistant “Select a query and associated database 
items for the table” window (Steps 2 through 4)
lUsing the Table Assistant “Select a table layout” window (Steps 5 
through 9)
lUsing the Table Assistant “Select an existing query for the Summary line 
on your table, or create a new one” window (Steps 10 through 11). 
Each item is initially inserted in the upper left hand corner of the report. You 
will need to drag-and-drop the table to the location where you would like it to 
display on the report.
If you would like to edit a table, select the table and then choose Table from 
the Format menu. 
						

							  Insert | Table CentreVu Report Designer Version 8 User Guide
Inserting a Table on the Report10-2
Inserting a Table on the Report10
If the report includes both a chart and a table, you need to place the chart 
above the table on the report. The reason for this is, if the table spans 
multiple pages when printed and the chart is below the table on the 
report, then the table will print on top of the chart.
Do not position text and fields on top of the table because the table will 
display on top of the text/field and the text/field will not be visible.
To insert a table on a report, complete these steps:
1. Select Ta b l e from the Insert menu.
The “Select a query and associated database items for the table” 
window of the Table Assistant appears:
2. From the Q
ueries drop-down list, select the query from which you 
want to take data for the table. Note that any queries that have been 
created, but still include errors are greyed-out.
The Available Data box is populated with the data that was 
previously defined for the query.
3. Use the A
dd, Add All, Remove, and Remove All buttons to add 
and remove items from the Av
ailable Data box to the Data on Table 
box.
Use the Move U
p and Move Down buttons to place the data items 
shown in the Data on T
able box in the order in which you want them 
to appear on the table.
Items that are added to the Data on Table box will be shown in the 
table you are creating. 
						

							  Insert | Table CentreVu Report Designer Version 8 User Guide
Inserting a Table on the Report10-3
4. Select the N
ext button.
The “Select a table layout” window appears.
Any of the options you select in Steps 5 through 10 can be changed 
after you have inserted the table on the report by selecting the 
Format |Table menu item.
5. Define the Orientation of the table by selecting either the 
H
orizontal or the Vertical radio button.
6. Add a Summary line to the table by selecting the T
op radio button 
to place the Totals line at the top of the table (as standard CMS 
reports do) or the Bo
ttom radio button to place the Totals line at the 
bottom of the table. Select the None
 radio button if you do not want 
to include a Totals line on this table.
7. Select the Headers O
n check box if you would like to include 
column headers on the table.
8. Select the G
rid Lines On check box if you would like the table to 
include lines between the columns and rows.
9. If you elected to include no Summary line on the table, select the 
D
one button. The Table Assistant closes and the table is placed on 
the report template.
If you elected to include a Summary line on the table, select the 
N
ext button.
NOTE: 
						

							  Insert | Table CentreVu Report Designer Version 8 User Guide
Inserting a Table on the Report10-4
The “Select an existing query for the Summary line on your table, or 
create a new one” window appears.
10. If you would like to create a new query for the summary line on this 
table, complete the following steps:
a. Select the Buil
d a New Query radio button.
b. Type a name for the summary query in the Name field.
c. Edit the table to include the database items and summary 
information that you feel is appropriate for this summary query.
d. Select the D
one button.
If you would like to use an existing query for the summary line on 
this table, complete the following steps:
a. Select the S
elect an Existing Query radio button.
The “Select an Existing query for the Summary line on your 
table, or create a new one” window for the existing query 
selection appears. 
						

							  Insert | Table CentreVu Report Designer Version 8 User Guide
Inserting a Table on the Report10-5
b. Select the name of one of the existing queries from the drop-
down Q
ueries list.
11. Select the D
one button. 
						

							  Insert | Table CentreVu Report Designer Version 8 User Guide
Inserting a Table on the Report10-6 
						

							  Insert | Text CentreVu Report Designer Version 8 User Guide
Introduction11-1
11  Insert | Text
Introduction11
The 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. 
This chapter teaches you how to use the Insert | Text menu option. 
Each item is initially inserted in the upper left hand corner of the report. You 
will need to drag-and-drop the text to the location where you would like it to 
display on the report.
If you would like to edit text, select the text and then choose Text from the 
Format menu. 
						

							  Insert | Text CentreVu Report Designer Version 8 User Guide
Inserting Text on the Report11-2
Inserting Text on the Report11
Do not position the text on top of any tables or charts because the 
table/chart will display on top of the text and the text will not be visible.
To insert a text string on a report, complete these steps:
1. Select Te x t from the Insert menu.
The Text Assistant appears:
2. Type the text that you want to appear on the report in the T
ext 
contents field.
3. If you want to select a specific font for the text, select the Font 
button.
If you want to leave the font set to the default, go to Step 6.
The Font selector window, which is a standard 
Windows* window, 
displays.
4. Select the Font, Style, Point size, Effects, and Script that will 
apply to the text string you are creating.
5. Select the OK button.
The Font selector window closes.
6. On the Text Assistant window, select the OK button to insert the text 
string and close the window, or select the A
pply button to apply the 
changes you have made and keep the window open.
The text is inserted, by default, in the upper lefthand corner of the 
Design Mode window. You can use the cut, copy, or drag-and-drop 
method, as outlined in Chapter 4, to move the text to the appropriate 
location on the report.
*Windows is a registered trademark of Microsoft Corp.