In Base Report Design how to I enter a formula here:
I want to put in something like for example CONCAT(FieldName1, ’ ', FieldName2) in for the Data field. It appears that it will take this from the = sign here 
but I can’t figure out how to enter a formula.
I know that I can do this in the underlying query, but it just seemed like I was also able to do this in the Report design editor.
Ciao, use: [FieldName1] & " " & [FieldName2]
If my answer helped you, vote it with 
(here on the left)
Edit: in this file it works:
Please seee my Edit
Ok, Thanks. Finally figured out how to get it to work: after you edit the Data Field you must move the focus out of the Data Field , e.g. by typing Tab or the like. (This is obviously a bug, but I’ve reported so many recently that I’m going to let this one lie for now.)
Also for what it’s worth, some SQL function appear to work, like Pi(), but many SQL function silently fail to work. In particular one of my fields allows nulls, and so when the strings are concatenated by default if either string is null they sum to null which is no good. Normally I use IFNULL(..) or COALESCE(..) to fix this, but neither seems to work, at least not in Mariadb, nor HSQLDB1.8. Also LEFT("abc") returns “a”, but LEFT("abc",2) returns nothing. So, this works, barely.
