How to achieve like this

[Former Member]

i have 4 field, i join them using formula but when 1 or more field is empty or 0, the field not show up

here's my formula:

if {Table.NoLo} = 0 then

""

else if {Table.NoLoA} = 0 then

""

else if {Table.NoLoB} = 0 then

""

else if {Table.NoLoC} = 0 then

""

else

ToText({Table.NoLo}, "#") & "<br>" & ToText({Table.NoLoA}, "#") & "<br>" & ToText({Table.NoLoB}, "#") & "<br>" & ToText({Table.NoLoC}, "#")

using Can Grow and Text Interpretation HTML

[abhilash_kumar · Accepted solution]

Hi Dadang,

You have a couple of options:

1) Create a text object

2) Insert the first field into the text object > Hit Enter and insert the next field > repeat for all remaining fields

3) Right-click the field > Format Field > Check 'Suppress embedded field blank lines'

Or, create a formula with this code:

(if {Table.NoLo} <> 0 then ToText({Table.NoLo}, "#") & chr(13)) &

(If {Table.NoLoA} <> 0 then ToText({Table.NoLoA}, "#") & chr(13)) &

(If {Table.NoLoB} <> 0 then ToText({Table.NoLoB}, "#") & chr(13)) &

(If {Table.NoLoC} <> 0 then ToText({Table.NoLoC}, "#"))

Make sure that the option 'Default Values for Nulls' is selected from the drop down on the top in the formula editor.

Drag and drop this formula on the report and enable 'can grow'.

-Abhilash

[Former Member · Accepted solution]

I don't know how to thanks.  i am searching this for a month. Your a live saver