Creating Reports in Crsytal Reports Using MySQL

[callraheel]

Connecting to MySQL from Crystal Reports

Hello
I have been searching on this topic for long on MySQL Forums but im unable to find a suitable answer for my needs..
Well my question is to describe in detail how to connect MySQL with Crystal Reports.
I have tried it many times with ODBC but it always fails to connect so anyone can help out but please give reference to some detailed help or help deeply.

And one more question is there any other way to connect except ODBC to MySQL through Crystal Reports.

Now the details of softwares i'm using :
MySQL Version : v4.1.12
Crystal Reports 10
VB.NET 2003 with Framework 1.1
MySQL Connector .NET 1.0.4

I hope it will help too

waiting for your reply

Regards
Raheel

 

[kulrom]

OK this the easiest way i know. Go under Administrative Tools in control panel and double click Data Sources (ODBC). Then create new ODBC conn (i assume this is what you've missed there). Note that this could be done programatically as well. Back to the IDE and from Doc Exp. find conn that was created and that's it ... now you can draw the table/s what you need for your report/s.
Correct me if i'm wrong ... i'll be glad to help you

Cheers

 

[callraheel]

Well i think you are right but my computer configuration might be wrong because i cant find any MySQL Option in ODBC Connection Sources Section.
Could you please tell me why its happening.

 

[kulrom]

Ask Administrator ... if you have permision to create new ODBC than i can't see why you wouldn't be able to see the same through Source section from VS.NET


Cheers

 

[callraheel]

Well im administrator myself but no avail

 

[kulrom]

If you created ODBC conn properly and you are still unable to see it through document explorer i'm afraid without further info however, I can't be of help there. Maybe you are not creating it correctly btw. Would you mind to explain how you do that (creating new ODBC conn)

Regards

 

[Darth_Krieg]

You should also download the odbc driver for mysql.
it is available at mysql.com

without the driver, you cannot create an odbc data source for your program.

 

[callraheel]

Well long time , isnt it?
i have tried that before but it takes long time
Isnt there any confirguration in Crsytal Reports itself to access MySQL Tables.???