How can I change data connections for multiple clients?

[Frank]

Hello,

I have created a report in Report Designer (Stand Alone) and saved it on the Report Server.
The data is fetched from a database via ODBC drivers.

For this I have a connection string stored on the Report Server, which is used in the report as a data connection.

The report should be usable by different clients.
Each client has its own database (with the same structure).

For each client, a data connection is then stored on the server.

The report should be displayed in the HTML5 report viewer, which should be integrated into our web application.

Is there any way to specify the data connection to be used when calling the report via the API?
e.g .:
Client A calls the report. -> The data connection X is used.
Client B calls the report. -> The data connection Y is used.
Etc.

[Frank]

I found to my problem the following post which is very similar:
https://www.telerik.com/forums/change-connection-string-based-on-user

Unfortunately, I can not apply the suggested solution, since I also query report parameters from the data connection.

If I understand the solution correctly, must create a conditional binding everywhere in the report where a data connection is used.
Is that still workable with many clients?
I mean a nesting of 50, 100 or more IIf(s)'s?
And that maybe several times in a report.

[Todor]

Hello Frank,

Currently, the Report Server does not support multitenancy. We have a feature request for such functionality - you may vote for it in our Feedback portal.
The approach from the Change connection string based on user thread should work with many users but is not applicable for Report Parameters.

Regards,
Todor
Progress Telerik