Creating reports and dashboards | Stimulsoft community forum

Posted: **Thu Aug 25, 2016 7:42 am**

Hi, I have this in "Text" band:

{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

Posted: **Thu Aug 25, 2016 10:00 am**

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.

Posted: **Thu Aug 25, 2016 10:07 am**

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

Posted: **Thu Aug 25, 2016 11:20 am**

Hello.

Please, try to write the expression in one line.

Thank you.

Posted: **Thu Aug 25, 2016 11:37 am**

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..

Posted: **Fri Aug 26, 2016 7:35 am**

Hello,

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

Thank you.

Posted: **Fri Aug 26, 2016 7:43 am**

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

Posted: **Fri Aug 26, 2016 8:42 am**

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..

Posted: **Fri Aug 26, 2016 2:28 pm**

Hello,

You can use additional Panel component.

Thank you.

Posted: **Mon Aug 29, 2016 12:20 pm**

Many thanks, this is what I need.

Creating reports and dashboards | Stimulsoft community forum

NULL row in text

NULL row in text

Re: NULL row in text

Re: NULL row in text

Re: NULL row in text

Re: NULL row in text

Re: NULL row in text

Re: NULL row in text

Re: NULL row in text

Re: NULL row in text

Re: NULL row in text