Left Quote    Maybe this world is another planet's Hell.
- Aldous Huxley    
Right Quote
[login] | [Register]

Using Crystal Reports in VB

by: bs0d
Page: 2 of 3
(View All)


Click on 3: SORT tab in the Create Report Expert dialog box. Now select the field you want to have the records sorted by (the selected field will be used to sort all of the records in order by the field selected when the report is produced). You can also set the order to have the table sort in descending order by clicking on the array. Ascending order is the default.


Your report has the ability to calculate totals for numeric fields. You can add additional fields by clicking the field and then click the add button. And to delete fields, click on the remove button.

Click on 4: TOTAL tab in the Create Report Expert dialog box. Select field by clicking on it to highlight it. This will create subtotals for that field, and will create section breaks in your report for each record and display a total for the selected field. Now click on the Add button, and this will add the field on the right hand side.

Note: if the check box in the lower right-hand corner is checked, you will get grand totals for your report.


If you would like to adjust the font and font size of your report, first select the field you want to change by clicking on it. And if you want to change more than one, hold the CONTROL key and select the fields you want to change. Now click the arrow to the right of the font window, a drop down menu will appear. Select the font you want by clicking on it to highlight it. And click the arrow to the right of the font size, a drop down menu will appear- and select the font size you want by highlighting it.


This section is used often if you have large files and want conditions set on the key field or other fields in the file where only certain records will be selected for printing. Setting some keys in this section will speed up processing of records for your report since several records will be skipped.

Click on 5: SELECT tab in the Create Report Expert dialog box. Next, click on SPEED TIP button. This will discuss how records will be selected and how reports will be sped up, if not all records will be used for processing. Now click on OK when finnished reading. Click ADD to add the highlighted field to the Select Fields list box.

The highlight button appears next to the key field in the Report Fields list box. This is because the table contains an index for this field. The key field is often used for filtering out records.

At the bottom of the window, there are two other list boxes, one containing the word "is" and the other containing the words "any value". These two list boxes are used to set conditions to filter out records when producing your report.

1  |  2  |  3  |  
Next »

No Comments for this page.

You Must be logged in or a member to comment.

Tutorial Stats

Tutorial Stats

0 Total Comments
0 Rating of 5 ( Votes)


Tutorial Options

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



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

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