Now, let's set up a cascading parameter between Category and Subcategory. We want to only show subcategories that belong to a particular category. So, if we select Bikes on our Category parameter, we want to see only the subcategories that belong to bikes, that is, mountain bikes, road bikes, and touring bikes.
Let's create a stored procedure named
dbo.uspSubcategory. Run the script called
uspSubcategory_Ch01.sql included in this book.
After we create the
dbo.uspSubcategory stored procedure, let's create a new dataset out of that procedure. Let's name it
uspSubcategory stored procedure accepts a