Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Running total distinct count Post Reply Post New Topic
Author Message
Wosp
Groupie
Groupie
Avatar

Joined: 05 Sep 2012
Location: Sweden
Online Status: Offline
Posts: 45
Quote Wosp Replybullet Topic: Running total distinct count
     Posted: 14 Aug 2013 at 11:49pm
Hi; i have a report showing workorder-list, it also shows if the workorder comes from a planning ex. with an interval.
I made a running total distinct count on Workorder and it works, but when i make the same on planning its always +1 of what it should be.
Exept, if all workorders displayed comes from a planning then its the right value.
 
Ex: out of 20 workorders 10 comes from planning it diplays 11 on planning dcount
Out of  20 workorders 20 comes from  planning it displays 20 = right value
 
What do i miss?
 
Btw - im new at this
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Aug 2013 at 3:30am
I assume youa re using variable formulas and not a crystal Running Total.
 
1. do you have a seperate display formula that you are placing in the report footer?
2. What is your calculating formula?
IP IP Logged
Wosp
Groupie
Groupie
Avatar

Joined: 05 Sep 2012
Location: Sweden
Online Status: Offline
Posts: 45
Quote Wosp Replybullet Posted: 18 Aug 2013 at 8:06pm
Originally posted by DBlank

I assume youa re using variable formulas and not a crystal Running Total.
 
1. do you have a seperate display formula that you are placing in the report footer?
2. What is your calculating formula?
Sorry i didnt see your answer due to my 50th birthday Smile  but before clocking out i made a running total condition formula looking like this:
 
if {AO.SOURCENR} < 1 then no
else yes
 
To my surprice it worked, tested it today again and its seems to work...
 
Thank you for your quick reply anyway
IP IP Logged
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