NULLVALUE property

The NULLVALUE property is used to replace the NULL value of a dataset field with the specified value.

Use the NULLVALUE property to display some text when some DATASET field has null values.

NULLVALUE property example

This table shows all the information stored on the contacts table.
Notice that the value "(unknown)" appears on null fields.

    <#DATASET ALIAS="OPEX" QUERYID="19">





    <#/DATASET>

User Name	e-mail	Phone number
<#USERNAME/>	<#EMAIL/>	<#PHONE NULLVALUE="(Unknown)"/>

SQL Sentence No. 19

SELECT * FROM CONTACTS

CONTACTS table.

CREATE TABLE "CONTACTS" (
   "USERNAME"   VARCHAR(128) NOT NULL,
   "EMAIL"   VARCHAR(128) NOT NULL,
   "PHONE"   VARCHAR(32)
);