In my previous tutorial I created a search and delete data in the Student’s Registration Form. Today, I will teach you how to generate a report using a Crystal Report in the Visual Studio 2008 and MySQL Database.
First, you have to set up your data source and the drivers in ODBC data source.
Now, open your ODBC data source that can be found in Administrative Tools.
Click the add button for creating a new data source.
Then, scroll down and select a driver of MySQL ODBC 5.1 Driver because you are using a MySQL Database. After that, hit Finish.
Now, the configuration of your MySQL Connector /ODBC data source will show.
Set your data source named “Students”,leave the description blank. The server is the “localhost “and the user is “root”. leave the password blank, then select the database of the student registration named “studentdb”. Test your connection and hit “ok”.
Now, the data source name will show in the list of ODBC Data Source. After that, hit “ok”.
In this, you can access the database of a student when you are creating a report in the Crystal Reports.
You will know what I’m taking about on my next tutorial.
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.
Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.