Report Datasource

2 posts, 0 answers
  1. Donovan Kruger
    Donovan Kruger avatar
    7 posts
    Member since:
    May 2010

    Posted 03 Nov 2019 Link to this post


    I need to be able to change the datasource for the reporting at runtime.

    Currently I am using MySQL not SQL so the method shown does not work

    Directcast(report.datasource, Telerik.Reporting.SqlDataSource).connectionstring = "ConnectionString"

    All my reports work fine with the MySQL connectors, just need to change the datasource as i'm working with multiple databases.


  2. Todor
    Todor avatar
    451 posts

    Posted 06 Nov 2019 Link to this post

    Hello Donovan,

    I recommend the approach from the Change Connection String dynamically through a report parameter KB article.

    Note that the SqlDataSource component supports both MySQL and MSSQL databases through the specified ADO.NET provider. Ther component does not distinguish between the databases, it just passes the meta-information it contains to the provider and the latter connects to the database and fetches the data.

    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