Paginated Report with no data

Amik_singh — Fri, 26 Dec 2025 16:36:05 GMT

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?

Re: Paginated Report with no data

Amar_Kumar — Fri, 26 Dec 2025 16:43:01 GMT

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)

topic Paginated Report with no data in Report Server

Paginated Report with no data

Re: Paginated Report with no data