1236
Part IX: Business Intelligence
sources can now be published to the Report Server and used by other developers in their
projects. Data sources created inside a Reporting Services project are deployed with the
project to the Report Server. Data source fi les are suffi xed with the .rds fi le extension.Although you can extend Reporting Services by creating a custom data extension, several
data source types are available out-of-the-box:■ Microsoft SQL Server■ (^) Windows Azure SQL Database (introduced in SSRS 2008 RS as SQL Azure)
■ Microsoft SQL Server Parallel Data Warehouse (offered since SSRS 2008 R2)
■ (^) OLE DB
■ Microsoft SQL Server Analysis Services
■ (^) Oracle
■ ODBC
■ (^) XML
■ Report Server Model
■ (^) Microsoft SharePoint List (offered since SSRS 2008 R2)
■ SAP NetWeaver BI
■ (^) Hyperion Essbase
■ TERADATA
Datasets
The dataset represents a fi ltered subset of the data from the data source. Using the example
of the data source being a SQL Server database, the dataset would be a query. New with SQL
Server 2008 R2, datasets can also be shared inside a project and published to the Report
Server for consumption by other reporting projects. Dataset fi les are denoted by the fi le
extension .rsd. Defi ning or changing a dataset launches the Dataset Properties dialog,
which includes several tabs:
■ (^) Query: Consists of most any string appropriate to the data source, including SQL
statements, stored procedure calls, or XML queries.
■ (^) Parameters: Displays the parameters used in the query and the mapping to the
report’s parameters.
■ (^) Fields: Lists all fi elds returned by the query and the corresponding names used in
the dataset. When the names of the fi elds can’t be determined at design time, these
names must be manually entered. Calculated fi elds may also be added here, which
helps centralize expressions referred to frequently in the report. (For example,
defi ning profi t as [revenue] − [expenses] enables profi t to be referred to throughout
the report as if it came from the source data.)
c55.indd 1236c55.indd 1236 7/31/2012 10:28:04 AM7/31/2012 10:28:04 AM
http://www.it-ebooks.info