need formula for str concat in address rpt

[olichap]

I have an address report for my VB app that groups 1st by Name, 2nd by address. When the query runs a given name may have the same address two or three times; each is attached to a different network-code.
ex/
Smith, John
123 Main st. Nowhere, XX 12345 NetCode: 12
123 Main st. Nowhere, XX 12345 NetCode: 43
324 Elm st. Nowhere, XX 12345 NetCode: 12
324 Elm st. Nowhere, XX 12345 NetCode: 43

Now, my grouping by address will eliminate the dupe addresses. What I am trying to do is report a list of all the NetCodes associated with the name (in this case 12 & 43). I could create a formula to concatenate the codes w/commas between but that would return "12,43,12,43." I would like to see "12,43."

Any suggestions?

Thanks,

Oliver

 

[kenhamady]

Create a running total count of how many addresses are in each person group, and then only append the Net codes while the running count = 1. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)