Database and Data Type Functions

Used for determining the type of information contained in a cell. Helpful for error and sanity checks.

DataRowCount:

Description

Returns the number of rows retrieved from the data source when executing the report.

Example

Suppose report is run to retrieve basic information on 10 employees

Ex. DataRowCount() should return 10.

IsEven:

Description

Checks if a value is an even number.

Example

Ex. IsEven([A1]) – returns TRUE if the cell [A1] contains an even number, FALSE otherwise.

IsLogical:

Description

Checks if a value is TRUE or FALSE.

Example

Ex. IsLogical([A1]) – returns TRUE if the cell [A1] contains TRUE/FALSE, FALSE otherwise.

IsNonText:

Description

Checks if a value is not text.

Remark

Non Text values include dates, numbers, images and blank cells.

Example

Ex. IsNonText([A1]) – returns TRUE if the cell [A1] contains non text, FALSE otherwise.

IsNoDataQualified:

Description

Returns True if no data qualified for the report execution. Otherwise it returns false.

Example

Suppose report is run to retrieve basic information on 10 employees

Ex. IsNoDataQualified() returns false.

IsNumber:

Description

Checks if a value is a number.

Remark

Does not convert text to numbers. Ex IsNumber(“19”) returns FALSE.

Example

Ex. IsNumber([A1]) – returns TRUE if the cell [A1] contains a number, FALSE otherwise.

IsOdd:

Description

Checks if a value is odd.

Example

Ex. IsOdd([A1]) – returns TRUE if the cell [A1] contains an odd number, FALSE otherwise.

IsText:

Description

Checks if a value is text.

Example

Ex. IsText([A1]) – returns TRUE if the cell [A1] contains text, FALSE otherwise.

Null:

Description

Returns a null value (Nothing in VB).

Type:

Description

Returns the type of value.

Remark

Returns 1 if the value is a number, 2 if it is text.

Example

Ex. Type(“John Smith”) – returns 2.