SQL Expression fields do not display when no records are returned
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.
You can try this :
Under Report Options, check "Convert Database Null values to Default".