Selecting the highest education degree

[Extrmdressage]

I am working in CR 8.5 and we have a table which contains the educational degrees a person possesses. In some cases, a person may possess more than one degree, but I am looking for the highest level degree. For example; a person may have a HS diploma and a Bachelor's degree, but I only want to see the Bachelor's degree. Is there a way to complete this task?

 

[melven]

I do not know what your data looks like so am guessing, but I might categorize the degrees with a formula in the detail section.

If {table.degree}="Masters" Then
1
Else If {table.degree}="Bachelors" Then
2
Else If {table.degree}="High School" Then
3;

Then order by this formula field and suppress details after the first item/degree.

Mel

CR Developer V 12.2, .NET

 

[lbass]

Or you could insert a minimum on Mel's formula at the group level, assuming you group on the person field.

-LB