Hello,
We have first name and last name of user, and it is store as FN & LN in the kreport.
Now, we want to add new column which will display the FN LN in the output table.
How to do it?
Solution:
In the formula column:
{FN} ." ". {LN}
Solution 2 using an SQL custom function instead of storing the values for first_name and last_name. Drag the field for first_name then then write this code in custom SQL:
CONCAT({t}.{f}, ’ ’ , {t}.last_name)
1 Like
Does this go under the customFunction or Formula column?
goes under custom function
1 Like