Export (0) Print
Expand All
Expand Minimize

How to: Set a No Data Message for a Data Region (Report Builder 2.0)

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.

  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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft