CAT Not Working in Report Writer GP 2010

(0) Share

Report

Posted on by dakendalliii

175

I am trying to modify a report using Report Writer in GP 2010 and the CAT function only seems to work with constants of type strings. Whenever I put a field into the equation, it doesn't show on the report. Does anyone know why that would happen? I'm assuming it's a bug since I can't find any documentation that doesn't indicate I should be able to concatenate two calculated or report fields as long as they are of type string.

Thanks in advance for any help that can be provided!!

*This post is locked for comments

All responses (2)

Answers (1)

dakendalliii 175 on at

Like (0)

Report

RE: CAT Not Working in Report Writer GP 2010

Tristan - This turned out to be the problem. Thanks so much for your help!!
Verified answer

Tristan Clores 2,812 on at

Like (0)

Report

RE: CAT Not Working in Report Writer GP 2010

Hi DAKENDALLIII,

Use the STRIP function to CAT the 2 string fields together:

STRIP(SOP_HDR_WORK.Customer Name ) # STRIP(SOP_HDR_WORK.Customer Number )

My sample above will print the Customer Name and Customer Number together on one field.

Please let me know if you have further questions.

Kind Regards,

Tristan