Format empty matrix cells in SSRS

Question

When I apply a 0.00% format to a cell while designing an SSRS report, then export to Excel, only cells containing values have this number format. Cells without data default to the "General" format.

Is there a way to format empty cells so that they have the 0.00%?

Thanks.

Answer 1

You could try an expression like this in your cell:

=IIf(IsNothing(Fields!MyColumn.Value),0,Fields!MyColumn.Value)

If the field is empty then it puts 0, otherwise it uses the data.

Answer 2

You can solve the referencing of Empty Cell values using the ReportItem expression.

A solution is posted in the article by darkdusky.

Use =ReportItems!textbox4.Value in the blank cells to make comparisons for cell values.