SSRS - Checking whether the data is null
reporting-services, reportingservices-2005
Solution
try like this
= IIF( MAX( iif( IsNothing(Fields!.Reading.Value ), -1, Fields!.Reading.Value ) ) = -1, "", FormatNumber( MAX( iif( IsNothing(Fields!.Reading.Value ), -1, Fields!.Reading.Value ), "CellReading_Reading"),3)) )
Problem
I've the following expression in my report. ``` =FormatNumber(MAX(Fields!Reading.Value, "CellReading_Reading"),3) ``` Now when the dataset is empty 'Fields!Reading.Value' becomes empty and finding their maximum is invalid. How can i check if the entire column is empty? I tried the following with no luck. ``` =iif(IsNothing(Fields!.Reading.Value),"",FormatNumber(MAX(Fields!Reading.Value, "CellReading_Reading"),3)) ``` But still i'm getting #Error in the report. I also checked out link and was not able to get a clue from it. I want to handle it in the report level.