I want to make a report which displays dynamic parameters based on the list of the stored procedure I select like below (The below screenshot is just for understanding purposes). If I select the first stored procedure from the list then parameters are displayed according to that stored procedure. If I select the second stored procedure then the parameters list should be displayed according to that.
My Reports and Reports Parameters tables are given below. If a parameter needs a drop-down then the stored procedure for drop-down would be run and populate the drop-down with a list of values.
I have read the below article but it does not sever the purpose which I require.