Print Page | Close Window

Why is the suppress record still ...

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17111
Printed Date: 01 May 2024 at 6:32pm


Topic: Why is the suppress record still ...
Posted By: Douang
Subject: Why is the suppress record still ...
Date Posted: 25 Jul 2012 at 7:40am
I have a very simple CR report.
 
On Detail Line, I showed CustomerID, Rate, etc...  
 
I suppress record from the Detail Line if CustomerID = '100222'.
 
At the end of the report, I have SUM of Rate but the suppressed record is included in the SUM of Rate.
 
Example record:
 
CustomerID       Rate         
333222              5.00
100222             25.00
555551             35.00
 
My report shows:
 
CustomerID       Rate         
333222              5.00
555551             35.00
 
But at the end of the report, the total shows 65.00 instead of 40.00.  CustomerID 100222 is excluded from the detail line but it added to SUM(Rate).
 
WHY?
 
 


Replies:
Posted By: lockwelle
Date Posted: 31 Jul 2012 at 6:58am
the Aggregate functions don't care about suppression...if it is in the dataset it gets added in.  You can try removing it from the record set or you can create your sum using either running totals or shared variables.


Print Page | Close Window