Find First Record - Label Report

madm

I am creating a label report (based on Report 110 - customer labels) which looks at the Ship-To Address Table.

The report will be run by filtering on the ship to table postcode, and the labels will contain the customer address. This works fine however, as customers will have multiple ship-tos, I will receive mulitple labels if their if they have multiple ship-tos with the same postcode. We are only interested in receiving one label. I have tried grouping etc but this didnt work (could it be that the ship -to number is in the primary key?)

My next thought would be to use FIND - however thats new one for me!!

Any help?

ara3n

You can either delete the ship-to codes that are the same, or write the following in your report

onaftergetrecord()

if PreviousAddress = Address then
  currreport.skip;

PreviousAddress := Address;

madm

thank you - sorted using the if method

ara3n

You are welcome. :P