Avaya Support Forums

Avaya Support Forums (http://support.avaya.com/forums/index.php)
-   Contact Center Applications (http://support.avaya.com/forums/forumdisplay.php?f=3)
-   -   CMS Custom Report (http://support.avaya.com/forums/showthread.php?t=14251)

mkopiec 04-17-2020 09:31 AM

CMS Custom Report
 
Hello,
I am trying to use designer to create a custom interval report that lets the user pull multiple days of interval data. I have the report basically working, however, the presentation of the data is not what I want. Below is an example of what I want...

Date Time ACD Calls
Grand Totals 6
4/14/2020
8:00 - 8:30 1
8:30 - 9:00 1

Daily Total 2

4/15/2020
8:00 - 8:30 3
8:30 - 9:00 1

Daily Total 4

But instead the best I can get is this...

Date Time ACD Calls
Totals 6
4/14/20202 8:00 - 8:30 1
4/14/2020 8:30 - 9:00 1
4/15/2020 8:00 - 8:30 3
4/15/2020 8:30 - 9:00 1


Any chance this is possible via CMS Report Designer? It seems pretty limited but perhaps I missing something.

Is there a way to run separate SQL queries for different tables on a report?

BTW this formatting is something that is a basic standard report offering in AACC. No custom design needed to run interval reports across multiple days.

mkopiec 04-17-2020 09:36 AM

Not sure why but this post tool removed the spacing I had for the report examples. :mad:

But hopefully you get the idea.


All times are GMT -7. The time now is 03:42 PM.