>Hi,
>I have try it, but the result is not what I want
>
>Report generated:
>

>Name    Allowance           Rate/Trip    Services    Rate Sharing
>CKW     Meal                    15.00    ServiceA    10:90
>CKW                                      ServiceB    10:90
>CKW     Transportation          20.00    ServiceA    20:80
>CKW                                      ServiceB    20:80
>

>
>However, What I expect is
>

>Name    Allowance           Rate/Trip    Services    Rate Sharing
>CKW     Meal                    15.00    ServiceA    10:90
>CKW     Transportation          20.00    ServiceB    20:80
>

>
>Any ideas? Is it possible?
>
>Thank you

select Name, Allowance, Rate, Services, RateSharing;
  from MyTable;
  order by ...;
  group by Allowance;
  into cursor TempReport
report form...

This should eliminate the duplicate records. A more or less arbitrary record will be chosen from each group, so you must be sure that fields like "Rate Sharing" have the same values for each record in a group.

For this reason, VFP 7 (?) or later will give you an error message; one way to solve this is to use the command SET ENGINEBEHAVIOR.