How to make a crystal report in dotnet ?

Language: C# (dot net 2.0)

Database: SQL 2005 Express

Step 1:

Make a new file with extension (any name) *..udl In you solution Folder.( Creating a link file for report communication)

Step 2:

Double Click to configure. Choose SQL Native Client

Step 3:

Then next tab connection

Here Pc Name: BJIT-0667A6AC89

SQL 2005 Server instance: SQLEXPRESS

Database name: UniversityAutomation

Step 4:

Press ok to end up making link file.

Step 5.

Go to your development code

Step 6.

Take a form ( blank)

Step 7.

Take component from form tool box ( choose Crystal reports -> CrystalReportViewer) & drop to your form

Step 8.

Right click on report sowing form choose create report ( new)

Step 9.

Step 10.

Create new connection Select OLE DB (ADO)

Step 11.

Select SQL Native Client ( Higilight)

Step 12.

Click DATA LINK Filter

Step 13.

From (…) Show the path of created link file.

Step 14.

Click NEXT

Step 15.

Serve : pc name\sql client name (Example: BJIT-0667A6AC89\SQLEXPRESS)

Step 16.

It will automatically get the database.

Step 17.

Choose Next & Finish

Step 18.

Next steps are configuring the report (May 7) . These depend on Requirements

Step 19.

Editing from there you can easily find the components to show.

Final: How to show a report

Now you have to just LOAD your form from any (May main) form to show as you configure.