Connecting to Report Data
Before you can begin to build your report, you must create at least one data source definition. A data source definition provides details about how to connect to an underlying data source, such as a SQL Server relational database, an Analysis Services database, or an Oracle database. The data source definition specifies the data source type, a connection string, and credentials. Each type of data source requires different connection information. Data source definitions can be saved to a report server and managed as separate files or embedded in the report definition.
After you create a data source, you must create at least one dataset. A dataset specifies the fields from the data source that you plan to use in the report, as well as calculated fields that you create. A dataset contains the query and field information, a pointer to the data source definition, query parameters, and data options that include character sensitivities including case, kana type, width, accent, and collation information.