Print Page | Close Window

Getting a Summary count without suppressed data

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9455
Printed Date: 27 Apr 2024 at 9:37am


Topic: Getting a Summary count without suppressed data
Posted By: stratos
Subject: Getting a Summary count without suppressed data
Date Posted: 22 Mar 2010 at 10:40am
In my report I used the section expert to suppress details when column a and column be equal a set value.

This works fine and the data is suppressed where applicable, but when I try to get a Summary count it still count the data that was suppressed.

I do not know how to create a count of all the data minus the suppressed details.

Any help would be greatly appreciated. Thank You


Replies:
Posted By: DBlank
Date Posted: 22 Mar 2010 at 10:51am
Use a Running Total (you can also do this with variable formulas)...
 
RT Name= 'Count'
Field to Sumamrize= The field you want to count
Type of Summary = Count
Evaluate = use a formula
NOT(field a= whatever and field b=wahtever)
Reset= Never (for report total)
Place in Reprot footer
RTs do not work in headers.

Posted By: kevlray
Date Posted: 22 Mar 2010 at 10:55am
Suppressing just hides the data, it does not remove it from the report.
 
Are you doing a running total?  If so, are you evaluating all records?  If so, then that is why.  You can the running total evaluate on any boolean expression.  Thus if you have the running total evaluate on the 'NOT' expression for your suppression, then that should 'eliminate' the values you do not want to count.
 
I hope this helps.

Posted By: stratos
Date Posted: 22 Mar 2010 at 10:59am
That worked perfectly.

Thanks a million...

Posted By: MikeSa
Date Posted: 04 Aug 2011 at 3:08pm
This is the same issue I was having trouble with. I have grouping by "location" and doing a running total on "procedure" with a reset on change of "location". It works perfectly except for the last "location" the running total always has a count of 1 less than the total.
Any help would be appreciated
 
Mike


Print Page | Close Window