Paginated Report with no data
When my Paginated Report filters result in no data, the report just displays a blank page or a header with empty rows. How can I show a friendly 'No Data Found' message instead?
You can use the NoRowsMessage property combined with some basic styling to make your report look polished even when it's empty.
Step 1: Set the Message
Click on your Tablix (the table or matrix) in the design view.
In the Properties pane, locate the NoRowsMessage property.
Type your custom message, e.g., "No sales data available for the selected period."
Step 2: Format the Message
By default, this text is small and tucked in the corner. To make it look like a formal notification:Expand the NoRowsMessage property in the pane.
Set TextAlign to Center.
Step 3: The "Magic" Toggle (Optional)
If you want to hide the entire table header when there is no data:
Select the Table Row containing your headers.
In the Visibility property, use this expression:
=IIF(CountRows("YourDatasetName") > 0, False, True)
