SQLTeam.com | Weblogs | Forums

Dynamic Stored Procedure in SSRS Report Builder

Hi Experts !
I need your support and help . I am trying add in a dataset dynamic stored procedure link below,but i am unable to add fields in the dataset. How the dynamic SP work in SSRS report builder? How can i run the below link SP in report builder by passing report builder parameters ?


Capture2

It will be much easier to do the transposition in SSRS via a Matrix report. If your stored procedure is dynamically changing the columns outputted, I don't believe SSRS can reconfigure it in a regular tabular report (at least not without a lot of programming).

You can create another stored procedure that outputs the same data but doesn't create any dynamic columns and use that as your data source for SSRS.

Than you ... sir