2
Answers

How can i use multiple data sets in ssrs proc

Ami Yeta

Ami Yeta

4y
988
1
Create StoredProcedure sp_MultipleDataSets as begin SELECT EMPID, ENAME, JOB, SAL, DEPTID FROM EMP -- first result set SELECT DEPTID, DNAME, LOC FROM DEPT --second result set end In BIDS, while creating a new report i configured the stored procedure for dataset. It creates the dataset ONLY with the columns returned from the first result set. It does not identify the second result set. How can I create datasets for both the result sets from a stored procedure like above.
Answers (2)