Display Total for Entire Day Within Daily Group

[craigK]

I am using CR XI. I have 2 groups. I would like to have summaries based on the 2nd group.

Group I = WorkerID
Group II = CallDate
Details = WorkerID CallId Calldate

Data would look like this:

IDWorker1 1234 7/1/2007
IDWorker1 1235 7/1/2007
IDWorker1 1236 7/2/2007
IDWorker1 1237 7/2/2007
IDWorker1 1238 7/2/2007

IDWorker2 1210 7/1/2007
IDWorker2 1211 7/1/2007
IDWorker2 1212 7/3/2007


Report would look like:

ID Date Calls AllCallsForDay
IDWorker1 7/1/2007 2 4
7/2/2007 3 3
IDWorker2 7/1/2007 2 4
7/3/2007 1 1

I'm having problems finding a way to get AllCallsForDay to display on the Group II line.

 

[lbass]

I think you would have to do this in a subreport, where you group only on date, insert a distinctcount on the callId, and then link the subreport to the main report on the date field only. Suppress all but the subreport report footer where you have inserted the summary. Place the subreport in the Group #2 header.

-LB

 

[craigK]

I think so too. I was hoping there was a way to avoid one. Subreport it is. Thanks for your quick answer.

 

[lbass]

You could also try creating a command like:

select count(table.`call ID`) as datetotal, table.`date`
from table
group by table.`date`

Link {command.date} to {table.date}. Then add {command.datetotal} to your group#2 header. Since the linking will occur locally, this probably will not be an improvement over the subreport approach.

-LB