Used for determining the type of information contained in a cell. Helpful for error and sanity checks. Click on a function name below to continue:
DataRowCount
Description | Returns the number of rows retrieved from the data source when executing the report. |
Remark | --- |
Example | Suppose report is run to retrieve basic information on 10 employees E.g. DataRowCount() should return 10. |
DbNull
Description | Returns DBNULL. |
Remark | --- |
Example | --- |
IsEven
Description | Checks if a value is an even number. |
Remark | --- |
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. |
Remark | --- |
Example | Ex. IsLogical([A1]) – returns TRUE if the cell [A1] contains TRUE/FALSE, FALSE otherwise. |
IsNoDataQualified
Description | Returns True if no data qualified for the report execution. Otherwise it returns false. |
Remark | --- |
Example | Suppose report is run to retrieve basic information on 10 employees E.g. IsNoDataQualified() returns false. |
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. |
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. |
Remark | --- |
Example | Ex. IsOdd([A1]) – returns TRUE if the cell [A1] contains an odd number, FALSE otherwise. |
IsText
Description | Checks if a value is text. |
Remark | --- |
Example | Ex. IsText([A1]) – returns TRUE if the cell [A1] contains text, FALSE otherwise. |
Null
Description | Returns a null value (Nothing in VB). |
Remark | --- |
Example | --- |
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. |
Next Article: Report Functions - Arithmetic & Geometric