Overview of SQL Server Reporting Services 2012 Architecture, Features, and Tools - Learning SQL Server Reporting Services 2012 - page 141

</ConnectionProperties>
<DataSourceID>893b9e01-8a18-4abe-bb89-61c804b3aabb
</DataSourceID>
</RptDataSource>
This defines a DataSourceID for obtaining data in the Northwind database tables
on the SQL Server 2012. The access method is via Windows Authentication. The
DataSource name is DataSource1 . The <IntegratedSecurity/> tag with value
true is for Windows Authentication.
With this as the connection, a dataset is derived from one of the tables as shown
in the next XML document for the dataset:
<?xml version="1.0" encoding="utf-8"?>
<SharedDataSet
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/
reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/
reporting/2010/01/shareddatasetdefinition">
<DataSet Name="">
<Query>
<DataSourceReference>DataSource1</DataSourceReference>
<CommandText>SELECT LastName, FirstName
FROM Employees</CommandText>
</Query>
<Fields>
<Field Name="LastName">
<DataField>LastName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="FirstName">
<DataField>FirstName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
</DataSet>
</SharedDataSet>
Here the following query is used to just extract FirstName and LastName from the
Employees table in the Northwind database. This is a shared dataset that can be used
in more than one report, if needed. Have a look at the following query:
SELECT LastName, FirstName
FROM Employees
This dataset populates the layout elements that you choose from the Toolbox
completing the report design. The report with RDL extension has all the XML
elements of data and the layout information.