Export (0) Print
Expand All

Creating a Report Dataset (Report Builder 2.0)

SQL Server 2008

When you create reports inReport Builder 2.0, you first define one or more data sources and then you create one or more datasets for each data source. Each dataset specifies the fields from the data source that you plan to use in the report, and calculated fields that you can create. In addition to the query and field definitions, a dataset contains a pointer to the data source, query parameters, and data options that include character sensitivities including case, kana type, width, accent, and collation information.

After you create a dataset, you can view the name of the dataset and its field collection in the Report Data pane. From the Report Data pane, you can create additional fields or edit existing fields. For more information, see Working with Fields in a Report Dataset (Report Builder 2.0).

To display data in your report, link a dataset to a data region, such as a table or chart, by dragging fields from the Report Data pane to a data region on the design surface. For more information about each type of data region and the concepts of preparing, filtering, and grouping your data, see Working with Data Regions (Report Builder 2.0), Filtering Data in a Report (Report Builder 2.0), and Grouping and Sorting Data (Report Builder 2.0).

Report Builder 2.0 provides the following features to help you create datasets that specify the data that you want in your report:

Report models are, in effect, predefined datasets. Someone with expertise in model design must first create a report model and publish it before it can be used in a report. You can use a report model as a data source for both full-featured reports and for ad hoc reports created in Report Builder 1.0. You do not have to create a dataset query when working with a report model because the model builds the query for you as you work with the data. Report models contain predefined fields and data relationships, called entities and roles, that appear in the Data pane when you select a report model as a data source, and which can be used in the same way that dataset fields are used. For more information about how to build report models, see "Working with Model Designer" in the Reporting Services documentation in SQL Server Books Online. For more information about creating ad hoc reports, see "Working with Report Builder" in the Reporting Services documentation in SQL Server Books Online.

To learn more about how to connect to and retrieve data from the data sources, see the topics in this section.

Understanding Report Datasets (Report Builder 2.0)

Describes the characteristics of data retrieved from a data source.

Creating Report Datasets from a SQL Server Relational Database (Report Builder 2.0)

Discusses how to define a dataset from a SQL Server relational database.

Creating Report Datasets from SQL Server Analysis Services (Report Builder 2.0)

Discusses how to define a dataset from an Analysis Services multidimensional database.

Creating Report Datasets from XML Data (Report Builder 2.0)

Discusses how to define a dataset from XML data in an XML document, Web service, or Web application.

Creating Report Datasets from an Oracle Database (Report Builder 2.0)

Discusses how to define a dataset from an Oracle database.

Creating Report Datasets from an SAP NetWeaver BI Data Source (Report Builder 2.0)

Discusses how to define a dataset from an SAP NetWeaver Business Intelligence data source.

Creating Report Datasets from a Hyperion Essbase Data Source (Report Builder 2.0)

Discusses how to define a dataset from a Hyperion Essbase data source.

Defining Report Datasets from a Teradata Database (Report Builder 2.0)

Discusses how to define a dataset from a Teradata data source.

Creating Report Datasets for Other Data Sources (Report Builder 2.0)

Discusses how to define a dataset using a data source from an OLE DB, ODBC, or other data provider.

Creating Report Datasets for a Report Model (Report Builder 2.0)

Discusses how to access a report model as a predefined dataset.

Working with Fields in a Report Dataset (Report Builder 2.0)

Discusses general dataset field collection issues.

Community Additions

ADD
Show:
© 2015 Microsoft