If I'm understanding this properly, you want the left side of the detail to have only the Name and a main phone number, then the right side to have any cell or pager number.
I'm not certain why you can't just insert the fields into these locations, unless you have a table where you have a phone type and then phone number for each type. If that's the case, you could make a formula where
{@CellNumber}
If PhoneType = "cell" then PhoneNumber
... and insert that into the right side of the report. You could do the same for Pager number and the names as well.
I don't know if I'm fully understanding your question...
|