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.
[quoted text, click to view] "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%
>
Hi KimB, thanks for your suggestion, actuall tried that approach to no avail.
cheers
Paul
[quoted text, click to view] "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%
> >
Have you tried =iif(Fields!Total.value>0,Fields!Total.value,"0.0%")? I
think that should work for you.
Don't see what you're looking for? Try a search.
