Alright, so here's the problem and for the life of me I can't figure it out:

Task: Creating a report that lists all of our medically disabled employees. Must be a single line report (i.e. can not group and then list underneath).

Problem: Some employees have more than one disability. This causes them to appear multiple times on the single-line report.

This is the table inside of my program that I am pulling from. This table is for a single employee. Notice how more than one disability is listed: http://i44.tinypic.com/906kao.jpg

This is the results of my report when I run it in Crystal: http://i39.tinypic.com/24wa3xs.jpg

Somehow, I need to figure out a way to only show the first disability an employee has listed on their table. Like in employee 0077's case, I only want to see disability D02... not D04 and D05 too.

I DID find a solution to this by way of Section Expert > Suppress (No Drill-Down) > previous({hrpersnl.p_empno})={hrpersnl.p_empno}. But I can not use this formula because it causes my first employee to be suppressed for some reason.

Help please?

I mean this in a strictly platonic way... but, I love you.

I don't know what I was thinking. It's been a rough week. Thanks for digging me out of my rut.