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

By |2017-12-11T11:56:28+00:00February 22nd, 2013|Azure, Cloud|0 Comments

Working with BIDS, playing with column visibility for formatting issues and I got the above message when using the following:


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.



Leave A Comment

like what you see? 

Sign-up to our newsletter and never miss out on the latest blogs, events and tech news from the world of risual
Give it a try, you can unsubscribe anytime.