SSRS - Checking whether the data is null
Posted
by NLV
on Stack Overflow
See other posts from Stack Overflow
or by NLV
Published on 2010-03-18T09:25:36Z
Indexed on
2010/03/18
13:41 UTC
Read the original article
Hit count: 186
Filed under:
ssrs-2005
|reporting-services
Hello
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.
Thank you.
NLV
© Stack Overflow or respective owner
