cancel
Showing results for 
Search instead for 
Did you mean: 

At Detail Section combining two column values.

Former Member
0 Kudos

hi.

i need a small information.

in detail section i need to put two column values

column1    column2

-------------   -----------------

value1        value2

i put above two at details section after combine like

value1 value2

but what i need is  value1 should come 1st line and value2 should come 2nd line

i used

stringVar address := "";

if not(isNull({_I8_CO_DETAIL.U_I8_iname}))then

    address := {_I8_CO_DETAIL.U_I8_iname}& chrW(13);

if not(isNull({_I8_CO_DETAIL.U_I8_Tides}))then

    address := address & " "  & {_I8_CO_DETAIL.U_I8_Tides};

address;

above one is coming but second line is starting  1 space  not like first line..like,

                        vlaue1

                          value2

like above

but what i need is

                           value1

                           value2

and also what i need is  after value1 one empty line has to take after that value2 will appear  like

            value1

           

             value2

For getting space i used

stringVar address := "";

if not(isNull({_I8_CO_DETAIL.U_I8_iname}))then

    address := {_I8_CO_DETAIL.U_I8_iname}& chrW(13);

    address = chrW(13);

     

if not(isNull({_I8_CO_DETAIL.U_I8_Tides}))then

    address := address & " "  & {_I8_CO_DETAIL.U_I8_Tides};

address;

but not working

Any information plz  update me...

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Srini,

Try changing the code to:

(If {_I8_CO_DETAIL.U_I8_iname} = '' then '' else {_I8_CO_DETAIL.U_I8_iname} &chrW(13) &chrW(13))&

(If {_I8_CO_DETAIL.U_I8_Tides} = '' then '' else {_I8_CO_DETAIL.U_I8_Tides}))

Also select 'Default Values for Nulls' from the dropdown on the top in the formula editor.

-Abhilash

Answers (0)