multiple result sets from stored procedure bind to tabs in ssrs report

Question

User1704325921 posted

Hi,

I have requirement that would be

stored procedure  having 

below queries like 

select * from t1

select * from t2

select * from t3

above result sets each having almost 100,000  records.

I have to display 3 restult sets in 3 pages.

when exporting to excel sheet should be display with 3 tabs.

what is the best way to handle (without impacting performance.).

First page or table should have all 100000 records.

second page should have all 100000 records.

Third page should have all 100000 records.

Please suggest me best way to implement it.

Answer 1

User61956409 posted

Hi durgaprasad.kinthada,

You can try to write your stored procedure with accepting parameters that indicates which table should be queried and the index of page that should display returned records.

Besides, you can post your question in SQL Server Reporting Services support forum.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlreportingservices

With Regards,

Fei Han