This is difficult to assist when it is unclear what all of the grouping is. I assumed incorrectly that the sample data was at a detail level.
What I would suggest is to try and come up with a way that allows you to use summary options to come up with a text that you can display.
Since I do not know your actual data set and all the grouping you are doing all I can suggest is a approach.
If you are grouping on Employee at some upper group you could convert it ina few formulas
//new_hire_count
if {HRHISTORY.FLD_NBR}="New Hire Date" then 1
when you sum this at any group level if the value is >0 then you know you had a row as new hire
do the same thing with your other types
so ultimately you can write a formula checking all of those values n a logical way
if sum(new hire count,group)>0 and sum(other formual,group)>0 then "text"
IP Logged
