Defining Report Data Sources
When you create reports in Reporting Services, you first define one or more data source definitions. A data source definition provides details about how to connect to an underlying data source. It specifies the data source type, a connection string, and credentials. Each type of data source requires different connection information.
Reporting Services provides data processing extensions to support relational databases, multidimensional databases, report models, and XML-based data. In addition, you can register and report from standard .NET Framework data providers. Standard .NET Framework data providers do not necessarily support all the features provided by Reporting Services data processing extensions. Data retrieved from a report data source is primarily in the form of a tabular rowset. Other retrieved information depends on the type of data source. You can create custom data processing extensions for other data source types. For more information, see Implementing a Data Processing Extension.
Data sources can be embedded in a report or defined so they are shared among multiple reports. A single report can contain any number of data sources, both report-specific and shared. When you define a shared data source using Report Designer, the data source definition is saved as an item in the report project and can be managed independently from other project items. Similarly, when you publish a report to a report server, each report data source can be managed independently from the report. For more information, see Setting Properties on a Published Report.
Published data sources can be secured through role-based security. You set security on a shared data source item to control access to the data source item in the report server. For more information, see Securing Shared Data Source Items.
Once the data source is published, you may need to adjust credential or connection information for data sources used to test your report when the report is published. For more information, see Setting Data Source Properties in Reporting Services.
After you have defined the data sources for your report, you define datasets that contain the specific fields you will use in your report. For information about datasets, see Defining Report Datasets.
- Data Sources Supported by Reporting Services
Provides a list of data sources supported by Reporting Services.
- Differences Between Data Processing Extensions and Standard .NET Data Providers
Explains the difference between the Reporting Services data processing extensions installed with Reporting Services and standard .NET Framework data providers that can be installed and registered as report data sources.
- Query Designers and Data Processing Extensions
Explains the relationship between the Reporting Services query designers and associated report data source types.
- Creating, Modifying, and Deleting Shared Data Sources
Explains how to manage data sources published on a report server and data sources local to the client before they are published.
- Connecting to a Data Source
Explains how to connect to a data source and specify the necessary credentials. Includes examples of connection strings for different data source types.
- Setting Data Source Properties in Reporting Services
Provides directions on setting properties of both shared and report-specific data sources once they have been published to a report server.
TasksHow to: Create, Delete, or Modify a Shared Data Source (Management Studio)
How to: Specify Stored Credentials for a Data Source (Management Studio)
How to: Configure a Report-Specific Data Source (Report Manager)
How to: Create or Edit a Report-Specific Data Source (Report Designer)
How to: Create a Report Model Data Source (Report Designer)
ConceptsShared Data Sources and Report-Specific Data Sources
Securing Shared Data Source Items
Other ResourcesData Source Properties (Connection Page)
General Properties Page (Shared Data Sources, Report Manager)
Data View (Report Designer)