Dynamically load parameters from Reporting Services from .net application

Question

Hi Team,
Good Day.

I am in the process of building an application which would act as a wrapper around SSRS.
We have around 100+ reports with varied parameters.
I would like to create an application in .NET MVC which would dynamically load the parameters based upon the report selected, I am trying to follow the idea provided in the below link
https://odetocode.com/articles/123.aspx

I need an idea as how to dynamically pass the parameters dynamically (since the parameters gets varied for different reports) instead of hard coding for each and every report.

For example for Report1, the number of params is 2 then on selecting that report I need to get the 2 parameters name, that could be obtained from "GetReportParameters" method. but loading data for the second parameter depends on the first value, since first value is also dynamically loaded how to load parameters dynamically and send to web service to get the values of second one.
And since every thing is dynamic suppose Report3 has parameters then values of those parameters should be loaded based on previous values.
How could this be done, your ideas are welcome.

Answer 1

@raghul varma

The only thing that could possibly work is dynamic Json similar to what is being talked about in the link by creating the dynamic Json, passing it as a string parm to the method that is going to build the parms for SSRS and execute the repost. from the passed Json by parsing the Json to build the parms.

https://weblog.west-wind.com/posts/2012/aug/30/using-jsonnet-for-dynamic-json-parsing

I don't see why you can't do something.