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?
IP Logged
