By default, Crystal Reports can't match the data that belongs with the record that has the Max() value. I haven't tried this, but I think there would be a way to trick it. I would try creating a formula which has a Global string variable which stores the salesperson name. Compare the current sales values to the Max() value and if they match then assing the salesperson name to the string variable. Print the string variable in the group footer (and reset it to "" in the group header) and I think this will do it.

I have three chapters dedicated to writing custom formulas in my Encyclopedia book. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.

Yes, I've written four chapters of the CR 2008 book so far. My attention has been diverted recently due to SAP's acquisition of Crystal Reports. I'm now undergoing heavy training in SAP so that I can write about the data integration aspects with CR. I will start on the next chapter once I get back from visiting SAP this week for a developers competition.