How to: Set a No Data Message for a Data Region

  • Article

When you want to specify text to show in the rendered report in place of a data region that has no data, set the NoRowsMessage property for a table, matrix, or list data region or the NoDataMessage for a chart data region. At run time, the report processor runs the query for each dataset in a report and the dataset query may produce no result set. For a data region bound to an empty dataset, you can specify text to display instead of displaying an empty data region. You can also set the NoRowsMessage property for a subreport when no datasets in the subreport have data at run time.

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

  1. In Design view, click the table, matrix, or list data region or subreport on the design surface to select it. The Properties pane displays the properties for the selected item.

    Note

    If you do not see the Properties pane, click Properties Window in the View menu.

  2. In the Properties pane, type the text that you want to display as a message in NoRowsMessage property field.

    Alternatively, from the drop-down list, click Expression to open the Expression dialog box and create an expression.

To set the NoDataMessage property for a chart

  1. In Design view, click the chart on the design surface to select it. The Properties pane displays the properties for the selected item.

  2. In the Properties pane, expand the node for NoDataMessage.

  3. In Caption, type the text that you want to display as a message in NoDataMessage property field.

    Alternatively, from the drop-down list, click Expression to open the Expression dialog box and create an expression.

To set the NoRowsMessage for a subreport

  1. In Design view, click the subreport on the design surface to select it. The Properties pane displays the properties for the selected item.

  2. In the Properties pane, type the text that you want to display as a message in NoRowsMessage property field.

    Alternatively, from the drop-down list, click Expression to open the Expression dialog box and create an expression.

See Also

Concepts

Working with Data Regions

Creating a Report Dataset

Adding Subreports

Working with Report Designer in Business Intelligence Development Studio