Using Crystal Reports in VB by: bs0d

Page: 1 of 3 (View All)

Introduction

The crystal report writer is an add-in program that comes with visual basic. You use the Crystal Report Writer to create custom reports, lists, labels and form letters using datga from an existing database. However, most of the time- the Crystal Report Writer is used to create reports.

• Microsoft Access
• dBase
• Paradox
• FoxPro
• Clipper
• Btrieve
• SQL Server (via ODBC)

To access the crystal report writer (in visual basic 6.0) click on Add-Ins --> Report Designer. This will take you into Crystal Reports.

CREATING A REPORT:

1. click on File --> New (a Create New dialog will appear).
2. click on the Standard icon (the Create Report Expert dialog box appears).
3. click on Datafile (the Choose Database File dialog box appears).

1. Click on the file you want to open
2. Click on Add
3. Click on Done (the Choose Database File dialog box disappears).

SELECTING FIELDS:

Click on 2: FIELD in the create report expert dialog box. This is where you select the fields that you want to appear in your report. You can select the fields individually by clicking on them and then clicking on ADD, or you can click on ALL, which will select all fields. When a field has been selected, it will be displayed in the REPORT FIELDS window.

You can change column headings as well by clicking and highlighting a field in the Report Fields window, and moving down and typing a new heading for that field. Default headings will appear for each field.