Creating reports and dashboards | Stimulsoft community forum

Hi all,

In one report, I have text components next to each others, to form a table (as it would be shown in Excel for example).
Problem is that if my query returns null values, "0" is displayed.
To avoid this, I set up disabling conditions for each of my components, which is quite time consuming.

Then, 2 questions:
- is there another solution to avoid this "0" issue than defining conditions?
- if no, problem is that if I define a condition to disable the component if value is null, borders are disabled too! So my table doesn't look like a table anymore! How can I deal with that?

Thank you for your help.

Hello.

Jennypi wrote:In one report, I have text components next to each others, to form a table (as it would be shown in Excel for example).
Problem is that if my query returns null values, "0" is displayed.
To avoid this, I set up disabling conditions for each of my components, which is quite time consuming.

Then, 2 questions:
- is there another solution to avoid this "0" issue than defining conditions?
- if no, problem is that if I define a condition to disable the component if value is null, borders are disabled too! So my table doesn't look like a table anymore! How can I deal with that?

Please, try to set the Hide Zeros property of Text component to true.

Thank you.

Thanks I'll try.
But what happens if the value returned by the DB is really "0" ? (I mean not null, but the number 0)
Will it be hidden too?

Hello.

Jennypi wrote:Thanks I'll try.
But what happens if the value returned by the DB is really "0" ? (I mean not null, but the number 0)
Will it be hidden too?

Yes, it will be hidden.

Thank you.