Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Another Suppress Question Post Reply Post New Topic
<< Prev Page  of 5 Next >>
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 25 Feb 2010 at 9:02am
In your sample above with Lesa Marg and Susan, make sure you do not have any suppression on your detail rows. Suppressing will not impact the RT (it still evaluates the suppressed row) but will confuse you whne you are trying to validate the RT.
What is the exact next row after the one it skipped but should have counted?
If you can also do some testing by creating formula fields for each part of the RT formula and test to see if a certain part fails or not.
Make one formula for part 1:
{Audit_Trail.FieldName} = "Temp_Out" and {Audit_Trail.BeforeValue}= "1"
and {Audit_Trail.DateStamp} <= {?date}
and another for part 2:
(next({Audit_Trail.FieldName})<>{Audit_Trail.FieldName}
or
(next({Audit_Trail.FieldName})={Audit_Trail.FieldName} and
next({Audit_Trail.DateStamp})>{?date}))
Place then on the details section and you will see it evaluate True or False for each part and maybe you can figure out what part of the formula is screwing your count up.
IP IP Logged
hugo69
Groupie
Groupie


Joined: 15 Feb 2010
Online Status: Offline
Posts: 53
Quote hugo69 Replybullet Posted: 25 Feb 2010 at 10:50am
I have no suppression going on.
And this is the next row that skips. This is under Margert 
 
 
Field Name                   BV          AV               Date                        Part1  Part2
 In_This_Facility              1            0          02/12/2010 05:22:19       True    False
Current_Image_Link       null      26611       02/16/2010 23:20:51       False  True
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 25 Feb 2010 at 11:22am
Well based on the testing it is the second part of the statement that fails (Part 2 returned a FALSE on your first row, it has to TRUE in both parts for the field to be counted).
It is really hard to figure this out away from the data...
Maybe adding in another OR option to fix the second formula?
 
(next({Audit_Trail.FieldName})<>{Audit_Trail.FieldName}
or
Next(table.BV_field)<>0
or
(next({Audit_Trail.FieldName})={Audit_Trail.FieldName} and
next({Audit_Trail.DateStamp})>{?date}))


Edited by DBlank - 25 Feb 2010 at 11:22am
IP IP Logged
hugo69
Groupie
Groupie


Joined: 15 Feb 2010
Online Status: Offline
Posts: 53
Quote hugo69 Replybullet Posted: 25 Feb 2010 at 12:49pm

We are this close and I have this one that turns and should not. Do you think it has something to do with the period in the AV before the row? It is not even during the dateparam. There was been 2 after this date?

Field Name                   BV       AV               Date                        Part1  Part2
Curr_Cell_Number          M/A       .         01/25/2010 07:55:41    2     False  False
 In_This_Facility              1          0         01/25/2010 07:55:41   3      True False
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 25 Feb 2010 at 1:00pm
Did you update the Running Total formula with what nows seems to be working for part2 formula?
The fact that it is a FALSE in part2 for that row means it should not have 'counted' it. That is really weird...


Edited by DBlank - 25 Feb 2010 at 1:01pm
IP IP Logged
hugo69
Groupie
Groupie


Joined: 15 Feb 2010
Online Status: Offline
Posts: 53
Quote hugo69 Replybullet Posted: 25 Feb 2010 at 1:15pm
(Part 2 returned a FALSE on your first row, it has to TRUE in both parts for the field to be counted).  That is weird because the ones that should be counted do not have the True in both parts? Would they be on the same row? Or true in one row (Part1) and true in another row (Part2)?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 25 Feb 2010 at 1:21pm

Unless I have worked myself into a circle ont his they both should be TRUE on the same row to be counted in the RT.

If either or both are False it should ignore it.
IP IP Logged
hugo69
Groupie
Groupie


Joined: 15 Feb 2010
Online Status: Offline
Posts: 53
Quote hugo69 Replybullet Posted: 25 Feb 2010 at 1:57pm
I think I have it. It may have been because of the wrong ID I was using. I have the numbers now coming out right. Today I should have 15 inmates not In This Facility. So heres a question? Now that I have the distinct number of 15. How do I minus them from the total count? The total count is 79 and when I do this:
{#All Inmates Confined} - Distinctcount ({Audit_Trail.FieldName}) = 28???
 
should it not be 79-15=64??
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 25 Feb 2010 at 2:01pm
if you do just the Distinctcount ({Audit_Trail.FieldName})
...asuming that the {Audit_Trail.FieldName} field is the unique identifier for each inmate)...and palce it on the report footer what is the number displayed?
IP IP Logged
hugo69
Groupie
Groupie


Joined: 15 Feb 2010
Online Status: Offline
Posts: 53
Quote hugo69 Replybullet Posted: 25 Feb 2010 at 2:03pm
Nevermind the above!!! Long day!!   
{#All Inmates Confined} - {#Not In This Facility} 
 
 
But now how can I without the distinct count (15) figure out between Males and Females?


Edited by hugo69 - 25 Feb 2010 at 2:04pm
IP IP Logged
<< Prev Page  of 5 Next >>
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.