SSRS 2012 2008 Data sources Data sets Data regions

Data sources - Data sets -Data regions  in SSRS 2012 2008 Reporting Services

  1. Data sources - Data sets -Data regions Core SQL Server Reporting Services Components exist that are important for creating reports in SSRS 2012 and 2008. 
  2. Here we have described this three main components for making better reports
Data sources
  1. Data sources provide the connection information that Reporting Services require to access the source data.
  2. Typical configuration for data sources involve specifying the name of the server on which the data is stored. You also specify the credentials that are required to connect to the server and the name of the database to access. You should also consider that additional settings may be required between different types of data sources.
  3. Multiple data sources can be defined and used within a single report.
  4. The following data sources are supported by Reporting Services out-of-the-box:

  • SQL Server relational databases
  • Analysis Services multidimensional databases
  • XML data sources
  • Report Server Models
  • SAP multidimensional databases
  • Hyperion Essbase
  • Oracle databases
  • Teradata relational databases
  • DB2 databases
  • OLE DB data source
  • ODBC data source
Data sets
  1. Data sets are used to return specific data from a defined data source.
  2. The data that is returned in the data set can then be used in the report.
  3. When retrieving datasets from Analysis Services or XML, the data from these data sources are flattened so that they may be used within a report.
  4. Multiple data sets can be defined and used within a single report
  5. When creating a data set against a SQL Server data source, there are three ways that the data set can be generated:

  • From a specific query
  • From a stored procedure
  • From a specific table or view
Data regions
  1. The data region is the area of the report that holds the data that is generated from a data set. 
  2. A new type of data region that has been introduced is the Tablix data region. 
  3. Tablix combines the benefits of both a table and matrix data region, which gives greater flexibility in the design of the report. 
  4. The Tablix data region is not explicitly found in any of the report authoring tools.
  5. This functionality has been added to the table and matrix data region properties in Report Designer
  6. SSRS provides the following data regions:

  • Table
  • Matrix
  • List
  • Chart
  • Gauge


Post a Comment