How to make a crystal report in dotnet ?
Language: C# (dot net 2.0)
Database: SQL 2005 Express
Make a new file with extension (any name) *..udl In you solution Folder.( Creating a link file for report communication)
Double Click to configure. Choose SQL Native Client
Then next tab connection
Here Pc Name: BJIT-0667A6AC89
SQL 2005 Server instance: SQLEXPRESS
Database name: UniversityAutomation
Press ok to end up making link file.
Go to your development code
Take a form ( blank)
Take component from form tool box ( choose Crystal reports -> CrystalReportViewer) & drop to your form
Right click on report sowing form choose create report ( new)
Create new connection Select OLE DB (ADO)
Select SQL Native Client ( Higilight)
Click DATA LINK Filter
From (…) Show the path of created link file.
Serve : pc name\sql client name (Example: BJIT-0667A6AC89\SQLEXPRESS)
It will automatically get the database.
Choose Next & Finish
Next steps are configuring the report (May 7) . These depend on Requirements
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.