In the property window os Visual studio (SSRS) check 'NoRowsMessage' property for tablix. You can set this property to show a custom message when no row is returned.
NORowsMessage = "No data available for current filter selection" //user defined msg that is to be displayed
Add a text box with expression =IIF(Count(<SomeId Field>,"DataSet1")=0,"No Data Returned", nothing)
Or
set the visibility of this textbox as =IIF(Count(<SomeId Field>,"DataSet1")=0,False,True)
In the table header (header fields), use expression for each of the column headers to Set the visibility to false so that the end user won’t be able to see the table header when there is no data.
No comments:
Post a Comment