Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Group by with same value? Post Reply Post New Topic
Author Message
techsupport
Groupie
Groupie


Joined: 03 Jun 2014
Location: United States
Online Status: Offline
Posts: 41
Quote techsupport Replybullet Topic: Group by with same value?
    Posted: 17 Feb 2018 at 4:38pm
This report has 3 Groups
Employee
CheckDate
CheckNo

And Running Totals on CheckNo

However, found out that it only shows the same CheckNo once.
Why would there be a duplicate? If the CheckNo was voided.
So it uses the same CheckNo but with a negative value.

Right now it only shows the same CheckNo once and the Earnings total is inaccurate because of the 2nd record isn't showing.

At one point it'll show the positive value making the total Earnings overstated because it's not calculating in the voided (negative amount).
Run it another time and it shows only the negative amount and not the positive understating the total Earnings.

How do you have the CheckNo Group show when the Earnings amount is the same amount but cancelling each other out? Not sure how else to explain this.

On Group it needs to show both, but it currently is not.
CheckNo    Earnings
811511     $1000
811511    -$1000

Hope this makes sense.

Edited by techsupport - 17 Feb 2018 at 4:40pm
____________________
Thank you very much!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.