How do you get MySql Data into Active Reports?
Posted on 2009-05-06
I am learning about how to use Active Reports. It looks very straight forward but they have their own custom DataSource object that holds and requests the data for the report.
For example their sample shows to get the data from MS Jet ODBC 4.0 you would use -->
this.DataSource = new DataDynamics.ActiveReports.DataSources.OleDBDataSource("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files (x86)\\Data Dynamics\\ActiveReports for .NET 3.0\\Data\\NWIND.MDB;Persist Security Info=False", "SELECT Categories.*, Products.*\r\nFROM Categories INNER JOIN Products ON Categorie" +
"s.CategoryID = Products.CategoryID\r\nORDER BY Categories.CategoryName;", 30);
Then when the fetch data is fired the data is grabbed.
But My Database is MySql. I can get data from the MySql and put it into a
System.Data.DataTable or System.Data.DataSource objects but cannot figure out how to hook this object to the report data.
Help on this matter is greatly appreciated.