Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports - Group question 1

Status
Not open for further replies.
SarahSCPDAdmin

SarahSCPDAdmin

Technical User
Aug 10, 2023
7
US
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
 
Sort by date Sort by votes
Not absolutely sure what the end result needs to look like but the following formula will return just the Groups that have at least 1 'Juvenile' listed.

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:
[ol 1]
[li]Juvenile/Adult is in a field I called Type. Please add your Table/Column name as appropriate[/li]
[li]The only data in that field is limited to "Adult" or "Juvenile", ie the 'maximum' value in that field is "Juvenile"[/li]
[/ol]

Hope this helps.

Regards,
Pete
 
Upvote 0 Downvote
You, Sir PMAX9999, are my hero! In all of my looking around online trying to figure this out I have not come across this way of doing it.

Thank you, thank you, THANK YOU!!

Sarah
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennymc
  • Question
Has anyone used Crystal reports with online Microsoft Dynamics 365
Replies
0
Views
98
Kennymc
Kennymc
D
  • Locked
  • Question
Crystal Reports for Visual Studio 2022 Download
Replies
2
Views
6K
Joshua44
J
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
869
hilfy
hilfy
bbranco
  • Locked
  • Question
Query Help - Group By 2 tables
Replies
0
Views
403
bbranco
bbranco
K
  • Locked
  • Question
We're using command in crystal report
Replies
1
Views
577
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top