dumb question

Hi all, yes this is a dumb question, but I cant find a formatting answer...
A zero value eg 0, or 0.0 is supressed on RS reports by default.
How can I stop this, the report must show all zeros regardless in a total
field.
If I use default as the format type then I will see 0, but as the field is a
percentage, I have to use the % attribute for the format type..
So, how can I force the showing of a zero in a total fiel ie. 0%
Thanx in advanceHow about =iif(Fields!Total.value>0,Fields!Total.value,0) in the expression
of that text box. Then right click the text box and pick properties format
and put in P (for percent or P0 or P1 according to how many places you want
after the decimal. Hope that works for you.
"Scotchy" wrote:
> Hi all, yes this is a dumb question, but I cant find a formatting answer...
> A zero value eg 0, or 0.0 is supressed on RS reports by default.
> How can I stop this, the report must show all zeros regardless in a total
> field.
> If I use default as the format type then I will see 0, but as the field is a
> percentage, I have to use the % attribute for the format type..
> So, how can I force the showing of a zero in a total fiel ie. 0%
> Thanx in advance|||Hi KimB, thanks for your suggestion, actuall tried that approach to no avail.
cheers
Paul
"KimB" wrote:
> How about =iif(Fields!Total.value>0,Fields!Total.value,0) in the expression
> of that text box. Then right click the text box and pick properties format
> and put in P (for percent or P0 or P1 according to how many places you want
> after the decimal. Hope that works for you.
>
> "Scotchy" wrote:
> > Hi all, yes this is a dumb question, but I cant find a formatting answer...
> >
> > A zero value eg 0, or 0.0 is supressed on RS reports by default.
> >
> > How can I stop this, the report must show all zeros regardless in a total
> > field.
> >
> > If I use default as the format type then I will see 0, but as the field is a
> > percentage, I have to use the % attribute for the format type..
> >
> > So, how can I force the showing of a zero in a total fiel ie. 0%
> >
> > Thanx in advance|||Have you tried =iif(Fields!Total.value>0,Fields!Total.value,"0.0%")? I
think that should work for you.