How can I change data connections for multiple clients?

3 posts, 0 answers
  1. Frank
    Frank avatar
    9 posts
    Member since:
    Feb 2019

    Posted 12 Feb Link to this post

    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.
  2. Frank
    Frank avatar
    9 posts
    Member since:
    Feb 2019

    Posted 12 Feb Link to this post

    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.
  3. Todor
    Admin
    Todor avatar
    267 posts

    Posted 15 Feb Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top