Crystal Fields

Id

Internal ID of the field

Crystal Document Id

Foreign key to the Crystal Report document

Crystal Table Id

Foreign key to the table the field belongs to (CRYSTAL_TABLE.ID)

Name

Name of the field

Formula Form

The formula within the field if its a formula.

ex.:PercentOfSum ({Customer.Last_Years_Sales}, {Customer.Region}, {Customer.Country})

Type

Field data type

Possible values:

Kind

Kind of field

Value Range Kind

INTERNAL / NOT USED

Short Name

Short name of the field

Long Name

Long name of the field

Report Name

INTERNAL / NOT USED

Heading Text

Heading text defined for the field

Table Alias

Table alias

Field Class

Field class

Length

Length of the field

Description

Description of the field

Summary Operation

Indicates the summary operation if the field is in a summary location

Possible values may be:

Delegated

Sum

Average

Count

Minimum

DistinctCount

Maximum

Summarized Field

The field that is summarized

Is Groupname Field

Indicates whether the field is a Group

Is Recurring

Indicates if the field is recurring

Is Used Where Clause

Indicates if the field is represented in a where clause

Is Universe Object

Indicates if the field is sourced from a Universe object

Is Allow Null

Indicates if the field allows null values

Is Allow Multiple Value

Indicates if the field allows multiple values

Is Optional Prompt

Indicates if the field is an optional prompt

Is Used In Report

INTERNAL / NOT USED

Is Used In Calc Or Frmla

INTERNA / NOT USED