Hi, I want to show the user a message in the SSRS page saying "No records found." when the stored does not return any values. Currently my reports shows the report headers. How do I do it? Please help. Thank you.

Hi, I want to show the user a message in the SSRS page saying "No records found." when the stored procedure does not return any values. Currently my reports shows the report headers. How do I do it? Please help. Thank you.

Did you assign "NO Rows" property of the tablix/table to "No Records found" ?Rajkumar Yelugu

Hello, to do this, select your table, list, or matrix that you use to display your SP dataset. Then in the properties panel to the left look for the NoRows property where you can enter in a message that will be displayed when no data is returned.

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/bac68b63-2778-4fc5-b2ed-bc73b36fc549 This link should help you either .Rajkumar Yelugu

Yes it does work. Thank you for your help. But can I do it on a whole report level becuase I have several tablix in my report and I don't want the message to repeat for each tablix. I just want one message. Is it possible.

You can add a OR condition in the IIF as below for all the datasets you have. =iif(count(Fields!Row1.Value,"DatasetName")>0 OR count(Fields!Row2.Value,"DatasetName")>0 ,"","No rows found")

Thank you all for the help.

Yes it does work. Thank you for your help. But can I do it on a whole report level becuase I have several tablix in my report and I don't want the message to repeat for each tablix. I just want one message. Is it possible. you can set your other tables to an empty string instead of the message

Hi, You could have a text box which is only visible if then number of rows returned is zero - and the table with the headers is set to hide when the count is zero. To get this valule I add an extra row to my table (always set to hidden) which has the row count value in it - it will look like this: =CountRows("NameofDataSet"). Then give the cell it appears in a name like RowCounter. Then for the data set table under visibility add this =IIF(ReportItems!RowCounter.Value > 1, True,False) and vice versa for the one you want to hide. Seth http://lqqsql.wordpress.com

Each data item should have a "NoRows" property - when set, this message is shown rather than the data item (table / chart etc)Rgds Geoff