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.
Text component disabled if value is null -> keep borders?
Text component disabled if value is null -> keep borders?
Hello.
Thank you.
Please, try to set the Hide Zeros property of Text component to true.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?
Thank you.
Text component disabled if value is null -> keep borders?
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?
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?
Text component disabled if value is null -> keep borders?
Hello.
Thank you.
Yes, it will be hidden.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?
Thank you.