How can show a message in SSRS?
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.
October 25th, 2010 6:25pm
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
Free Windows Admin Tool Kit Click here and download it now
October 25th, 2010 6:42pm
Each data item should have a "NoRows" property - when set, this message is shown rather than the data item (table / chart etc)Rgds Geoff
October 25th, 2010 8:46pm