Solved

Crystal Reports get subgroup count

Posted on 2016-11-16
1
45 Views
Last Modified: 2016-11-16
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?
0
Comment
Question by:maqskywalker
1 Comment
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 41890501
Try this

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

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now