## C

#### calculated data field

A calculated data field is a field that holds a value that comes from a calculation rather than coming directly from a database. For example, if the database you are using includes a {file.SALES} field and a {file.COST} field but no Gross Profit field, you can still show gross profit on your report by using a calculated data field. To create a calculated data field, you create a formula that subtracts {file.COST} from {file.SALES}. The formula calculates a Gross Profit value for each row and prints that value wherever you place the formula field.

#### case-sensitive

Case-sensitive means that a program differentiates between uppercase and lowercase letters when evaluating a text string. Thus, a case-sensitive search for the word "house" will return only the value "house," but a non-case-sensitive search will return "house," "House," "HOUSE," and similar mixed-case strings. Seagate Crystal Reports operators (Equal, In string, etc.) are case-sensitive.

#### column

A column is the display of data from a single field or formula. Columns run up and down the page. Compare with row.

#### comments

Comments are blocks of descriptive text that accompany formulas. Seagate Crystal Reports ignores comments when it runs the formula.

#### concatenate

To concatenate is to join two or more text strings together to form a single contiguous string.

#### condition

In an If-Then-Else formula, the condition is the If part of the formula, the set of circumstances that must take place (be true) to trigger the Then (or consequence) part of the formula. In the formula If x<5 Then x Else 5, the expression x<5 is the condition.

#### conditional formatting

Conditional formatting is formatting that applies only if certain situations occur. For example, you can conditionally format numeric database fields to display in red when negative.

#### conditional formatting formula

A conditional formatting formula is an expression that applies specific attributes to objects or sections only if certain criteria are met.

#### conditional properties

Conditional properties are properties that are performed on an object only if a comparison statement returns a value of True.

#### confidence threshold

A percentage (C) used when the Seagate Document Import Tool converts a report. If fewer than C percent of the fields are located correctly, the conversion will fail.

#### consequence

In an If-Then-Else formula, the consequence is the Then part of the formula; the action that takes place if the If condition is met. In the formula If x<5 Then x Else 5, the expression Then x is the consequence.

#### constant

A constant is a value that is fixed and unchanging as opposed to a variable value, which can take on various values depending on the circumstances.

The value 5 is a constant; the value of the Quantity field (which may be 5 sometimes, but may be a different number at other times) is a variable value. For example, in the formula for converting pounds to ounces (Ounces = Pounds * 16), 16 is a constant while Ounces and Pounds are variables. In the formula (Today - January 1, 1900), January 1, 1900, is a constant, while Today is a variable that changes whenever the current date changes. In Seagate Crystal Reports, constants can be numbers, text strings, dates, dollar amounts, time, date/time, or the result of a formula that itself contains no variables (i.e., 14-9).

#### container document

A file that contains an embedded or linked OLE object.

#### conversion interface file

A conversion interface file (.cif extension) is the file in which the program saves the formatting and highlighting from the Document Import Tool. When you highlight something in the Document Import Tool and set properties for database fields, these settings are saved in the .cif file. This file can be used to quickly format the same report later, without highlighting.

#### cross-tab

A cross-tab is a report that summarizes and presents data in a compact row and column format that makes it easy to compare data and identify trends.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com