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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics