How to create Crystal Report with SQL on C#
• Simple MySQL Crystal 2003 - 31.95 KB • Simple MySQL Crystal 2005 - 38.2 KB Introduction This article is about creating Crystal Report s using Visual C#.NET and MySQL. We all know that MySQL is an open source DBMS and .NET Framework is free. We have used MySQL and Visual Studio .NET 2003 in developing some of our projects with the help of MySQL Connector .NET 1.05. In this article, I don't discuss how to use My SQL Connector .NET 1.05 in details. However, I got some difficulties while creating report s with Crystal Report , since Crystal Report currently doesn't support connecting directly to MySQL. When I was doing this kind of development, I also looked for samples, but I couldn't find one. That's why I wrote this article on The Code Project.
You need to install the MyODBC ODBC adaptor and just use the ODBC connector in Crystal and you can use all of the technology crystal offers.
Create a DataSet, the Key of Designing a Report As stated