Your first VB.NET Crystal Reports - A step by step guide

By: Issac Viewed: 154395 times  Printer Friendly Format    


Crystal Report is an application which can generate various reports from different data sources, we can create reports, print and preview those report using it, It is compatible with almost a developing platforms and databases,  In this article you can find useful resources for generating reports from VB.NET with Crystal Report.

We can now see how to create a sample Database and Tables and data. First we have to create a database. Give the database name as "crystaldb" 

Create a DataBase "crystaldb" 

In the crystaldb database, let us create three tables OrderMaster, OrderDetails, Product.

OrderMaster 
1. OrderMaster_id
2. OrderMaster_date
3. OrderMaster_customer
4. OrderMaster_createduser 

OrderDetails 
1. OrderDetails_id
2. OrderDetails_masterid
3. OrderDetails_productid
4. OrderDetails_qty 

Product 
1. Product_id
2. Product_name
3. Product_price

Now that you have a database you can start your first VB.NET Crystal Reports.

All Crystal Reports programming samples in these tutorials are based upon the following database (crystaldb, the one we created through the previous article).

Open Visual Studio .NET and select a new Visual Basic .NET Project.

simple_vb.net_crystal_report_1.GIF

Create a new Crystal Report for Product table from the above database crystalDB. The Product Table has three fields (Product_id, Product_name, and Product_price).

From the main menu in Visual Studio select PROJECT-->Add New Item. Then Add New Item dialogue will appear and select Crystal Reports from the dialogue box.

simple_vb.net_crystal_report_3.GIF

Accept the default settings and click OK.

Next step is to select the appropriate connection to your database. Here we are going to select OLEDB connection for SQL Server

Select OLE DB ( ADO ) from Create New Connection.

simple_vb.net_crystal_report_4.GIF

Select Microsoft OLE DB Provider for SQL Server.

simple_vb.net_crystal_report_5.GIF

Next screen is the SQL Server authentication screen. Select your Sql Server name, enter userid, password and select your Database Name. Click next, Then the screen shows OLE DB Property values, leave it as it is, and click finish.

Then you will get your Server name under OLEDB Connection from there select database name (Crystaldb) and click the tables , then you can see all your tables from your database.

From the tables list select Product table to the right side list.

simple_vb.net_crystal_report_6.GIF

Click Next Button

Select all fields from Product table to the right side list.

 

simple_vb.net_crystal_report_7.GIF

Click Finish Button. Then you can see the Crystal Reports designer window. You can arrange the design according your requirements. Your screen looks like the following picture.

simple_vb.net_crystal_report_8.GIF

Now the designing part is over and the next step is to call the created Crystal Reports in VB.NET through Crystal Reports Viewer control.

Select the default form (Form1.vb) you created in VB.NET and drag a button and CrystalReportViewer control to your form.

 

simple_vb.net_crystal_report_9.GIF

Select Form's source code view and put the code on top

Imports CrystalDecisions.CrystalReports.Engine

Put the following source code in the button click event  

Imports CrystalDecisions.CrystalReports.Engine
Public Class Form1
    Private Sub Button1_Click(ByVal sender As System.Object, 
ByVal e As System.EventArgs) Handles Button1.Click
        Dim cryRpt As New ReportDocument
        cryRpt.Load("PUT CRYSTAL REPORT PATH HERE\CrystalReport1.rpt")
        CrystalReportViewer1.ReportSource = cryRpt
        CrystalReportViewer1.Refresh()
    End Sub
End Class

NOTES:

cryRpt.Load ("PUT CRYSTAL REPORT PATH HERE\CrystalReport1.rpt")

The Crystal Reports is in your project location, there you can see CrystalReport1.rpt. So give the full path name of report here.

After you run the source code you will get the report like this.

simple_vb.net_crystal_report_10.GIF



Hope this article helps you to create your first Crystal Reports.




Most Viewed Articles (in VB.net )

Latest Articles (in VB.net)

Comment on this tutorial

Subscribe to Tutorials

Related Tutorials

Archived Comments

1. Hi ,

Is there any way to export con

View Tutorial          By: Nithya Duraiswamy at 2009-03-03 21:32:05

2. Hi Nithya,
yes you can do that see the tut

View Tutorial          By: Ramlak at 2009-03-04 01:20:01

3. Hey is there any way to export datagrid to crystal
View Tutorial          By: Anu at 2009-05-08 13:11:48

4. can i have sample of java programming that has dat
View Tutorial          By: piolo at 2009-05-31 18:53:25

5. the above is perfect, but when i hit the export bu
View Tutorial          By: CH at 2009-06-02 03:01:34

6. Hi,
i tried this way.that works perfectly.

View Tutorial          By: indu at 2009-06-08 03:13:51

7. How can I send parameter to crystal report?
View Tutorial          By: Mark at 2009-10-14 03:41:36

8. hi! this coding is very helpful for me thanks .
View Tutorial          By: bhuvaneshwari at 2009-10-18 23:52:58

9. hi,
my problem is.......
i use vb.ne

View Tutorial          By: Anirban at 2009-10-25 10:15:13

