Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Count Unsuppressed records Post Reply Post New Topic
<< Prev Page  of 2
Author Message
elamantia
Newbie
Newbie
Avatar

Joined: 20 Aug 2008
Online Status: Offline
Posts: 24
Quote elamantia Replybullet Posted: 06 Apr 2009 at 1:45pm
No error now.  But also no change in the records or the total.  
 
Thank you for sticking with me on this.  This scenario is one that I will use often.
minnie_eye
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 06 Apr 2009 at 2:04pm

THis is probably due to the formula in the running total where you are looking for the ID<>2. If there are nulls in there it is probably omitting them. If this is the case you can try 2 approaches.

Change the formula to: isnull(table.IDfield) or table.idfield<>2
 
Not sure if that will work or not. If not try and create a formula to handle it by converting nulls then using that field as your condition.
Formula as "ConditionalCount":
if isnull(table.idfield) then 0 else table.idfield
Then use this in your running total conditional count as:{@ConditionalCount}<>2
Hope these work Big%20smile
then in your running total
IP IP Logged
elamantia
Newbie
Newbie
Avatar

Joined: 20 Aug 2008
Online Status: Offline
Posts: 24
Quote elamantia Replybullet Posted: 06 Apr 2009 at 2:13pm
Yeah!!  The first way worked!  (isnull(table.IDfield) or table.idfield<>2)
It seems so simple now.  Thank you so much!
 
minnie_eye
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 06 Apr 2009 at 2:14pm
Clap
IP IP Logged
<< Prev Page  of 2
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.016 seconds.