Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: How do I eliminate a certain group Post Reply Post New Topic
Author Message
jgelsleichter
Newbie
Newbie
Avatar

Joined: 28 Sep 2017
Location: United States
Online Status: Offline
Posts: 1
Quote jgelsleichter Replybullet Topic: How do I eliminate a certain group
    Posted: 30 Sep 2017 at 2:14am
I have grouped all inmate by pin number and charge classification or felony misermeanor etc.    Then then filtered to list only inmates with misdmeanor. That look lists that lists all inmate with misdemeanors and felonys it just doesn't show the felonys.     How do I set up a group to just list inmates with misdemeanors and no other chargers   thanks for any help.
jim
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 02 Oct 2017 at 2:39am
that sounds like a group condition.
First I think I would remove your other select criteria as it might give you a false positive.
Then maybe add a formula to indicate if a row was a misdemeanor or not.
If table.field = 'misdemeanor' then 1
sum this at the person group
insert another summary as the count of that same field
now if these two values are the same all the rows are a misdemeanor.
Place these in the group footer and review to make sure this is what you are needing. If it is it could be used as a group select condition
count(field,person)=sum(formulafield,person)


Edited by DBlank - 02 Oct 2017 at 2:40am
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.016 seconds.