Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dynamic grouping
Message
From
05/10/2006 16:23:03
 
 
To
05/10/2006 16:19:10
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01159860
Message ID:
01159861
Views:
17
>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform