Database and Data Type Functions
- Enoch Poston
- Kevin Meek
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. |