Hi Borislav,
thanks, but I'd found a different solution:
iif(crectype="IDCard", cIdCard, cName)
I got rid of the quotes around the fields I wanted to group on and everything works great.
>>Hi,
>>
>>I am creating a report listing possible duplicate customers. I gather the data and flag a duplicate as being either "IDCard" or "Name" depending on if the duplication is due to the ID Card or Name. All possible duplicate records are added to a cursor and the cRecType field is filled in with either "IDCard" or "Name".
>>
>>When I produce my report, I want a grouping on my cIDCard field if the cRecType is "IDCard" and if not I want the group on my cName field.
>>
>>I tried a grouping on this expression iif(crectype="IDCard", "cIdCard", "cName") but this isn't working, I'm not getting a break on each idcard or name.
>>
>>Any ideas how I can achieve this?
>>
>>Thanks,
>
>Add an additional field into the cursor you use for report (let's say GrpFld C(100)) and during the preparation of the cursor fill if with either IdCard either Name. Then group the report by it.