Database Reference
In-Depth Information
2.
In the
Query
tab of the
Dataset Properties
window, give the dataset a name
(for example,
ds_SalesSummary
), and select the
Use a dataset embedded
in my report option
, which allows us to specify the dataset via a query or
stored procedure.
3.
In the
Data source
section, select the data source reference (for example,
sds_DW_AdventureWorks
) from the drop-down list of available data
sources in the report.
4.
In the
Query
textbox, enter the following text, and click on
OK
to finish
creating the embedded dataset:
SELECT dd_ord.CalendarYear
,dd_ord.MonthNumberOfYear
,dd_ord.EnglishMonthName AS [Month]
,SUM(fis.SalesAmount) AS [TotalSalesAmount]
FROM dbo.FactInternetSales fis
INNER JOIN dbo.DimDate dd_ord ON dd_ord.DateKey = fis.
OrderDateKey
GROUP BY dd_ord.CalendarYear
,dd_ord.MonthNumberOfYear
,dd_ord.EnglishMonthName
Dataset Properties dialog box