Crystal Reports get subgroup count

I'm using Crystal Reports.

I have a sql server table that looks like this:

my sql server table
My Crystal Report layout looks like this:

CR layout
When I run my Crystal Report it looks like this:

run report
If you notice my report is grouped by RecordDate first and then by Region.

Then if you notice I have a  Running Total Field called RTotal1 That is what I use to get the Grant Total at the bottom of the page.
I have a Running Total Field called RTotal1 That is what I use to get the Grant Total at the bottom of the page.

This is what it set to:

RTotal1
Then if you notice I also have a running total field called RTotalRecordDate. That is currently giving me the count for the records in each date. It’s inside the Group Footer #1.

This is what its set to:RTotalRecordDate

That’s not what I want.

I want the count of each Region in each date as shown here in red text.

desired result shown in red text

Anyone know what I'm doing wrong in this running total field RTotalRecordDate?

So I can get the counts in red text in the picture above?
LVL 1
maqskywalkerAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Try this

Change your count to reset on REGION
Put it in the REGION group footer

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.