Suppress a field when no data available

[alauddinctgbd]

Hi,

 

How can I suppress a field when no data available

that is when no data or null then the

should not be displayed only but also the other row

will one row upward.For axample the fields are:

 

row1--- <<Contact Name>>

row2--- <<Company Name>>

row3--- <<Street Address>>,

row4--- <<City Name>> <<Zip Code>>,

row5--- <<State>>, <<Country Name>>

 

When no data in Database for <<Company Name>> and <<State>>

 

it should show like

 

row1--- <<Contact Name>>

row2--- <<Street Address>>,

row3--- <<City Name>> <<Zip Code>>,

row4--- <<Country Name>>

 

My query returns null---->

 

row1--- <<Contact Name>>

row2--- null

row3--- <<Street Address>>,

row4--- <<City Name>> <<Zip Code>>,

row5--- null, <<Country Name>>

 

How can i solve this?

 

Any help appriciated

 

Alauddin

[Teodor Danciu]

Hi,

 

Use the isBlankWhenNull="true" option for text fields and also isRemoveLineWhenBlank="true".

But you have to make sure that there are no other elements on the sides (something like vertical lines) that would prevent the empty space from collapsing.

This might require using frames to isolate collapsing elements.

 

I hope this helps.

Teodor