Cisco Cisco IPCC Web Option ユーザーガイド
Appendix A Creating Sample Report Templates
Sample Historical Template
A-16
Template Design Guide Using InfoMaker for Cisco ICM/IPCC Enterprise & Hosted Editions, Release 7.0(0)
–
Click OK.
Step 4
Create the Where clause as follows:
a.
Click the Where tab at the bottom of the Table Layout screen.
b.
Create this three-part Where clause:
•
for Column, select
Service.SkillTargetID
fom the drop-down list.
•
for Operator, select
in
from the drop-down list.
•
for Value, right click, select Arguments, and paste :
list_of_persvc.
c.
for Logical select
and
to add a second row.
d.
for Column, select
Service_Half_Hour,DateTime.
e.
for Operator, select
>.
f.
for Value, right click, select Arguments, and paste :
start_date.
g.
for Logical, select
and
to add a third row.
h.
for Column, select
Service_Half_Hour,DateTime
.
i.
for Operator, select
<=
.
j.
for Value, right click, select Arguments, and paste :
end_date
.
Step 5
From the InfoMaker toolbar, click Return. This opens the Tabular Report
Generator wizard.
Generator wizard.
Step 6
Click Next and then Finish to accept the defaults.
Step 7
At the Specify Retrieval Arguments dialog box, enter values that pertain to your
database, or click Cancel to display the template with no data.
database, or click Cancel to display the template with no data.