Suppress Line when is null and automatically brings next line to top?

[sathishraja510]

Hi all,

 

                    I have one doubt,

                  i want to print party address with partname,add1,add2,add3,add4 in the form of address.

 

Example:

partyid

add1

add2

add3

add4

if add2 is null then add3 comes in add2 line and add4 comes to add3 line?

 

it's possible?

 

kindly give your suggestion.

 

[hozawa]

How about putting a Break component with Print on condition.

[calculate.machine]

You can judge if a row is null to decide whether to hide it or not through a report script. But this means the length of each record won’t be the same any more.

If you want to modify field values during data preparation to meet the condition that “if add2 is null then add3 comes in add2 line and add4 comes to add3 line”, I suggest you using esProc, in which you can handle it with two lines of code:

A1=$select partyid,add1,add2,add3,add4 from tb

A2=A1.(~.record(~.array().select(~)|["","","",""]))

Find more examples from http://blog.raqsoft.com/?p=4744 .