How do I eliminate a certain group
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22468
Printed Date: 03 May 2024 at 6:50am
Topic: How do I eliminate a certain group
Posted By: jgelsleichter
Subject: How do I eliminate a certain group
Date 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
|
Replies:
Posted By: DBlank
Date 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)
|
|