10. hi,
my problem is.......
i use vb.ne

View Tutorial          By: Anirban at 2009-10-25 10:25:48

11. hay is there any way to perform operation or calcu
View Tutorial          By: neha at 2009-11-20 08:29:45

12. hay is there any way to perform operation or calcu
View Tutorial          By: neha at 2009-11-20 08:30:10

13. hay is there any way to perform operation or calcu
View Tutorial          By: neha at 2009-11-20 08:30:48

14. hello,
i have to connect the crystal report

View Tutorial          By: shanmugaraj at 2010-03-03 04:08:30

15. hello,
how to use database access in crysta

View Tutorial          By: sheng at 2010-04-25 04:08:57

16. very good tutorial..
View Tutorial          By: shobhit at 2010-05-04 12:17:41

17. hi this is very helpful........thank you very much
View Tutorial          By: sumalatha at 2010-06-07 01:53:33

18. hi this is very helpful........thank you very much
View Tutorial          By: sumalatha at 2010-06-07 02:16:37

19. My crystal report keeps asking for a login passwor
View Tutorial          By: Larry at 2010-07-30 11:58:38

20. hey dude
im using vb.net 2008 and sql serv

View Tutorial          By: Haseeb ur Rehman at 2010-11-12 02:08:48

21. Hi,
my problem is that when i will put my p

View Tutorial          By: Twahir at 2011-03-21 05:24:16

22. Hi,
My problem is that how to connect the r

View Tutorial          By: Twahie at 2011-03-21 05:31:06

23. Hi,

As you shown here that we have

View Tutorial          By: Keyur at 2011-04-05 03:30:12

24. sir,
my project is in asp.net so is ther

View Tutorial          By: mohsin at 2011-04-14 06:25:59

25. can you clearly reveal how to create crystal repor
View Tutorial          By: halim at 2011-07-02 00:28:48

26. Hi,
My problem is with daybook. In

View Tutorial          By: Priyesh at 2011-07-06 06:34:33

27. Hi sir !

I have two Crystal Report

View Tutorial          By: Anderson Abad at 2011-07-20 03:34:51

28. I am using VS2010 & SAP for crystal report. I
View Tutorial          By: Abdullah Al Mamun at 2011-08-11 23:20:37

29. your site is ridiculous...
the domain name

View Tutorial          By: ambot at 2011-11-24 08:04:54

30. Microsoft VB.net 2008 not showing Crystal Report V
View Tutorial          By: Ali at 2011-11-30 03:21:00

31. It's very use full to me ....
Thans a lot..

View Tutorial          By: Raxit at 2011-12-30 03:57:03

32. dear i have different files of ms access 2010 like
View Tutorial          By: neeo at 2012-01-16 07:02:20

33. hey, what the hell are you doing.. this kind of pl
View Tutorial          By: Ameen at 2012-02-02 08:08:42

34. Hey,
The above tutorial is for SQL server,<

View Tutorial          By: Anil at 2012-02-07 15:58:06

35. Hi,
i am using crystal report 9. Once i ins

View Tutorial          By: jeff at 2012-02-12 08:14:15

36. hey i want to retrieve data from database table an
View Tutorial          By: Mohammed Mohiuddin at 2012-02-25 09:11:11

37. hii
my crys rpt is nt generating bill, it i

View Tutorial          By: Afan Khan at 2012-04-05 16:48:40

38. hi plz help
how do we change project develo

View Tutorial          By: pratik jogwar at 2012-06-07 19:58:47

39. ,Hi, (VS2008, VB.Net
I used the above code,

View Tutorial          By: Pat at 2012-06-27 17:30:37

40. Fantastic Post, can u pls tell me how can i pass q
View Tutorial          By: Kunal at 2012-08-07 07:02:41

41. how to set the report for particularn form feilds
View Tutorial          By: mathivanan at 2012-09-21 00:05:07

42. is there any way to generate report without seagat
View Tutorial          By: Roshni at 2012-10-01 09:32:41

43. sap crystal active-x design
failed to open

View Tutorial          By: Mubarak at 2012-11-11 17:16:54

44. i want to know the step by step process of vb.net
View Tutorial          By: moumita das at 2012-12-01 12:28:35

45. The tutorial is very usefull, i am happy now
View Tutorial          By: Haneefa at 2013-03-30 06:31:47

46. Your Crystal report viewer showing all the records
View Tutorial          By: Neel at 2013-06-09 15:02:15

47. Hi,
how can make a report to display one re

View Tutorial          By: david at 2013-08-30 16:09:23

48. Very good. but why i can search data then report v
View Tutorial          By: ARMAN AHMED at 2015-04-27 13:18:04

49. My children were needing Leave of abscence portlan
View Tutorial          By: Johnny Krauss at 2016-09-12 07:51:10

50. KrolKax
View Tutorial          By: KrolKax at 2017-04-28 06:11:45

51. Billyweimb
View Tutorial          By: Billyweimb at 2017-07-21 15:05:44

52. I see you don't monetize your page, don't waste yo
View Tutorial          By: 86Adelaide at 2017-08-17 03:02:51