Concat (concatenate) not working in Excel Reports GP

(0) Share

Report

Posted on by Einar Simonarson

Hi there,

I am trying to combine the account segments in an Excel Report using Dynamics GP 2010. The Excel Report Builder does not seem to recognise the funciion CONCAT even though it appears to be one of the Transact SQL functions.

Any help much appreciated.

Thanks,

Einar

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ian Richardson 4,150 on at

Like (0)

Report

HI Einar

In excel the concat function is actually concatenate. That may explain why it is not working.

Would you be able to link to table GL00105? that tanle has the full account number on it already concatenated.

Ian

Was this reply helpful? Yes No
Einar Simonarson 85 on at

Like (0)

Report

Concatenate doesn't work either in the Excel report builder, but GL00105 does the trick. Many thanks.

Was this reply helpful? Yes No