Replace Zero with Blank in SSRS

Question

Is it possible to replace 0 with blank in ssrs matrix. The expression =IIF(IsNothing(Count(Fields!referralNo.Value)),0,Count(Fields!referralNo.Value))
is same as
=Count(Fields!referralNo.Value).
When I try =IIF(IsNothing(Count(Fields!referralNo.Value)),'',Count(Fields!referralNo.Value)) I'm getting error. Can somebody pls help!

Count won't return Nothing, it will return 0. Also, what is your error? — StevenWhite, Mar 02 '17 at 20:04

Kostya · Answer 1 · 2017-03-02T20:05:47.177

16

you could use text box properties and set show zero as: option to blank.

edited Mar 02 '17 at 20:05

answered Mar 02 '17 at 19:39

Kostya

1,567
1
9
15

2

for Percentage option, how to set zero as empty space – Rajkumar Feb 07 '18 at 14:28
check below @Rajkumar – goneos Feb 12 '18 at 03:19

goneos · Answer 2 · 2019-03-26T03:01:17.740

2

I use this expression for percentage data - I like code better than format, but they both work ;)

=iif(Fields!STUFF_PCT.Value>0,Fields!STUFF_PCT.Value,"")

edited Mar 26 '19 at 03:01

answered Feb 12 '18 at 03:19

goneos

319
2
4
16

score 0 · Answer 3 · edited Jan 13 '23 at 22:19

0

Use this format #,##0.00;-#,##0.00;""

edited Jan 13 '23 at 22:19

Dale K

25,246
15
42
71

answered Aug 10 '18 at 14:47

Ketan Palanpurwala

1

You probably should be more explicit – XavM Aug 10 '18 at 14:52

Replace Zero with Blank in SSRS

3 Answers3