I have a report that needs to be grouped by 2 fields, Vendor Type and Region. THe problem is that in the dataset, Region is divided into 4 fields, Region1, Region2, Region3, and Region4. The regions can be one of 10 values. I would like the report to group by each of these values, then show the record if the any of the region fields (1,2,3 or 4) contains that value. So the records can show in more than one grouping. Is this possible? How?