Data set is the record-set which works as the input for data region in SSRS report.You can visualize the data for a report data set as a set of rows and columns. There must be at least one column and zero or more rows.
A report data set can consist of the following types of data:
No Rows Message
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 data set 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.
A report data set can consist of the following types of data:
- A result set from a relational database
- A flattened row set from multidimensional data sources.
- A flattened result set from XML data sources that include XML elements, their attributes, and their child elements.
- A result set from any registered and configured .NET Framework data provider.
- Data from a report model that has been designed for a specific data source.
No Rows Message
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 data set 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.
No comments:
Post a Comment