Displaying default values in a blank report field

Topic group Related topics

To display a default value in a report to substitute for blank values in a field,

1. Determine the field in which you want to display the default value, and select that field’s Text object in the Inspector (streamSource1.detailBand.<text object>). This example uses the NAME field from the query object, query1.

• Enter an appropriate codeblock into the text property of the Text object (click the tool button in the property box). For example, the following code displays No Value for every blank value in the field:

{||this.form.query1.rowset.fields["NAME"].value == "" ? "No Value": 

this.form.query1.rowset.fields["NAME"].value}