Our next step is to create the shared dataset for the project. Before doing that, let's create a stored procedure named
dbo.uspSalesDetails. This is going to be the query for our dataset.
Download the T-SQL codes included in this book if you haven't done so already. We're going to use the T-SQL file named
uspSalesDetails_Ch01.sql for this chapter.
We will use the same stored procedure for this whole chapter, unless otherwise indicated.
Shared Datasetsfolder in Solution Explorer, just like we did when we created the data source. That displays the Shared Datasets Properties dialog.
ds_SalesDetailReport. We use the query type stored procedure, and select or type