There is a '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"
You can also set font size etc.
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 wont be able to see the table header when there is no data.
No comments:
Post a Comment