CONCATENATE to remove duplicates NOT working

[rwn]

I have these fields in the Detail Section: Job, Vendor, Invoice#, PO, POLN, Invoice$, Invoice Status, Paid$

and using this: {@conccat}= Job & Vendor & Invoice# & PO & POLN & Invoice$
Then go to the section expert->details->suppress->x+2 and enter:

{@concat} = previous({@concat}) :

But when the duplicates are removed and records are viewed ALL the date is correct except the Paid$ field only shows the same value in each row and it should be showing a unique value in each row.

if I then have: {@conccat}= Job & Vendor & Invoice# & PO & POLN & Invoice$ & Paid$

Then the Invoice$ field always shows the same value in each row.

 

[kray4660]

Personally I would avoid complicated ways trying to suppress rows and figure out why I have duplicates in the first place (bad table joining?). Also I am a big fan of doing groupings and only displaying data in the group footer (avoids a lot of duplication issues).

 

[rwn]

Im not a fan of dups either. But this has nothing to do with linking or such at all. It has to do with Checking being applied multi Times to Invoices.

I used above what LB recommended and was wondering if he had any insight.