How to Create Reports using Crystal Reports

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.