Change SQLDataSource Connectionstring dinamically using parameters

[Pino]

Goodmorning i have a site developed in .NET 5 that renderize some .trdp report, i compile that report using a stored procedure in my database, actually i pass it my connectionstringstring using the file appsetting.json of my website, but i need to dinamically pass the connectionstring to my SQL DataSource item in my report (maybe using a report parameter?), how can i do that?

i leave you some screen for better explanation.

This is the SQLDataSoruce of my report

this is the appsetting.json file of my website

this is how i pass parameters from a webPage to the report

let me nknow if i was clear or if it possible do what i ask.

Best regards

[Todor]

Hi Pino,

I suggest using the approach described in the KB article Change Connection String dynamically through a report parameter. Note that it can be used to modify the connection string of data items' data sources and is not applicable for changing the Report Parameters' AvailableValues DataSource connection string.

If you need to modify also parameters' connection strings, I suggest the KB Action NavigateToReport does not work after updating the Connection String dynamically in a Custom Report Resolver.

Regards,
Todor
Progress Telerik