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.
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.
Comment