Articles in this section
Category / Section

How to display no data message for a data region?

Published:
Updated:

This document describes how to display a message when no data exists in database or no row found for user selection in RDL report. It is always a good practice to show proper message when there is no data for user selection. To show proper message, you can set the custom message in No Rows property. No Rows is an option on a matrix, table, chart, sub-report, etc., that displays alternate text when the results of your query display no results.

To set the NoRowsMessage property for a table, matrix, list, or subreport

Select the table, matrix, or list data region or subreport on the design surface. The Properties panel displays the properties for the selected item.

In the Properties panel, under No Rows category set the text that you want to display as a message in Message property field.

no-data-for-table.png

Alternatively, you can set the message text based on dynamic values, by using the Expressions. Refer Set Expression and Reset Expression section to open set/reset expression menu in properties panel.
message-as-expression-in-table.png

During report preview the specified message will be displayed, if user specified value is not available in the database.no-data-for-table-preview.png

To set the NoDataMessage property for a chart

Select the chart on the design surface. The Properties panel displays the properties for the selected item.

In the Properties panel, under No Data category set the text that you want to display as a message in Message property field.

no-data-for-chart.png
Alternatively, you can set the message text based on dynamic values, by using the Expressions. Refer Set Expression and Reset Expression section to open set/reset expression menu in properties panel.
message-as-expression-in-chart.png

During report preview the specified message will be displayed, if user specified value is not available in the database.

no-data-for-chart-preview.png
Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied