A DATASET is a query or stored procedure. A [DATASET] is the prerequisite for [REPORTS] and [FILTERS]
We will be adding four new datasets
ADD NEW DATASET
- Choose [ADD NEW DATASET]
- Choose [STORED PROCEDURE] from [STATSDB] connection
- There is another way to add multiple datasets.
Go to EDIT -> [DB CONNECTION]
Choose STATSDB
Click on Add SP’s tab.
Select DS_spGetSeasons, DS_spGetQB_AllStats, DS_spGetQuarterbacks, spGetQBTargetBreakDown then click [Add Selected Stored Procedures to Datasets]