85
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
Concatenate doesn't work either in the Excel report builder, but GL00105 does the trick. Many thanks.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (