Suppose that I have a Document called Contact and it has fields FirstName, LastName, Company, Title, Phone, Email.

Now suppose that I want to display Contacts grouped by Company. How would I go about doing this? I started using nested repeaters inside a transformation but the performance was awful. It was making a SQL call for each unique company. I then created a custom Web Part that did a nested repeater with only two SQL calls but I think it should be easier.

I've been looking at the Universal Viewer and it might be able to do what I want but I haven't yet figured it out yet. I've seen the GroupedDataSource but I'm not sure what it does and it seems to be more for hierarchical data rather than data grouped by a given field. Can anyone point me towards a solution for this problem? This seems to be our most frequent use case that we've been unable to easily solve.

Thanks.