Question

CONCAT(,) function report designer

+14

I am trying to utilize the CONCAT(,) formula from IFS Report Designer, but for some reason it is not printing

I have the function using a date and a string, and it is not printing.

concat(concat(tns:CF_MPP_NCR_CREATION_DATE,' - '), tns:STATE)

and one example using only one string, and it is not printing

concat(tns:STATE,’ - ‘)

If I have both for separate without using the CONCAT(,) function it work perfectly.

Any idea how could I utilize the CONCAT() or what am I doing wrong?

Do you happen to have Date or Number Format enabled for that field?

I had a similar issue and it was due to date format being enabled.

https://www.linkedin.com/in/karhualex/

+22

Hi @ZTC ZTC JGOTA

Please use the formatDateTime function to convert the date field into a string and then use the CONCAT. See the example

Cheers!

Damith

DSJ - https://dsj23.me

Sign up