Telerik Forums / Reporting
This is a migrated thread and some comments may be shown as answers.

Report Datasource

1 Answer 75 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Donovan Kruger
Top achievements
Rank 1
Donovan Kruger asked on 04 Nov 2019, 05:55 AM

Hi,

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.

 

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 06 Nov 2019, 03:14 PM

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.

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
Tags
General Discussions
Asked by
Donovan Kruger
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or