INTERVAL AND DAILY REPORT IN CMS, COMBINED? 3

[gany]

hi. im a newbie in cms report design. is this format possible in cms report?....

----------------------------------------------------
CALLSOFFERED

time mon tue wed thu fri sat sun

Total 3 1 9 2 7 10 10

12:00-12:30 3 0 1 2 1 2 5
12:30-1:00 0 1 8 0 6 8 5
.
.
.


does anybody know how to create a report like this in cms design? thanks.

 

[jfh9219]

yes.

Not easily however. Think that each day needs to be a separate query. Your inputs might be Date: (Sunday's date), and Skills:. The query's WHERE clause would specify:

Query1: ROW_DATE=[Date:]
Query2: ROW_DATE=([Date:]-1)
...
Query7: ROW_DATE=([Date:]-6)

You then have to build your output view.

If I were you, I would dump the results of a report to an output file and then use Excel to create a pivot table in the format I wanted. For me I would write a VB program that executes/saves/processes the CMS data, outputting the desired report.