Specifications

IsExpanded
688 InfoMaker
IsExpanded
Description Tests whether a node in a TreeView report with the specified TreeView level
and that includes the specified row is expanded.
Syntax IsExpanded(long row, long level)
Return value
Returns true if the group is expanded and false otherwise.
Usage A TreeView report has several TreeView level bands that can be expanded and
collapsed. You can use the
IsExpanded function to test whether or not a node in
a TreeView report is expanded.
Examples This expression returns true if the node that contains row 3 at TreeView level
2 is expanded:
IsExpanded(3,2)
IsNull
Description Reports whether the value of a column or expression is null.
Syntax IsNull ( any )
Return value
Boolean. Returns true if any is null and false if it is not.
Usage Use IsNull to test whether a user-entered value or a value retrieved from the
database is null.
Examples This expression returns true if either a or b is null:
IsNull(a + b)
This expression returns true if the value in the salary column is null:
IsNull(salary)
This expression returns true if the value the user has entered is null:
IsNull(GetText())
Argument Description
row The number of the row that belongs to the node
level The TreeView level of the node
Argument Description
any A column or expression that you want to test to determine whether
its value is null