Search
Left Quote    I find that the harder I work, the more luck I seem to have.
- Thomas Jefferson    
Right Quote
 
[login] | [Register]
 

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.


The crystal report writer can be used with the following programs:

  • 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:


To create a report, open crystal report writer...

  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).

To the left you will see a list of files. To the right is the path showing the folder tree, indicating where the file will be stored.

  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.



1  |  2  |  3  |  
Next »


No Comments for this page.

You Must be logged in or a member to comment.


Tutorial Stats

Tutorial Stats

42,151 Views
0 Total Comments
0 Rating of 5 ( Votes)

Options

Tutorial Options

· Login to Rate This Article
· Login to Post a Comment
· Read more by this author
Digg This Article! Del.icio.us: Bookmark This Article Reddit: Bookmark This Article BlinkList: Blink This Article! YahooMyWeb BlogMarks: Add This Mark! Furl: Save This Article Spurl: Mark This Article

Articles

Related    

· Getting Started with VB 6.0
· Coding a Webserver
Your Article Here



"AllSyntax.com" Copyright © 2002-2017; All rights lefted, all lefts righted.
Privacy Policy  |  Internet Rank