Display first instance of field data
I have a report with 2 fields called Pattern and Color. There can be many colors of the same pattern. I'm trying to create a layout that shows just the Pattern. On the items where there is more than 1 color I get the pattern name listed as many times as there are colors. I'd like to have the pattern listed just one time. Any ideas?