Show "NO DATA FOUND" in SSRS Report

Question

I created an SSRS report containing 3 columns. Now I have to show the message “NO DATA FOUND” below the report title. How can i achieve this. I cannot use the report property "NO ROW", because I must also show the title of the report.

Followings are the fields in my Report tabix:
ContentId,
Version
ApprovedBy

I have tried following to show "NO DATA FOUND" message:
In Tabix textbox, I have added expression:
=IIF(Count(Fields!ContentId.Value)=0 OR IsNothing(Fields!ContentId.Value)=true,"NO DATA FOUND.",NOTHING)

But, it does not work. Please suggest me where I am doing wrong. Thanks

Answer 1

The reason I think it doesn’t work is because you have this text box in the data line (without a header) in tablix. Since there is no data, this line will be repeated exactly at zero time.

:

• "NO DATA FOUND", =Count(Fields!ContentId.Value) > 0.

• , . , . , , .

Answer 2

: NoRowsMessage:

1. = IIF (Count ( , "DataSet1" ) = 0, "No Data Returned", )

2. = IIF (Count (Some Field, "DataSet1" ) = 0, False, True)