Categorizing Data
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=21611
Printed Date: 07 May 2024 at 3:35am
Topic: Categorizing Data
Posted By: SBean
Subject: Categorizing Data
Date Posted: 22 Jul 2015 at 5:29am
Hello,
I am a novice Crystal Report user and I have the following issue:
One person may have multiple charges and each charge i have coded as either violent or non-violent. What i need to do now is write a formula that says if there is a violent charge in someone's history then select this and not the non-violent charge. Happy to provide more information. Desperately seeking help.
|
Replies:
Posted By: DBlank
Date Posted: 24 Jul 2015 at 3:36am
|
do you mean you select only persons with a violent history but show the entire history?
|
Posted By: SBean
Date Posted: 24 Jul 2015 at 3:39am
|
i actually want to show only those that have only a non-violent history which requires weeding out those cases that have both
|
Posted By: DBlank
Date Posted: 24 Jul 2015 at 3:45am
try this:
group on the person
create a "flag" formula to sum "violence records"
if field='violent' then 1 else 0
sum this at the person group
use a group select to only select groups where the sum=0
sum(@flag,person)=0
|
|