6

I have created SSRS report having 3 columns in it. Now, I have to show "NO DATA FOUND" message below report header. How can I achieve it. I cant not use report property "NO ROW" as I have to show Report Header also.

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 is not working. Please suggest me, where I am doing wrong. Thanks

Prashant Khadatkar
  • 200
  • 1
  • 3
  • 18

2 Answers2

3

You can do the following if using a table...since the table doesn't have the NoRowsMessage feature:

1. Add a text box with expression =IIF(Count(Some Field,"DataSet1")=0,"No Data Returned", nothing)

2. Then, set the visibility of this textbox as =IIF(Count(Some Field,"DataSet1")=0,False,True)

BIReportGuy
  • 799
  • 3
  • 13
  • 36
1

The reason I imagine it is not working is you have this textbox in a data (non-header) row of the tablix. Since there is no data, this row will be repeated exactly zero times.

You should be able to do either of the following:

  • Add a header row to the table with the text "NO DATA FOUND" which is hidden on =Count(Fields!ContentId.Value) > 0.

  • Add a normal textbox outside of the tablix below the table, similar to the above. You may need to explicitly specify the data source. If it is hidden, the space should be consumed and the report will display as normal.

lc.
  • 113,939
  • 20
  • 158
  • 187