off the cuff I'd say use a formula:

@PhoneCheck

if isnull({table.cellphone}) or {table.cellphone}="" then {table.homephone}
else
{table.cellphone}

drag that to your details band where you want the phone field to display

So is the following what the output would look like if two are available (both home and cell) with no suppression?

FIRST_NAME    LAST_NAME   PHONE_CODE   PHONE_NO
John                Smith             Cell                   123.456.7890
John                Smith             Home                456.789.0123

?

Also please define what the value is for {PHONE} I understand {PHONE_CODE} and assume {PHONE_NO} is the actual number.

EDIT: actually give me a definition of all the PHONE_* fields.



Edited by junkbox - 06 Dec 2012 at 4:52pm

gotchya, so {PHONE} is essentially an ID

1="Cell"
2="Home"
3="Fax"

or

C="Cell"
h="Home"

etc.


?


Edited by junkbox - 06 Dec 2012 at 5:32pm

Does {PHONE} have a value if say Home phone isn't there?
Meaning can john smith have a {PHONE}=2 but {PHONE_NO}=NULL or ""?
I'm asking if the {PHONE} 1-5 are always present or if the data source only knows what it gets

John Smith
{PHONE}=1 {PHONE_CODE}="Cell" {PHONE_NO}="123-4567"
{PHONE}=2 {PHONE_CODE}="Home" {PHONE_NO}=NULL
{PHONE}=3 {PHONE_CODE}="Fax" {PHONE_NO}="789-0123"
{PHONE}=4 {PHONE_CODE}="Work" {PHONE_NO}="456-7890"

OR

{PHONE}=1 {PHONE_CODE}="Cell" {PHONE_NO}="123-4567"
{PHONE}=3 {PHONE_CODE}="Fax" {PHONE_NO}="789-0123"
{PHONE}=4 {PHONE_CODE}="Work" {PHONE_NO}="456-7890"

where home doesn't exist in the DB at all cause it wasn't created.

I would do the following: