I have a line and a table in my report that I want to hide if my dataset has no rows in it.
I tried using the expression =CountRows("MyDataSet") > 0
in the initial visibility but this always evaluates to false, even when there are rows in the dataset.
I suspect initial visibility is run before the data is loaded into the dataset.
How can I set the visibility of my table and other elements (a line), based on if the dataset has any rows or not?
Best Answer
This appears to work in
2008
- hopefully it will help ...I created a
DataSet
with one record in it. I then created a text box and put your code in the 'Hidden' property in theVisibility
Properties section.I then changed it to
Which will return
TRUE
when there are no rows, which will set the control to hidden.