Creating a Report in Student Registration Using Crystal Reports part 2.

Submitted by: 
Visitors have accessed this post 2517 times.

In my previous tutorial which is Creating a Report in a Student Registration Using Crystal Reports part 1, I set up the ODBC data source for the Student Registration database. Now, I will create a report of a student in the Crystal Report using Visual Studio 2008.

First, open your Visual Studio 2008, open the file of the Student Registration Form. Then, add a new item which is Crystal Reports, name it “studentinfo”, and hit “add”.

Add Item

After that, the Crystal Reports Gallery will show. Select a radio button of “Using the Report Ward”, select a “standard” for choosing an expert and hit “ok”.

Galery

And then, the Standard Report Wizard will show. Select “Create New Connection” , after that, select the folder of ODBC (RDO). The Data Source selection will show and select the name of your data source (“Students”) that you created in the previous tutorial. Then hit “next”.

Select Database

The connection information will show. Write the word “root” to the user id and leave the password blank. Then hit “Finish”.

User Id

The database will be added to the folder of ODBC (RDO). Select the table of the database and hit the “greater than sign(>)”. After that, hit “next”.

First Next

Then, choose the fields that you want to display in the reports.
Hit the “next”.

Secon Next

After that, choose what you want to group on the reports and hit “next”.

Third Next

I didn’t put a summarize field because it was an information about the student. You can use the summarize field when it deals with Inventory. Hit “next” again.

Fourth Next

Hit the “next”. I Leave subset fields blank because I don’t have to filter any records and I will display all of it.

Fifth Next

Choose a standard formatting of the reports and hit “Finish”.

Last Next

This will be the output after you hit the “Finish”.

Output

You can now preview it and you can change the header if you like.

I will show you how to set it up into a Windows Form on my next tutorial.


Comments

sir can you teach how to do it with vb.net and mysql

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.