Dynamic Stored Procedure in SSRS Report Builder

[Sameer]

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 ?

Adding vertical sum of rows(Sum in last availble column) for Transposed data

Hi Experts , Happy New Year! The below script works fine dynamically transpose the data , I have a requirement to add two columns and get sum of Data1 columns in the last available column Same as for Data2 the result are in screenshot. May be from group by rollup i dont know how to do it. Secondly i am trying to run a stored procedure by providing the @Startdate ( 10-Oct-2021) and @Endate (11-Oc-2021) , but the script retrieve data all available rows in the database not between parameters pa…

[robert_volk]

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.

[Sameer]

Than you ... sir