NULL row in text

[x46x]

Hi, I have this in "Text" band:

Code: Select all

{IIF(b.min_size1kk <= 0,null,"1kk "+" "+"("+Format("{0:N1}", b.min_size1kk)+" - "+Format("{0:N1}", b.max_size1kk)+")"+" m2")}<br>
{IIF(b.min_size2kk <= 0,null,"2kk "+" "+"("+Format("{0:N1}", b.min_size2kk)+" - "+Format("{0:N1}", b.max_size2kk)+")"+" m2")}<br>
{IIF(b.min_size3kk <= 0,null,"3kk "+" "+"("+Format("{0:N1}", b.min_size3kk)+" - "+Format("{0:N1}", b.max_size3kk)+")"+" m2")}<br>
{IIF(b.min_size4kk <= 0,null,"4kk "+" "+"("+Format("{0:N1}", b.min_size4kk)+" - "+Format("{0:N1}", b.max_size4kk)+")"+" m2")}<br>
{IIF(b.min_size5kk <= 0,null,"5kk "+" "+"("+Format("{0:N1}", b.min_size5kk)+" - "+Format("{0:N1}", b.max_size5kk)+")"+" m2")}<br>
{IIF(b.min_size6kk <= 0,null,"6kk "+" "+"("+Format("{0:N1}", b.min_size6kk)+" - "+Format("{0:N1}", b.max_size6kk)+")"+" m2")}<br>

But if there is a NULL row a I get only empty row as you can see in the attachment, but I want to shrink the row together if there is a NULL row. I want to ignore this NULL row and move the lower row upper. How can I do that? Thank you

[HighAley]

Hello.

The BR tag is used in each line. You should change the expression so that the BR tag will not be there is the line in empty.

Thank you.

[x46x]

I tried delete BR tag, enabled "can shrink" and "shift mode" but I still have the empty rows if there is a NULL row..

[HighAley]

Hello.

Please, try to write the expression in one line.

Thank you.

[x46x]

If I write it in one line, I have everything in one row, but I want to have it under each other, but without NULL/empty rows..

[Alex K.]

Hello,

Please try to use several Text components with DockStyle=Top and CanShrink=true properties.

Thank you.

[x46x]

Hello,
I have this text component inside data band where is some other different text component, so I can't use this solution..

[x46x]

This is how it look. I need it on exactly same spot. If I use your solution - it moves on top of the band and expands over the entire band..

[Alex K.]

Hello,

You can use additional Panel component.

Thank you.

[x46x]

Many thanks, this is what I need.