Creating a Report in a Student Registration Using Crystal Reports part 1

Submitted by: 
Visitors have accessed this post 2135 times.

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.

First

Click the add button for creating a new data source.

second

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

third

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

fourth

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”.

fifth

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

last

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.


Comments

great master piece. its very resourceful to new learners in crystal reports

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.