ITSourceCode.com

Free Source Code and Tutorials

Custom Search

15-Generating Reports (part 1)

In my previous tutorial, I created  14-Removing User/s. 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.

crystalreportemp1_form1

Click the add button for creating a new data source.

After that, scroll down and select a driver of MySQL ODBC 5.1 Driver because you are using a MySQL Database. After that, hit Finish.

crystalreportemp1_form2

Now, the configuration of your MySQL Connector /ODBC data source will show.

crystalreportemp1_form3

Set your data source named “Emp_info”,leave the description blank. The server is the “localhost “and the user is “root”. leave the password blank, then select the database named “dbinformation”. Test your connection and hit “ok”.

crystalreportemp1_form4

Now, the data source name will show in the list of ODBC Data Source. After that, hit “ok”.

crystalreportemp1_form5

Facebook Comments
(Visited 10 times, 1 visits today)
Share this

Check Your Domain Ranking

Leave a Reply

Your email address will not be published. Required fields are marked *

ITSourceCode.com © 2016 Frontier Theme

Subscribe For Latest Updates

Signup for our newsletter and get notified when we publish new articles for free!




%d bloggers like this: