In the property window 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 displayedYou can also specify the specific font style like size, color, format etc.
Add a text box with expression =IIF(Count(<SomeId Field>,"DataSet1")=0,"No Data Returned", nothing)
(OR)
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.
NORowsMessage = "No data available for current filter selection" //user defined msg that is to be displayedYou can also specify the specific font style like size, color, format etc.
Add a text box with expression =IIF(Count(<SomeId Field>,"DataSet1")=0,"No Data Returned", nothing)
(OR)
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.
set the visibility of this textbox as =IIF(Count(<SomeId Field>,"DataSet1")=0,False,True)
No comments:
Post a Comment