cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
435
Views
1
Helpful
3
Replies

Grouping by a @param value in a report

datuser01
Level 1
Level 1

Hi,

I'm trying to run a report for a single Agent over time an have values grouped by Month.  I don't see any examples of this.  The Report Def is using a Stored Procedure.  This is the output I'm hoping for (mockup), focus on Month column.  Any help would be appreciated.

      

Agent Name Total InboundInbound ACD
MonthTotalAvg Talk TimeAvg Hold TimeAvg Work Time
Damon GaylorJan110:00:010:00:000:00:00
Feb750:00:080:00:000:00:02
Mar550:01:270:00:000:00:00
Apr000:00:000:00:000:00:00
May110:00:290:00:000:00:10
Jun210:00:100:00:000:00:10
Jul980:02:070:00:000:00:03
Aug000:00:000:00:000:00:00
Sep630:01:040:00:000:00:00
31 0:00:360:00:00
3 Replies 3

ewindgat
Level 5
Level 5

Do you have access to the stored procedure?

Yes.  I was hoping to not have to modify that, but it sounds like that is exactly what is needed.

Yes. If that doesn't work. Let me know.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: