Show message "NO DATA FOUND" in SSRS report

reporting-services ssrs-2008-r2
Prashant Khadatkar picture Prashant Khadatkar · Mar 3, 2014 · Viewed 12.3k times · Source

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

Answer

BIReportGuy picture BIReportGuy · Nov 23, 2016

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)

Related questions

How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More
SSRS Format to display as percent

I've gone through quite a few examples on here and I apologize if I'm asking a repeat question, as far as I can tell, I am not. I have an SSRS report made that shows gross sales for certain aspects …

Read More
SQL Server Reporting Services 2008 R2 always show for login prompt

Whenever I try to access SSRS 2008 R2 through a URL (i.e. after being published on the net), it always shows a login prompt when accessing the report. The problem does not appear in the development environment. How do I …

Read More