Exago Logo
Search
Generic filters
Exact matches only

Database and Data Type Functions

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

DataRowCount

DescriptionReturns the number of rows retrieved from the data source when executing the report.
ExampleSuppose report is run to retrieve basic information on 10 employees
DataRowCount() should return 10.

DbNull

DescriptionRepresents a DBNull “value”. Used most often in comparisons instead of an empty string to indicate a missing or nonexistent data value returned from a data object. DBNull applies when a result set is returned from the data object, but it doesn’t contain anything. If the data object is unable to return anything at all, Null() will be returned instead.
Example
  1. Use Conditional Formatting to suppress a row in a report if the data set returned is null.
    CellValue() = DbNull()
  2. A column in a table has no data in at all, and therefore is considered not to exist.

IsEven

DescriptionChecks if a value is an even number. Returns True is the number is even (evenly divisible by 2), or False if it is odd.
Example IsEven(4) – returns True

IsLogical

DescriptionChecks if a value is TRUE or FALSE.
Example IsLogical([A1]) – returns True if the cell [A1] contains TRUE/FALSE, False otherwise.

IsNonText

DescriptionChecks if a value is not text.
RemarkNon Text values include dates, numbers, images and blank cells.
Example IsNonText([A1]) – returns TRUE if the cell [A1] contains non text, FALSE otherwise.

IsNoDataQualified

DescriptionReturns True if no data qualified for the report execution. Otherwise it returns false.
ExampleSuppose report is run to retrieve basic information on 10 employees IsNoDataQualified() returns false.

IsNull

DescriptionReturns True if the argument is NULL or DbNull. Otherwise returns False.

IsNumber

DescriptionChecks if a value is a number. Returns True if the value is a number, or False if it is not.
RemarkDoes not convert text to numbers. Ex IsNumber(“19”) returns False.
ExampleIsNumber([A1]) – returns TRUE if the cell [A1] contains a number, FALSE otherwise.

IsOdd

DescriptionChecks if a value is odd. Returns True is the number is odd (not evenly divisible by 2), or False if it is even.
RemarkReturns #NUM if the value is not numeric.
Example IsOdd([A1]) – returns True if the cell [A1] contains an odd number, False otherwise.

IsText

DescriptionChecks if a value is text.
Example IsText([A1]) – returns True if the cell [A1] contains text, False otherwise.

Null

DescriptionRepresents a null (or Nothing in Visual Basic.NET) “value”. Used most often in comparisons instead of an empty string to indicate a nonexistent reference. Null() applies when a result a data object cannot return anything, and so it returns nothing at all. If the data object is able to return something (i.e. the SQL is executed, but the resulting data set is empty) use DBNull() instead.

Type

DescriptionReturns the type of value.
RemarkReturns 1 if the value is a number, 2 if it is text.
Example Type(“John Smith”) – returns 2.
Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents