Crystal Report Fields

Field Explorer: The Field Explorer, which is part of the embedded Crystal Reports Designer, shows a tree view of Database Fields and Special Fields that are available for you to add to your report. The Field Explorer also shows the Formula, Parameter, Group Name, Running Total, SQL Expression, and Unbound Fields that you have defined for use in your report.

There are various fields are available in field explorer of the Crystal Report are as follows:

Database Fields: A database is designed to store related data. Each database record is made up of one or more database fields. Each database field can hold one piece of data.

Formula Fields: A formula is an equation designed to produce specific data for your report. You can use formulas to perform many calculations, including the calculation of numeric values and the comparison of multiple values etc.

Parameter Fields: A parameter field will prompt the user to enter a value when used. You can use parameter fields for report titles, record selection, sorting, and a variety of other uses. Using parameter fields enables you to create a single report that you can modify quickly to fit a variety of needs.

Group Name Fields: A group is a set of records that are related to each other in some way. For example, you might group together all of your customers in the same Zone. A Group Name field is created when you insert a group into your report. The Group Name Fields list displays the Group Name fields currently in your report.

Running Total Fields: A running total totals all records (in the report, in the group, and so forth) up to and including the current record. For example, if your first three records have values of 2, 4, and 6, the running total for each of the three records would be 2, 6, and 12, respectively. You can use running totals to create customized summaries and totals.

Special Fields: It provides general information, such as Page Numbers, Print Date, and Report Comments, are located in the Special Fields list.
Unbound Fields: Fields with no specific format. It may be boolean, currency, date, datetime, number, string and time.

Report Sections:

Page Header: Appears after the Report Header on the first page and on all the

remaining pages it appears at the top of the page.

Page Footer: Appears at the bottom of each page.

DetailsThe row that displays the record information. There is usually one detail

row for every record in the table.

Report HeaderAppears at the top of the first page of the report.

Report FooterAppears as the bottom of the page for the last page in the report.

Last updated:3/4/2020 3:48:44 AM
Chris Anderson

Chris Anderson

hi I am software developer at mindstick software pvt. ltd.


Kenny Tangnde
Kenny Tangnde

This is a great article,It is very helpful,thanks for sharing  with us.thanks very much.

Leave Comment