set textbox value to no data available if dataset1 is null

Question

I have a table that is populated using dataset1 in my report.
I added =iif(Count("Error1")=0,true, false) to the hidden expression to hide the table if there is no data...this works.
I will like to have a message displayed on a texbox like "no rows returned" and also hide another texbox if there are no data returned from the dataset.
ideas??

Answer 1

for value , in expression

=iif(count("error1")=0, "No Data", fields!yourfield.value)

Answer 2

will this be in the hidden properties of the table? because that code didnt work for me. 

Answer 3

oh i gave you the sample, you have to change the field name as per your table.

it will be on the value property of the text box., does it make sense?

Answer 4

also there's a NoRows property you can enter a message in for a data region like a table which will then display when that dataset returns no rows

Answer 5

Thanks guys, after trying both, the message is still not being displayed.

@also there's a NoRows property you can enter a message in for a data region like a table which will then display when that dataset returns no rows


do i need another control to display the messge in the NoRowsMessage property?

Answer 6

ha...
@also there's a NoRows property you can enter a message in for a data region like a table which will then display when that dataset returns no rows

the reason was because the =iif(Count("Error1")=0,true, false) on the table hidden field was not removed. Once i removed it BAM it displayed my message. That solved the problem.

One more thing...is it possible to say iif(isNull(ds1),ReportItems!Textbox4.Hidden=True,Textbox4.Value)

Answer 7

Thanks guys, Nehemiah's solution works for me