SQL Expression fields do not display when no records are returned

[Former Member]

I have a report that uses SQl expression fields to summarize in the Report footer. When the main report does not contain any records the SQL expression fields are blank.

Is there a way to force these SQL expression fields to be evaluated evn when the main report does not contain any records.

Thanks

[Former Member · Accepted solution]

Hi,

You can try this :

Under Report Options, check "Convert Database Null values to Default".