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

data-link-properties

Step 3:

Then next tab connection

data-link-properties-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

crystal-reports

Step 8.

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

crystal-reports-properties

Step 9.

crystal-reports-gallery

Step 10.

Create new connection Select OLE DB (ADO)

crystal-reports-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

crystal-reports-ado-wizard

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

crystal-reports-oledb

Step 18.

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

field-explorer

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.