Crystal Reports - Group question
Crystal Reports - Group question
(OP)
I am trying to create a report and I'm stuck.
I have my data grouped by Complaint Number and under each complaint number is last name, first name, age, etc.
I then created a formula to tell me if each person is a Juvenile or Adult.
For instance:
Case# 1234 involves:
Name A = Juvenile
Name B = Juvenile
Name C = Adult
Case #4567 involves:
Name D = Adult
Name E = Adult
Name F = Adult
Case #8910 involves:
Name G = Juvenile
Name H = Juvenile
Name I = Juvenile
I ONLY want to show the groups that have a juvenile involved.
I can figure out how to narrow it down to only show case numbers with juveniles involved (for example for case 1234 it would show me Name A and Name B but not Name C and for Case 8910 it would show me all names) but if there are adults involved in that case, like Case 1234, it will not show me Name C.
I hope I'm explaining this well. But I'm super frustrated. Does anyone have any insight for me?
Thanks so much!
Sarah
I have my data grouped by Complaint Number and under each complaint number is last name, first name, age, etc.
I then created a formula to tell me if each person is a Juvenile or Adult.
For instance:
Case# 1234 involves:
Name A = Juvenile
Name B = Juvenile
Name C = Adult
Case #4567 involves:
Name D = Adult
Name E = Adult
Name F = Adult
Case #8910 involves:
Name G = Juvenile
Name H = Juvenile
Name I = Juvenile
I ONLY want to show the groups that have a juvenile involved.
I can figure out how to narrow it down to only show case numbers with juveniles involved (for example for case 1234 it would show me Name A and Name B but not Name C and for Case 8910 it would show me all names) but if there are adults involved in that case, like Case 1234, it will not show me Name C.
I hope I'm explaining this well. But I'm super frustrated. Does anyone have any insight for me?
Thanks so much!
Sarah
Talk To Other Members
RE: Crystal Reports - Group question
Go to the Group Selection Formula (Report ==> Selection Formula ==> Group) and enter the following formula:
CODE
MAXIMUM({Table.Type}, {Table.CASE_No}) = 'Juvenile'This approach relies on a couple of assumptions:
- Juvenile/Adult is in a field I called Type. Please add your Table/Column name as appropriate
- The only data in that field is limited to "Adult" or "Juvenile", ie the 'maximum' value in that field is "Juvenile"
Hope this helps.Regards,
Pete
RE: Crystal Reports - Group question
Thank you, thank you, THANK YOU!!
Sarah