# Display Full Name

**URL:** <https://community.spicecrm.io/t/display-full-name/790>\
**Category:** KReporter\
**Created:** [March 6, 2026, 4:57pm UTC](https://community.spicecrm.io/t/display-full-name/790 "2026-03-06T16:57:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rsp](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@rsp](https://community.spicecrm.io/u/rsp)\
**Post date:** [March 6, 2026, 4:57pm UTC](https://community.spicecrm.io/t/display-full-name/790/1 "2026-03-06T16:57:09Z")

</div>

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}

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [March 6, 2026, 8:41pm UTC](https://community.spicecrm.io/t/display-full-name/790/2 "2026-03-06T20:41:35Z")

</div>

**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)

---

<div class="post-metadata">

**Author:** ![rsp](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@rsp](https://community.spicecrm.io/u/rsp)\
**Post date:** [March 9, 2026, 1:19pm UTC](https://community.spicecrm.io/t/display-full-name/790/3 "2026-03-09T13:19:15Z")

</div>

> [@maretval](#):
>
> CONCAT({t}.{f}, ’ ’ , {t}.last\_name)

Does this go under the customFunction or Formula column?

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [March 9, 2026, 1:37pm UTC](https://community.spicecrm.io/t/display-full-name/790/4 "2026-03-09T13:37:35Z")

</div>

> [@maretval](#):
>
> SQL custom function

goes under custom function