Ami Yeta

Ami Yeta

  • 2.1k
  • 3
  • 231

How can i use multiple data sets in ssrs proc

Nov 21 2020 9:43 PM
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)