topic Re: Display zero instead of blank in Matrix on Paginated Report in Report Server

Display zero instead of blank in Matrix on Paginated Report

ShaelynFrench — Tue, 27 Jun 2023 21:25:39 GMT

Hi,

I've tried all of the tricks --- using:

=Sum(Fields!QMonthly_Actual.Value) +0

=IIF(IsNothing(Sum(Fields!QMonthly_Actual.Value)), 0, Sum(Fields!QMonthly_Actual.Value))

and both formulas still return a blank in the report instead of a zero. Am I missing something?

Thanks!

Re: Display zero instead of blank in Matrix on Paginated Report

d_gosbell — Wed, 28 Jun 2023 09:44:47 GMT

I just tested both of the approaches you've tried here and they both worked fine for me.

So you have something else going on in your report.

Re: Display zero instead of blank in Matrix on Paginated Report

ShaelynFrench — Thu, 29 Jun 2023 03:12:13 GMT

I solved it -- I was using a custom number format: #,###;(#,###) that did not specify how to handle the zero so it was showing up blank. I changed it to: #,###;(#,###);0 and that solved it.