View Single Post
  #1  
Old 04-17-2020, 08:31 AM
mkopiec mkopiec is offline
Hot Shot
 
Join Date: Aug 2010
Posts: 17
mkopiec has 10 reputation points
Default 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.
Reply With Quote