Hi,
I need some help on an address formula.
I have clients that have a physical address (all have one) and some have a mailing address.The physical and mailing address are stored in {ADDR.ADDR_TYPE_CD}
I created a report grouped by client, then a group by {ADDR.ADDR_TYPE_CD}.
I need to display a mailing address if there is one or the physical if there is no mailing.
I need the details of the report for showing license history for the client, but the clients that have both physical and mailing are showing double for the license history in the details.
Basicaly I need to somehow to show the proper address and the details not to duplicate.
I hope I explained this so it can be understood.
Thanks
I need some help on an address formula.
I have clients that have a physical address (all have one) and some have a mailing address.The physical and mailing address are stored in {ADDR.ADDR_TYPE_CD}
I created a report grouped by client, then a group by {ADDR.ADDR_TYPE_CD}.
I need to display a mailing address if there is one or the physical if there is no mailing.
I need the details of the report for showing license history for the client, but the clients that have both physical and mailing are showing double for the license history in the details.
Basicaly I need to somehow to show the proper address and the details not to duplicate.
I hope I explained this so it can be understood.
Thanks