Kefy
Malicious Activity Tracker
LEVEL 1
200 XP
This tutorial will teach you on how to create reports in Visual Basic .NET 2008 using Crystal Reports. This is a step by step guide on how I create the report on "Weekly Sales Report using Crystal Reports".
This guide is not intended for advance user. So please don't react if you find a basic explanation on this tutorial.
This assumes that you have already attached the database that is included in the zip file of "Weekly Sales Report ".
1. Open the Weekly Sales Report using Crystal Reports project and follow the following procedure.
Click on Project menu >> Add New Item.
2. Add New Item dialog box will then appear on your screen.
Type the filename
3. Crystal Reports Gallery
Select "Using the Report Wizard" and Standard on "Choose and Expert" then click OK.
4. Standard Report Creation Wizard and OLE DB (ADO)
Select Microsoft OLE DB Provider for SQL Server.
5. OLE DB (ADO) - Connection Information
Type the Instance name of the SQL Server and the database name.
6. OLE DB (ADO) - Advanced Information
7. Select Data or Table/View name
8. Select Fields
Select Next and configure the necessary option that you like on the next screen until you reach the screen below.
9. Report Style
10.Weekly Sales Report design mode
In the design mode, configure your report whatever design that you like.
That's it. I hope you learn something on this simple tutorial.
This guide is not intended for advance user. So please don't react if you find a basic explanation on this tutorial.
This assumes that you have already attached the database that is included in the zip file of "Weekly Sales Report ".
1. Open the Weekly Sales Report using Crystal Reports project and follow the following procedure.
Click on Project menu >> Add New Item.
2. Add New Item dialog box will then appear on your screen.
Type the filename
3. Crystal Reports Gallery
Select "Using the Report Wizard" and Standard on "Choose and Expert" then click OK.
4. Standard Report Creation Wizard and OLE DB (ADO)
Select Microsoft OLE DB Provider for SQL Server.
5. OLE DB (ADO) - Connection Information
Type the Instance name of the SQL Server and the database name.
6. OLE DB (ADO) - Advanced Information
7. Select Data or Table/View name
8. Select Fields
Select Next and configure the necessary option that you like on the next screen until you reach the screen below.
9. Report Style
10.Weekly Sales Report design mode
In the design mode, configure your report whatever design that you like.
That's it. I hope you learn something on this simple tutorial.