crystal report get data from existing mysql xml dataset

[ridhwaans]

Please move or delete this thread if this is not the correct forum

I am using MySQL Connector/NET 5.2.7 for visual studio 2005, and I've got a myDataSet.xsd in my visual studio project which I got from my data source connection, a MySQL Database (MySQL Data Provider)

The problem is when I use the existing ADO.NET dataset (myDataSet.xsd) as a data source through the new report wizard in crystal reports in vs 2005, the tables and field names are available in the newly created report, but the data is blank (i.e. no data to browse)

But, if I make a new data source for the crystal report, using the ODBC connection string...

Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;

... it works (the database fields are not blank and I can browse them, but the text type and memo type fields are unavailable)

But, I wish to use the same dataset (myDataSet.xsd) acquired from the MySQL Database (MySQL Data Provider) for the crystal report and not the ODBC

Please advise

Thanks