Link to home
Start Free TrialLog in
Avatar of maqskywalker
maqskywalker

asked on

Crystal Reports get subgroup count

I'm using Crystal Reports.

I have a sql server table that looks like this:

User generated image
My Crystal Report layout looks like this:

User generated image
When I run my Crystal Report it looks like this:

User generated image
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:

User generated image
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:User generated image

That’s not what I want.

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

User generated image

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?
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial