Paginated Report with no data

[Amik_singh]

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?

[Amar_Kumar · Accepted solution]

@Amik_singh 

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)