CMS Custom Report

[mkopiec]

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]

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

But hopefully you get the idea.