Replace Zero with Blank in SSRS

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!

Upvotes: 5

Answers (3)

Ketan Palanpurwala

Reputation: 1

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

Upvotes: 0

goneos

Reputation: 319

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,"")

Upvotes: 2

Kostya

Reputation: 1605

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

Upvotes: 17

Replace Zero with Blank in SSRS

Answers (3)

Related Questions