Chapter 8. Retrieving data for a report

Reports are powerful tools that help you visualize and share data in various ways. Therefore, the first step in creating a report is getting data! Reporting Services supports a number of different data sources you can use to easily create reports on your data, no matter how and where it’s stored. After you identify where the data is stored, you provide Reporting Services with the query to use to retrieve data from each source.

Understanding data source types

The first step to accessing your data for a report is to create a data source. A data source is fundamentally a connection string. The content of this connection string depends on the data provider that you use. For example, a connection string for a SQL ...

Get Microsoft SQL Server 2012 Reporting Services now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.