• Login

DataSoft Corporation

Logical Functions

Report Objects Names are case sensitive

When using report objects their names are case sensitive. Example using a sytle. Style1 and sytle1 are different.

Function

Description

Example

Iif(Expression1, True_Value1, ..., ExpressionN, True_ValueN, False_Value)

Returns one of several specified values depending upon the values of logical expressions.

The function can take 2N+1 arguments (N - the number of specified logical expressions):

  • Each odd argument specifies a logical expression;
  • Each even argument specifies the value that is returned if the previous expression evaluates to true;
  • ...
  • The last argument specifies the value that is returned if the previously evaluated logical expressions yielded false.

 

This statement is also helpful for applying a style to objects.  You can set up an expression to change the style of the object depending upon its value or condition.

Example:  iif([balance]>10000,style1,)

Remember Report Objects Names are case sensitive.

Iif(Name = 'Bob', 1, Name = 'Dan', 2, Name = 'Sam', 3, 4)")

IsNull(Value)

Returns True if the specified Value is NULL.

IsNull([OrderDate])

IsNull(Value1, Value2)

Returns Value1 if it is not set to NULL; otherwise, Value2 is returned.

IsNull([ShipDate], [RequiredDate])

IsNullOrEmpty(String)

Returns True if the specified String object is NULL or an empty string; otherwise, False is returned.

IsNullOrEmpty([ProductName])

Thursday, 27 December 2018 Posted in Expressions Constants, Operators, and Functions
 DataSoft Store  Knowledgebase  Contact Us
 Sitemap  Privacy Policy
    Customer Service


Copyright © 2019 DataSoft Corporation All rights reserved.