Creating Reports with SSRS - Pro SQL Server 2012 BI Solutions - page 667

Listing 16-2. XML Code in a Typical RSD Dataset File
<?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> DWPubsSalesDataSource </DataSourceReference>
<CommandText> SELECT
PublisherName
, [Title]
, [TitleId]
, [OrderDate]
, [Total for that Date by Title]
FROM vQuantitiesByTitleAndDate
</CommandText>
</Query>
<Fields>
<Field Name="PublisherName">
<DataField>PublisherName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Title">
<DataField>Title</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="TitleId">
<DataField>TitleId</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="OrderDate">
<DataField>OrderDate</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Total_for_that_Date_by_Title">
<DataField>Total for that Date by Title</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
</DataSet>
</SharedDataSet>
To create a shared dataset, right-click the Shared Datasets folder in Solution Explorer and choose Add New
Dataset from the context menu, as shown in Figure 16-18 .
A Shared Dataset Properties dialog window appears where you can identify the name, data source, query
type, and query for the dataset, as shown in Figure 16-19 .