Export (0) Print
Expand All

Report Data Pane (Report Builder)

Use the Report Data pane to view the currently defined parameters, data sources, datasets, field collections, and images in your report. The Report Dane displays a hierarchical view of the items that represent data in your report. The top level nodes represent built-in fields, parameters, images, and data source references. Expand each node to view the data items. For example, when you expand a data source node, the datasets defined for that data source appear. When you expand a dataset, its field collection appears. Drag items to the report design surface or to the Grouping pane to link data with selected report items on the report page. For more information, see Report Design View (Report Builder).

Built-in Fields

Represents commonly used fields in a report, such as the report name or page number. For more information, see Built-in Collections in Expressions (Report Builder and SSRS).

Parameters

Represents the collection of report parameters, each of which can be single-valued or multivalued. For more information, see Report Parameters (Report Builder and SSRS).

Images

Represents the set of images used in the report. For more information, see Images (Report Builder and SSRS).

Data sources

Represents an embedded data source or a reference to a shared data source. A data source represents a source of data for the report. A data source is the parent node for the collection of datasets that use it. For more information, see Add Data to a Report (Report Builder and SSRS) and Data Connections, Data Sources, and Connection Strings in Report Builder.

Datasets

Represents the data that is retrieved from a data source by running one command, for example, a Transact-SQL query that retrieves data from a SQL Server database. A dataset is the parent node for the collection of fields that is specified by the query, and also includes calculated fields. Report Builder supports query designers that help you specify a query. For more information, see Add Data to a Report (Report Builder and SSRS).

Community Additions

ADD
Show:
© 2014 Microsoft