Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dynamic grouping
Message
De
05/10/2006 16:27:56
 
 
À
05/10/2006 16:23:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01159860
Message ID:
01159864
Vues:
19
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.
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform