hello.

I have a customized report whiich is based on opportunity table. I now need to add the contact address details to the report. I already have the account address details and that works fine. but not the contact address which has different address details. I have tried just about every formula I can think and have tried using a 'view' but when I do this this either the all the fields in the report return no information or I only get some reports that return the information including the contact address.

does anyone have some details that would like to share?

thank you in advance for your help.

Just add the address table again and link it to the contact table using ADDRESSID.