Solved

Crystal Reports get subgroup count

Posted on 2016-11-16
1
80 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 101

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

631 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