I have the following scenario.
Customer A with multiple address IDs - 01, 02, 03, etc.
My user wants me to take specific data fields in address ID 01 and compare to the same fields in the other addresses for the customer. When field values are found to be different, print all data fields for Address ID 01 (as line 1) and print a line for each other address that is different but only print the data field that is different (or print all fields and highlight the one that is different).
I'm having a difficult time determining how to approach this one.
Greatly appreciate any help anyone can provide.
I think I need to provide a better explanation of what I need to do:
I have multiple address IDs such as 01, 02, 03, etc. Address ID 01 is the main address record. I need to compare the data elements of each of the other Address IDs (ex. 02, 03, 04 etc) to Address ID 01. If any differences are found, I need to print one line that includes all the data elements for Address 01, and one line for each other Address ID that is different and only print the fields that are different from Address 01. Any idea how I should approach this? Many thanks!
I think you can make use of the
Suppressformula to do this. General outline:Place the Address on the Detail line
Use a formula (here's a good example) to suppress each field if it is the same as that field on the the previous line for the same customer
Set the Detail row to be suppressed if blank ("Suppress Blank Section" in the Section Expert)