I know you double posted this one, but the real question is what do you want? Is it the first record for a customer, or the first record for a customer for a location?
AS the groupings change so will the report.
Really the simplest way to accomplish this is to write a stored procedure to retrieve ONLY the data you want to report on, then you don't have to jump through hoops filter and ordering, you just need to report.
Crystal can do a lot, but it is limited in situations like this. SQL is much more versatile in handling the data side.
HTH
I'm trying to select a certain record from a group and count that record in a summary. Here is what I have Customer ID, order id, and location. What I need is to have them grouped by location but I only want the first order id to show for each customer. some customers have orders go to different location but I only want the first one for each customer grouped 
IP Logged
