The query returned no rows for the dataset. The expression therefore evaluates to null

risual | 22nd February 2013 | Azure

Working with BIDS, playing with column visibility for formatting issues and I got the above message when using the following:
=iif(isNothing(QueryValues))
isNothing doesn’t take into consideration empty datasets. To get around it use the following:
=iif(CountRows() = 0, false, true) / =iif(CountRows() = 0, true, false)
Depending on your needs for not visible/visible.
Cheers,
Jason.

About the author

risual