maqskywalker
asked on
Crystal Reports get subgroup count
I'm using Crystal Reports.
I have a sql server table that looks like this:
My Crystal Report layout looks like this:
When I run my Crystal Report it looks like this:
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:
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:
That’s not what I want.
I want the count of each Region in each date as shown here 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?
I have a sql server table that looks like this:
My Crystal Report layout looks like this:
When I run my Crystal Report it looks like this:
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:
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:
That’s not what I want.
I want the count of each Region in each date as shown here 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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.