Implementing Crystal Report using UDL

How to make a crystal report ? .

Language: C# (dot net 2.0)
Database: SQL 2005 Express

Useful links:
1. http://www.aspfree.com/c/a/.NET/Generating-a-Simple-Crystal-Report-using-VS-2005/

Simply follow the steps…..
1. Make a new file with extension (any name) *..udl In you solution Folder.( Creating a link file for report communication)
2. Double Click to configure. Choose SQL Native Client
-->


















3. Then next tab connection


Here Pc Name: BJIT-0667A6AC89
SQL 2005 Server instance: SQLEXPRESS

Database name: UniversityAutomation

4. Press ok to end up making link file.
5. Go to your development code
6. Take a form ( blank)
7. Take component from form tool box ( choose Crystal reports -> CrystalReportViewer) & drop to your form








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




















9.
























10. Create new connection Select OLE DB (ADO)



















11. Select SQL Native Client ( Higilight)
12. Click DATA LINK Filter
13. From (…) Show the path of created link file.
14. Click NEXT




















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

16. It will automatically get the database.

17. Choose Next & Finish




















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

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.

No comments:

Post a Comment