I have set up a report that groups by Vendor name.  However, the names are created by different people and sometimes there are variations in the name referring to the same vendor.  i've been asked to group all these variations into one "Main" vendor name.  i'm not quite sure how to do this.  i tried setting up a group formula with a selection criteria that basically says, if vendor name equals any of these names, then the vendor name equals "this name" but i am not able to see the details for each individual name in the group...

"Fixing" this in Crystal reports is going to be "challenging" and likely to cause an administrative nightmare.

Hi Jasey,