Keyword

This section explains ReportLite keywords, such as true, false and NULL, through description and examples.

true

Description:

Boolean yes.

Example:

Example 1: For cell’s Visible property expression, write if(value()==1,true,false), meaning that the cell is visible if the current value is 1; otherwise hide the cell.

Example 2: For cell’s Page Break After Row property expression, write if(value()==1,true,false), which performs page break if the current value is 1; otherwise do not perform the operation.

false

Description:

Boolean No.

Example:

Example 1: For cell’s Visible property expression, write if(value()==1,false,true), meaning that the cell is hidden if the current value is 1; otherwise the cell is visible.

Example 2: For cell’s Page Break After Row property expression, write if(value()==1,false,true), which does not perform page break if the current value is 1; otherwise perform page break.

null

Description:

Null.

Example:

For cell’s Display Value property expression, write if(A1==null, 0, A1), meaning that the cell displays 0 if the current value is null; otherwise it displays the current value..

0xnnn, 0Xnnn

Description:

Data beginning with 0x or 0X, which represents a hexadecimal number.

Example:

Example 1: 0xaf represents hexadecimal number af and the computing result is 175

Example 2: 0XDE represents hexadecimal number DE and the computing result is 222

Example 3: 0XCB/4’s computing result is 50.75

Note:

For the current ReportLite version, it is case-insensitive for this keyword.