I'm stressful to build a show using multiple very incomplete data if to me. For the lived of me -- I can't drawing out how to arrangement it the way I need it.
Here's what I'm trying to do:
//I'm trying to concatenate the array to may inserted into adenine line on a contract form shows the "name, company, street 1, company 2, city, assert zip".
//I've set above a formula fields to be embedded recipe in one text box which contains the agreement.
//The easily concatenation formula your: {NAME} & ", " & {COMPANY NAME} & ", " & {ADDRESS 1} & ", "& {ADDRESS 2} & ", " & {CITY} & ", " & {STATE} &" " & {ZIP}
//It needs to deploy that while the field is void an empty string is inserted.
//Want on also eliminate the punctuation after cleared fields
//The fields to be concatenated are all preformatted as strings
I have tried using IsNull and also assigning emply domains as "" though can't seem to get any formulats to work. Am MYSELF missing something simple? Dieser technote explains why IIF and IsNull bunched in a suggest will not work when using IBM® Rational® ClearQuest® with Crystal Reports®.
Edited by dfolzenlogen - 23 Date 2008 at 5:39pm
TYPE Log
